alam with due dates in access

[dy]

I'm trying to develop a database that will automatically alarm us on certain dates.
For example, let's say we have different dates set for each items.
A = 6/1/04
B=7/1/04
C=7/15/04

During the dates that I've specified in the table (let's say DueDateTable), I want to be alarmed automatically when the current date is A, B, or C.

Can anyone help?

Thanks,

 

[bat17]

Hi Welcome to the board

How to do it depends on how you use the database. If you open it up each day and just want it to flash up a message box when you open it then you could have a form open on start up and in the Forms open event check the dates.

If the form is open all of the time then you will need to set up a timer event to check every so often to see if it is a valid date.

Peter

 

[dy]

Thanks!

If you don't mind, can you be more specific with instructions?

I was able to find the startup menu in Form DesignView.
How about checking the date?

 

[bat17]

Assuming a table called tbldueDates with a date field called
dDueDates then the Forms Open Event would be

Private Sub Form_Open(Cancel As Integer)
Dim intfound As Integer
If DCount("[dDueDates]", "tbldueDates", "[dDueDates]=#" & DATE & "#") Then
   intfound = MsgBox("Today is a 'Due Date'", vbCritical, "Due Date")
End If
End Sub

HTH

Peter