Daily Macro - Form Event

G

Guest

I need to run a macro at a specific time every day. I'd rather not use Task
manager since this involves a secure database. I'd like to use a form that
will open as part of the AutoExec and remain open in the background all day.
I've used the timer event before. Can you tell me how to do something similar
to get the macro to run at a specific time each day rather than at certain
intervals? Thanks, Mary
 
S

Steve Schapel

Mary,

As you suggest, you can have a hidden form open with the Timer event
running. You could set the Timer Interval property of the form to a
suitable value, for example 600000 (i.e. ten minutes). And then your
macro on the Timer event can use a Condition such as this...
Time()>#14:00#
You should put a SetValue action at the end of the macro, to revert the
Timer Interval of the form back to 0, so the macro only runs once.
 

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

Call a macro from commandline with existing autoexec 1
Autoexecut a macro at a specific time 1
Run MacroOnce Daily on Form Open 2
Run macro on startup only if it has not been run previously today 1
Where Statement for Autoexec macro 7
How do I set a macro to run every 24 hours 2
Access Automatically Send a notification email once a record is added 0
Condition expression in an Autoexec Macro 1

Top