By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Method to Display Future Popup Messages

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.