How can I automaticly run a macro every hour?

[Guest]

I need to run a macro every hour that will refresh data for users. How can
this be set up?

Thank you

 

[Guest]

I assume that the data dispayed on the Form, in that case use the Form
OnTimer event.
Check this link on a sample on how to do that, but instead of refresing the
clock run the Refresh on the form

http://www.mvps.org/access/forms/frm0032.htm

 

[Steve Schapel]

Mary,

With the form from which the macro will be run, open it in design view.
Assign the macro on the On Timer event property, and set the Timer
Interval property to 3600000 (this is milliseconds).