Search:

If you used MS Access Query builder to make your Access queries, and they use joins of any kind, then they WILL NOT work in Oracle.

This is with Access 97 again, maybe they changed their query...

That is probably true, I mis-read your first post about the 5+ user condition. I know I've used 800 meg access 97 databases with 10+ users on at once and it is pretty bad. It's usable, but only if...

Access 97 database have a file size limitation of 1GB before they become corrupted. They probably upped that size limit in newer versions.

I grabbed the following information from...

Here is a small function that I have used to do this:

Public Function ConvertSeconds(ByVal sngSeconds As Single) As String
Dim intHours As Integer
Dim intMinutes As Integer
Dim...

Leaping from Access, to Oracle is a huge jump. If you have a DBA that can set up the database and maintain it, it's not so large from a developing point of view.

If you have to maintain the...

This just isn't true. :cool:

I've used Access databases that were 1 gig in size (The maximum size of an Access DB) and they work fine. Granted if you have 6 million records in one table it's...

I don't know the field names because it's a conversion program from an access database to an oracle database, and while the structure is the same, the field names are not.

Yes I could manually...

Does anyone know if it's possible to do a query based on the column number in a table and not the column name?

Something akin to:

select *
from someTable
where column1 = 'a' and column2 =...

Heh sorry bout that. I get a little testy when people accuse me of something as stupid as spamming. :cool:

Hmmmm, maybe I'll tell the tech to let me examine the two machines, see if I can find...

I did answer the question...I'm positive the variables aren't abandoned on the live server, the way I have the code set up it automatically redirects my pages if the sessions don't exist.

I'm...

Even if I was, which I'm not, I have two questions for you...

1. How could you not tell? Do I have the same writing style, am I asking the same question and have I spammed this board?

2. Why...

I have two servers at my disposal, a development server and a live server. These two servers are suppose to be identical, they are not, but I can't figure out why.

My problem relates to a session...

Actually BramVandenbon, he was helping the other person. Telling someone to use the search is just as helpful as providing a link.

Just because you don't like it doesn't mean it's not helpful.
...

You couldn't pay me to use Windows 98 on my home machine.

As for the original issue, there is probably another issue on hand. I've written programs in 98 and ran them on a XP box and never...

One bump then I'll let it die. :cool:

I want to know why Format is changing that value of the variable that is being passed to it.

Yes I know of ways to work around this problem without using Format that isn't my concern. Myself and...

I have the following line of code that I'm executing... lblJobSiteBuildingAddress.Caption = maDocHeader(macol_dh_document_job_site_building_address)Where maDocHeader is a variant array and...

I knew I would find something a few minutes after I posted this... go figure:

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=1879&lngWId=1

Michael Woolsey

I wasn't able to find this via the search, probably using the wrong keywords, but regardless I'm still looking for an answer...

How do you determine if you are running your program in the design...

If you are using the MDI environment, you can use the .ActiveForm property. If you aren't using a MDI environment, then it's a bit more tricky and James Stanich is going over that aspect.

MsgBox...

Look up the Format function, that should do what you need it to do.

Michael

Anything that uses dates in a SQL statement (at least with MS Access) needs a # around it.



Hope this helps.
Michael

Maybe I'm mis-reading it, but can't you do something like this?

Me.Text = rs.Field(rs.Field("FirstQryMappedFieldName"))

Hope this helps.
Michael

You could always just run a password protected screensaver.

Just a thought.
Michael

You could also use the Format command:

strContctName = Format(!Vendor_Contact_Name)This automatically converts NULLs to "".

Hope it helps.
Michael

Since they are home made, my object doesn't have the particular attribute.

I suppose I could make my own parent object, I was just curious if VB had something builtin that could handle it.
...

They are custom classes. I'm building them from the ground up.

I have two objects, one object is a child of a different object. Is there a way for the child object to "know" who the parent object is?

Say I have obj1 and obj2 where obj1 is the parent object...

I don't have the answer, but I would think you would have to search the printer creator site. Since not all printers can print double sided you will probably have to communicate with the printer...

Strings can hold a ton of data, more than 65 thousand characters. Perhaps if you can share what error message you are getting, or a code snippit we could help more.

Michael

Ummm, the same way as you would set any other value? rs.Fields("MyMemoField") = strSomeString
Maybe I mis-understand your question.

Michael

If you are going for speed, avoid collections. They are very slow compared to arrays.

Michael

He said he was using a memo field, they can hold a lot more than 255 characters:

Michael

Here is another way of calculating the number of days in the year: Option Explicit

Private Sub Form_Load()
Dim strYear As String
Dim startDate As Date
Dim endDate As Date

...

That's the thing, I don't need (or ask) for the referrer in the popup page. That popup window is suppose to be stand alone outside of my usage of referrer.

It's not a big deal now, I got around...

Check out .AbsolutePosition and .RecordCount when you have those numbers you could determine what is the second last position.

Michael

What circumstances would cause it not to be sent? I'm in a corporate environment so I may have some control over it, if it is something I can fix...

Michael

If you want to loop through all of your records do something like this where rs is your recordset variable:Do while Not rs.EOF 'This loops until it hits the end of your recordset
'Your code here....

Does anyone know why when I do a Request.ServerVariables("HTTP_REFERER") in my ASP page that it will sometimes return nothing (A zero length string)?

The condition it seems to happen (On other...

How about I answer the questions the way I feel they should be answered? You answer them however you feel is appropiate.

Michael