Alert after a given Time Period

[Guest]

I need ot know is ther a way to create a pop-up or something to alert a user
that a 60 day period has expired and then a 75 day period and then a 90 day
period

 

[Jeff Boyce]

You posted in the tablesdbdesign newsgroup, but this is most likely not a
tables-related solution...

One approach would be to create three procedures, each with a message box,
one for each condition. I assume you have the starting date somehow stored,
as the queries would need to "know" 60 (or 75, or 90) days from what?

Take a look at the DateAdd() function to see one way to, well, add days to a
date. Then compare to the current system date using the Date() function.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/