Popup reminders (1 Viewer)

admorales · Jul 30, 2013

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:

1st Notice - create pop up reminder, 6 months before the expiration date.
2nd Notice - create pop up reminder, 5 months before the expiration date
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 · Jul 30, 2013

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 · Jul 31, 2013

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 · Jul 31, 2013

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 · Jul 31, 2013

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.

Popup reminders (1 Viewer)

admorales

New member

pr2-eugin

Super Moderator

admorales

New member

Attachments

speakers_86

Registered User.

Attachments

admorales

New member

Attachments

Similar threads

Users who are viewing this thread