I have got around this using the computers scheduler.
In XP go to Control Panel then scheduled tasks.
Create a new task, click next, then Browse. Rather than browse to a location
enter the text as below but changed to your file locations, including the
inverted commas ("'s), you can select a time that you want the macro to run.
(You will need to have your computer turned on)
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"c:\database\MyDatabase.mdb" /x NameOfMacro
the first part of the above is the full path to your msaccess.exe
the second is the full path to your database
the third is the access switch (/x) followed by the name of the macro.
--
Regards
Chris Cleary
(e-mail address removed)
Chad said:
I was wondering if there was a way to run code at a specific time. For example:
I want a query to run every day at 7pm. If not, can I set it to run
whenever the date changes? eg 12am every day?
