Autorun macro

[Schwarz]

Hi,
Is there a way to have a macro run in specific hour? But not using Windows
Task Manager. I´d like to set this time in Form.
Thanks
Schwarz

 

[Steve Schapel]

Schwarz,

In the Condition of the macro, put something like this...
Time() Between #13:00# And #14:00#

Assign the macro on the Timer event of the form, and set the
TimerInterval property to a suitable figure in milliseconds. For
example 3600000 which is one hour.

In this example (which I assume I understnad your question), the Timer
event will check every hour, and if the current time is between 1pm and
2pm the macro will be executed.

 

[Joel Allen]

Hello,

I have to chime in on your conversation. I'm trying to accomplish the same
thing. I need to run a macro every hour but don't know how. Will this
timer event work for me? My goal is to just have this macro run every hour,
but not have to have the database open.

Thanks,
Joel