Timer Type Thing 1

[dschomburg]

How could I Make a timer that would refresh tables or run a macro in regular intervals. Something like every 15 minutes.
Thanks
Dave

 

[jimmythegeek]

Use the OnTimer event of a form. You could have the form open, but not visible if you wish.

Set your Timer Interval to whatever time you want (1000 = 1 second, so 15 minutes would be 900000). And then put your code on the On Timer Event. This will fire the On Timer Event every 15 minutes. Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[dschomburg]

Dude! Sweet! I really can't wait to try this. (Isn't that sad?)

 

[dschomburg]

I don't have the Event "OnTimer" I only have 5 basic Events.
"On Click" "On DblClick" and the Mouse Events. agghhh!

 

[calian]

You are checking the events on the "Detail" section of the Form. Check for the events on the Form itself.

In design mode, double click the large-ish square in the upper left of the form "grid", the one where the rules meet; that should throw up the properties of the form itself. You'll have a couple of dozen events including "On Timer".