Popup reminders

[admorales]

Hello
Good day!
I;'m new in this forum. I have an access 2003 database for Contract Monitoring.
I would like a reminder, like 6 months before the expiration date. sample create a Notices:

1. 1st Notice - create pop up reminder, 6 months before the expiration date.
2. 2nd Notice - create pop up reminder, 5 months before the expiration date
3. 3rd Notice - create pop up reminder, 4 months before the expiration date.

I'm not that advanced in programming but is there any way to do this and any code examples.

Thank you & God bless

Jun

 

[pr2-eugin]

Hello admorales, Welcome to AWF..

It sure is possible, but depends how you would want it, in a Form or just a pop up when you open the DB.. A little bit more info will help us guide you in the right way..

 

[admorales]

Hello, Sir Paul

Good day!
thanks for the reply, sir please see attached file on how to create pop up reminder.
Thanks in Advance!

Jun

 

[speakers_86]

Welcome! You've found a good place for this sort of thing.

There are three objects here, the table to store the dates, the AutoExec to run when the db is opened, and the module to store the code that runs.

Have a look at the code, I tried to comment it well; though I'm sure if this is new to you, it won't make sense. Feel free to ask questions.

 

[admorales]

Hi sir,
thanks for the reply, please see attached sample of database sir.
how to create reminder, when the database open, popup message will appear like this, "There are 4 1st notices due on date" would you like see these now? yes/No. how to do that sir. if the notices complete just click the check box..

thank you in advance!

Jun.