Creating a date / time reminder

[DasT]

I am currently creating an access database in which i need the database to show a reminder on a set date within different records in the database (i.e. there will be roughly 50 records, each with a due date) Is is possible to make access show a message box, or otherwise some kind of reminder on the set date? and if possible a set time as well?

thanks for your help

 

[DasT]

I now know how to make a message box appear ^_^ (a bit premature on the post)

If db2.[Form_Company contacts1].Action_Date = Date Then
MsgBox ("hello")
End If

End Sub

pretty simple now i think about it, but i now need to know if its possible to make the message box show something other than a simple piece of text, e.g. a column in one of the records, which will show specific instruction in text, and also how this would work if the DB was constantly open, rather than only showing the message when opened.

sorry if i havn't explained very well, access newbie

thanks for any help