How to send an alert based on time

[vince99]

On my form, I have a due date field. I would like for an alert to be sent when the date in this field is reaching the current date ....


Any Ideas????

Thanks in advanced

 

[ghubbell]

Hi again Vince,
If you're using Access 2000 you could use the "Conditional Formatting" Feature to say, change the backcolor of your due date field to bright yellow if, well, due date is overdue!

In 97 (or 2000 if you want to), you have to do a bit of coding to achieve a similar result:

In your forms "On Current" event, add something like this:

If Me![NameOfDueDateField] > Date() then '(date() is today)
Me![NameOfDueDateField].Backcolor = 65535 'that's yellow
Else
Me![NameOfDueDateField].Backcolor = 16777215 'white
End if

If you have the ability to change the due date on the form, then you'd have to add this to its afterupdate event within VB code:

Form_Current

These send a "visual" alert which is in most cases, sufficient enough to catch the users eye. I have used similar many times and found this to work well and not annoy users with popping up messages. Hope this will help you,
Gord
ghubbell@total.net