Date expire alert

[kaza]

I have a problem! I need simple database that will store: name, date of last check and date of next check (usually after 2-3 years). Problem is that I need to be alerted 15 days before next check, using pop-up or something like. Is there solution!

 

[stephen81]

You can write a query which will return any records with the next check date within the next 15 days

i.e.

SELECT TblChecks.Name, TblChecks.LastCheckDate, TblChecks.NextCheckDate
FROM TblChecks
WHERE (((TblChecks.NextCheck)<=DateAdd("d",15,Date())));

 

[stephen81]

I've attached an example for you.

 

[kaza]

Is there any way to run that as backround program and that will alert me on his own? That means I only insert dates and he warns me about date when I start my comp.

 

[stephen81]

You could set your computer up to run the database automatically when you turn the computer on, then you can see if any dates are approaching and close the database once you've dealt with them.

 

[kaza]

I'll try allthough I'd like to try something with macros to learn them too! Anyway thnks!