Timer form event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to trigger this event once a day at the same time. Any
suggestions.
Thanks,
Stanley
 
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
 
You can use Windows scheduler to open an Access DB even if you are not logged
on to Windows. I use an autoexec macro to run certain procedures. The trick
is everything has to be on your local drive. Also, whenever your logon
password is changed, you need to re-enter it into the scheduler.

Dorian
 
Back
Top