Popup Form Help Needed Please.

[Terry DeJournett]

Does anyone know of a way to make a custom message box (a small form that I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry

 

[Guest]

Your application will have to have a form that stays open as long as the
application is open. Then set a TimerInterval for the form and use the
form's timer event to check the current time and open the form at the desired
time.

 

[Terry DeJournett]

I'm not quite sure how to write this code. Do you by any chance have any
example code that you could share?

Thanks,
Terry

 

[Guest]

Private Sub Form_Timer()
Static blnTimeGoneBy As Boolean

If Time >= #9:34:00 AM# And Not blnTimeGoneBy Then
blnTimeGoneBy = True
'Open your form here
End If
End Sub

Set the TimerInterval in design view of the form. the interval is
milliseconds, so each second = 1000
each minute = 60000

 

[Terry DeJournett]

Thank you very much! I'm learning so much from this newsgroup. I really
appreciate everyones time in helping me learn more programming in Access.
Thanks again.

Terry