Search results

ChDir is no use. The problem is that the folder on the new computer is unknown - it could be anything. The DOS convention is that files are searched for first in the current directory. The default setting is Access changes this. Access defaults to My Documents when the option is blank, and...

In Access 97 tools options general there is a setting for the default directory, which defaults to "My Documents". I have a database which is written on one computer and transferred to another computer, and loaded in a folder of different path and name to the one it was in on the original...

Why do you want the process to stop if the user double-submits the same invoice? If your table structure in your database is set up so that only the one copy of an invoice can exist, you can just bypass the second copy can't you? Unless of course the use is double-submitting a whole file -...

Suggest that you get into the help and find out about collections and properties and stuff. You can "enumerate" the properties/details about virtually any object in any collection. At the right spot you will find in the help examples of code to "enumerate" the objects and their properties for...

I don't think there is an inbuilt function, but what you need to write is a "bubble sort". The technique is simple. You repeatedly search through the array swapping contents of variables if they are higher (descending sort) or lower (ascending sort). Whenever you make a swap you set a switch...

Using DatePart "w" returns the day of the week as a value from 1-7 Sunday, Monday thru Saturday. In your logic, you do not establish what today is. The first thing you need to say is MyToday = DatePart("w",MyDate) Then establish what yesterday is Select Case MyToday Case 1,2,7 'Sunday...

I retract my remark about indenting your code. Mine was beautifully indented and the HTML of this web page seems to have undone it all. :-( No doubt it did the same to you. Sorry! :-) [This message has been edited by David Fletcher (edited 05-11-2001).]

The flaw in your logic is that you must specifically test for the cancel condition and exit the loop when it is found. This is a bit more of a trap for young players than one would expect because Access returns, in this situation a null string ("") both when OK is clicked with no name entered...

I have some access applications that use a lot of common code. I have put this common code in a separate database, and in each application I set up a reference to this separate library database. When finished, both the app and the lib db's are "compiled" as .mde files. When this is first done...