We help IT Professionals succeed at work.

Access 2007 - how to cancel the closing of the database?

Medium Priority
368 Views
Last Modified: 2012-06-27
Hi Experts,

I'm trying to check for a condition when a form is deactivated. If the condition is true, I really want the user to get the message before they're done with their session. The "On deactivate" event for the form fires when the user attempts to close the database. Can I use the "On deactivate" code to stop the user from closing the database if the condition is true? How would I stop the database from closing?

Thanks!!!
Comment
Watch Question

Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Perfect, thank you.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
You are welcome ...

mx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.