Search results for query: *

I only have Access 97 and it doesnt seem to recognise (comes up with the error 'expression required)the "AddressOf WindowProc" part of the code. Anyone know why? Kind Regards Liam Corkhill

All Fixed. CurrentDB.Name in PaulF's solution worked, and I modified my code to use the whole DB name. Many thanks to all who responded. Regards Liam Corkhill (Still using Access 97 :-( )

Little Problem :-( CurDir() doesnt seem to return the correct path. My database is in K:\SHIPSDB and it returns D:\MSOFFICE\DBASE. Any suggestions?

Heh :) Thanks.

Is there any MS Access VBA equivalent of the VB App.Path statement? App.Path returns the location of the application. I would like a statement which returns the location of my MDB file. Regards Liam Corkhill

Excellent :-) I thought it would be fairly straight forward!! Thanks all Regards Liam Corkhill

Hi all. I wish to empty a table. I have used the command: DoCmd.RunSQL ("DELETE * FROM tbl_datecheck") which prompts Access to come up with the dialog "You are trying to delete (x) rows .... Do you wish to do this?". I dont want this message to appear. Any suggestions...

Another .... different way of doing it. Set the On Resize event to do a DoCmd.Maximize When your user restores the window, it will maximize again automatically. Hope this helps Liam Corkhill

Mental note.... dont use ASCII diagrams in forum posts.... Sorry new user!! :-( 100.10.10.129 is less than 100.10.10.65 because the "1" in .129 and the "6" in the .65 are being compared. 1 is less than 6, so Access concludes that 100.10.10.129 is less than 100.10.10.65 Hope...

The reason Access is doing that is it performs its sorts on a character basis, from left to right. Therefore: 100.10.10.129 is less than 100.10.10.65 ^ ^ |----- sort character -----| It is performing the sort in this manner because an IP address is...

Woah! I wont ask where you dreamt that code up from, but it seems to work a treat! Many thanks to all who replied to this thread! :-) Kind Regards, Liam Corkhill

Thanks all for your responses. And dont worry nomus1, your feedback was much appreciated :-). The idea of creating a "lock" table had crossed my mind, however the reason I dont want the db opening twice is because I have a "server" which is basically a form running on a PC...

Im not sure, but cant you invoke the Maximize method on the form (i.e. Me.Maximize) ?? Regards Liam Corkhill

Interesting. I tried copy - pasting that code into the Form Load method of my autoexec form. It didnt work :-( Various methods (Open of Connection and OpenSchema of Connection) didnt seem to exist. I have never messed about with the Connection object before so I dont really know how to debug...

As far as I am aware, that will prevent other people from loading the database from elsewhere on the network. This is not what I want. I want a method of preventing a user from loading the application twice on one machine. Regards Liam Corkhill

Hi all. I have an Access application which I do not want users to be able to run more than once on a machine at any one time. Is there anyway of preventing an Access application from being loaded twice? Any help would be appreciated. Regards Liam Corkhill

My apologies for the delay in the response to your messages. I have not had an internet connection for the last few days. Many thanks for your responses. I am going to resume work on this project now and I will try them out :) I will let you know how it goes. Regards Liam Corkhill

Hello. I have a database which should be filled in daily. Unfortunately, as it is being completed by people several hundered miles away (on naval vessels) sometimes they dont fill / send in the data. I need to create a query which gives me a list of dates for which data has NOT been entered...