Run macro once every hour?

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

 

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

 

[Rubie]

Thanks a lot Steve. I'll give it a try.

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.