How to schedule a micro

  • Thread starter Thread starter sukhan
  • Start date Start date
S

sukhan

I have a micro that needs to be run every hour. Anyone has
any idea how to do that.
Thanks.
 
You can use the Timer event of a form. If you have a form
that is always open you could use that one, otherwise
create a new one (blank and minimized is OK as long as it
is open). In form design go to form properties, select tab
Event, scroll all the way down and put the macro name next
to "On Timer", then 3600000 next to "Timer Interval"
(interval is counted in 1/1000 sec).

Nikos
 
You could put Macro and all of its components into a
seperate DB. Then use Windows Task scheduler to schedule
the hourly runs. This works well if you have you DB split.

Jim
 
Back
Top