It really depends on what needs to be done and when. The simplest case would
be that this is something that runs at, say, 2:00 pm, when you are working.
Here is what you might try.
In the OnTimer Event:
Private Sub Form_Timer()
If Time >= #2:00:00 PM# And Time < #2:01:00 PM# Then
MsgBox "Time!" (or whatever code you want to run)
End If
End Sub
Then set your form timer to 60000 (1 minute). Then, once a minute, the form
will check the time and run the code when it is in the 2:00 hour.
This method would only work with access and that form open. There might
also be a better way to format the time.
Does that do it?
PJ