MACRO

  • Thread starter Thread starter Guest
  • Start date Start date
Garan,

You can use the OnTimer event of a form which will always be open in
the database, to check the time every so often, and run the macro if
your date/time condition is met. This assumes the database will be
open at the time you want to run the macro. If not, you can use a
Scheduling programme such as Windows Task Manager, to launch it at a
specified time.

If you need more specific help, please post back with more details of
what you want, and how precise you need the timing to be.

- Steve Schapel, Microsoft Access MVP
 
I would like to solve the same issue. I have two macros
that I would like to run automatically at various times
of the day. The first I want to run every 3 hours and the
second every morning at 9:00 am. I've been searching
everywhere for the correct coding to put in
the 'Condition' area. Please advise. Thanks in advance.

Rico
 
Back
Top