Alert after a given Time Period

M

mikeinohio

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
 
J

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Request Form - Alert Team Member 0
Alerts 0
allocate resource over long period of time 0
After Update: Pay Period Date 1
A couple questions BEFORE using Office 365 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Month days over a time period 5
shut down access after 30 day trial 1

Top