Method to Display Future Popup Messages

[Dalan]

I would like to incorporate a feature in an Access 97 database that
would display popup messages at predetermined times in the future -
say every three months. This would be applied to several of a dozen or
so forms. Of course, would need to include the contingency that the
database would not necessarily be opened on the set day of the message
display. I presume that a separate one-line Yes/No table could
function as the switch to display the message once and then turn off.

Any ideas or suggestions will be welcomed. Thanks.

[Mike Storr]

If the pop-up is form and date specific, then maybe make a table like

tblPopUps
-----------
FormName
ShowDate
ShowFrm

Create either an array or a collection that loops through the table and
gathers all the settings stored here - one array item or object per row in
the table. Then in whatever event that would open this form is used, check
the array/collection for the neeed setting, open the form if marked to show,
otherwise don't.
Doing this allows you to change the array/object value so that it dosen't
need to happen during the current session, and you can write back to the
table either a new date, or unmark the form for showing so that it dosen't
happen in other sessions until it is needed.

Mike Storr
www.veraccess.com
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

I would like to incorporate a feature in an Access 97 database that
would display popup messages at predetermined times in the future -
say every three months. This would be applied to several of a dozen or
so forms. Of course, would need to include the contingency that the
database would not necessarily be opened on the set day of the message
display. I presume that a separate one-line Yes/No table could
function as the switch to display the message once and then turn off.

Any ideas or suggestions will be welcomed. Thanks.