Have a log file that posts the count every 10 min.
Run an append query to post the count.
[table], [count], [time]
in a form
The form has a timerInterval (in thousands)
and ONTIMER() event
set the timerInterval to 1000. (this is 1 second, or set your own time interval)
in the ONTIMER() event, this code will execute every second (in our example)
Code:
private mbIsRunning as boolean
Private Sub Form_Timer()
If you want it to fire at a particular time, then
If vTARGTIME = tIME() And Not mbIsRunning Then
mbIsRunning = True
docmd.openquery "qaAddCount"
End If
end sub