troubleshooting Question

Check a field in Access on a Timer

Avatar of mtrussell
mtrussell asked on
Microsoft AccessVBA
1 Comment1 Solution108 ViewsLast Modified:
I have a kill switch in a table.  It is basically a yes/no field that if checked yes, I want to shut down the database and force everyone who is in it to exit.

the table is called tbl_killswitch and the field is called kill.

What I want to do is on the opening form kick off the timer to look at the table every 5 minutes and if the kill field = -1 then close the database.

How do I get the timer to turn on and do this?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros