Run macro once every hour?

  • Thread starter Thread starter Rubie
  • Start date Start date
R

Rubie

I have a macro that I setup in the Access database using Sendkeys. Is there
a way to tell the macro to run once every hour?
 
Rubie,

Yes. You can assign the macro on the On Timer event of a form, and set
the form's Timer Interval property to 3600000 (milliseconds).

Having said that, most experienced Access users would tend to avoid
SnedKeys. There is nearly always a better more stable way of doing the
same thing. If you uare interested in some further advice on this
aspect, just let us know what you are trying to achieve.
 
Thanks a lot Steve. I'll give it a try.

Steve Schapel said:
Rubie,

Yes. You can assign the macro on the On Timer event of a form, and set
the form's Timer Interval property to 3600000 (milliseconds).

Having said that, most experienced Access users would tend to avoid
SnedKeys. There is nearly always a better more stable way of doing the
same thing. If you uare interested in some further advice on this
aspect, just let us know what you are trying to achieve.
 
Back
Top