Pop up message by time and date

[Gary.]

Hi

I would like to have a message or record to pop up at a certain time and
date not sure how to make it work and help would be apprecaited

Thank Gary

 

[Linq Adams via AccessMonster.com]

Here's a hack I found in my archive. Sorry to say I don't have an author's
name for it. It's designed to pop a message up at a certain time, but you
should be able to easily modify to appear at a given date and time.

Create a form named TimerForm

In Design View Goto Properties - Events
Set Interval Timer to 5000

Create a macro

Under Action select Open Form
Form Name = TimerForm
Window Mode = Hidden
When prompted to name the macro you MUST name it AutoExec

Then in the code for form TimerForm

Private Sub Form_Timer()
If Format(Time, "HH:MM ampm") = "10:30 am" Then
Me.TimerInterval = 0
MsgBox "Your Message Goes Here"
End If
End Sub