I want to insert a time/date trigger

[JimJones]

Hi.

I'd like to be able to insert some code, which I suspect would
have to be in a global module. I want to have a message box
pop up weekly, or daily, after a certain date.

Let's say August 1, 2003
(example: Please make sure all records to be included in QTR2 are in by close of business, today)
The user would click OK, and not get it again for two days,
and then 2 days later again, and then it stops popping up.

Thanks for your help,
Jim

 

[llkhoutx]

Look at a form's Timer property and OnTimer event.

Not being able to rely on a database always being up and running, create a table with a date field (tbDate) to hold the next time the popup is to be opened. tbDate is checked on the OnTimer event of a hidden form (with appropriate Timer property set) to see if it's time to open the popup.

Don't forget logic for the initial (first time) popup and a popup after the database has been closed (a popup has previously occured) and then the database is re-opened.