Alert Popup message

[mate]

I have a table that includes a Date deadline field. Is
there a way to have a message popup on the day of
deadlines alerting the user? Any help is much
appreciated. thanks, mate.

 

[Steve Schapel]

Mate,

To do this with a macro, all you need is a MsgBox macro action to
display your pop-up alert, and in the Condition column of the macro
design, you would put the equivalent of...
DLookup("[Deadline]","YourTable")=Date()

The next question is, *when* do you want this to happen. This macro
needs to be assigned to an Event. Whenever the database is opened?
When a particular form is accessed or closed? When the user clicks a
button?

- Steve Schapel, Microsoft Access MVP