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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 Office Access 2003 Macros 0
Setting Conditions in Macros in Access 2003 4
Using Set Value in Multiple Forms 4
Echo On = No crashing macro in Access 2007 7
Access 2003 - Basic Macro Help 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Record Macros in Access 2003? 1
Set Warnings not trusted in Access 2007 3

Back
Top