Timer form event

[Stanley]

I would like to trigger this event once a day at the same time. Any
suggestions.
Thanks,
Stanley

 

[PJFry]

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

 

[mscertified]

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