Access VBA Macro Programming

Timer

The Timer is a useful event if you want to run a procedure at a fixed time interval, such as

re-querying the report so the data is not stale due to the actions of other users:

Private Sub Report_Timer()

Me.Requery

End Sub

You need to set the Timer Interval in the report properties sheet. It is set to 0 by default

(which means it never runs). It is measured in milliseconds and the maximum value is 65536,

which equates to about a minute. Do not set this to a very low figure (below 1000) since your

timed procedure will then be constantly running and no one will be able to use the report.

122 Microsoft Access 2010 VBA Macro Programming