I have an MS Access 97 database run

[WalkieTalkie]

I have a MS Access 97 database running on a network. Each night the database is closed down.

At the beginning of each month I start up the db, and run a function which in turn runs a series of action queries. (The aim is to append some data from a holding table into an 'active' table, then delete the data from the holding table).

I would like to automate this so that the first time the db is opened by a user at the beginning of each month, the function runs automatically. But its important that the function runs only once each month, and specifically on the first day of each month.

Can anyone help me with this? I am a novice to VBA, so the simpler the better!

Thanks
Miranda

 

[JonFer]

I think I would use a scheduling program to automatically open the database exclusively early in the morning on the first of each month.

To run your queries, have the AutoExec macro determine if the date is the first of the month, runs your queries, updates a table indicating that month has been processed, and then quits Access.

 

[MakeItSo]

Take a look at thread181-715186 (How to schedule a macro). This might help you.

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos