View Full Version : Reminder date


kingjams
07-08-2008, 06:04 AM
Hi Experts:

I am a novice who is anxious to reach expert level. I would like to write a query that will generate a reminder for a due date. For example: If I am to do a check up every six months and I want to be reminded a day or two before the due date, how do I write the query? Eventually, I would like to generate a form that pops up with all the itrems or persons due for check up. Your help in this matter is greatly appreciated. I have a test coming.

rainman89
07-08-2008, 06:10 AM
you can do a check something like

if dateadd("d", 2, date()) = yourduedatefield then
msgbox "Due date in 2 days"
end if

something like that

namliam
07-08-2008, 06:11 AM
Well you can use the dateadd function to find any date you want. then use that Dateadd function in the Criteria for your due date and you stick the query as rowsource for the form and you should be done.

Edit:
Rainman xposted with me.

kingjams
07-08-2008, 06:48 AM
Hi rainman89 & namliam:

Thanks for you reponse. I have not yet tried your suggestion but as soon as I have tried them I will let you know how I did:eek:.

kingjams