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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top