Daily Macro - Form Event

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top