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

Can you have a message box appear at a specific time each day

P: 1
Hi! I have an access database that I access each day and complete updates. I would like a message box to appear each day at 8:30 am reminding all users to exit so I can perform the updates. Can this be done? I have been playing around with the form_timer function but I canít get anything to work. Thanks in advance!
4 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,385
Neonblack510,

Welcome to Bytes!

First, I would recommend that you only do this with a compiled DB in .ACCDE format. This ensure folks can't mess with your DB or close forms they shouldn't.

Second, I have something similar to this, in that whenever any of my Users open our DB, I have a form open in hidden mode and its sole purpose is to run the timer (I think I have it set for every 60 seconds). It checks the status of the DB and whether or not I've told it to close on the user's system.

You can do something very similar to this. Open a form in hidden mode and run the timer. Have it check for the time of day, and if the time passes your threshold, then just have the DB quit, or have another form pop up that tells them to quit.

All relatively simple in concept and execution....

Hope this hepps!
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.