How do I set up a Macro in Access 2003 using the System Time?

[Schulfer]

I would like to set up a macro that will execute based on the system time and
date. Is this possible in Access 2003?
Thank you

 

[Steve Schapel]

Schulfer,

Yes, there are ways this can be done. You can use the Timer event of a
form (which will need to be open at the time) to check the system
date/time at intervals, and execute the macro as indicated. This may or
may not be a good idea, depending on your requirements and the usage
pattern of your database. It may be more suitable to use a Windows
Scheduled Task to run the macro.