Run macro once every hour?

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?
 
S

Steve Schapel

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

Rubie

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.
Click to expand...
 
Top