Run code at timed intervals
You may occasionally want to run a procedure associated with a form at set intervals. To do so, add the code to the form's Timer event procedure. Then, set the form's TimerInterval property to the number of milliseconds that should elapse between each time the code is run. (in Access 2007+, the TimerInterval property setting is a Long Integer value between 0 and 2,147,483,647.)
Keep in mind that you shouldn't use a very small TimerInterval, otherwise your application will likely suffer a performance hit. To prevent the Timer event from firing, set the TimerInterval to 0.
HOW TO: Create a Stopwatch Form in Access
See all Topics