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

Thank you

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

--
Good Luck
BS"D


"MaryE" wrote:

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

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).

--
Steve Schapel, Microsoft Access MVP

MaryE wrote:
> I need to run a macro every hour that will refresh data for users. How can
> this be set up?
>
> Thank you