Prevent Closing Forms Unless Conditions Are Met

In this video, I'll show you how to prevent your users from closing forms in your Microsoft Access database unless specific conditions are met.

Saul from Angel Fire, New Mexico (a Platinum Member) asks: I have a questionnaire that I require my employees to fill out whenever they add a new customer to the database. I don't want them to be able to close the customer form unless they've filled out the questionnaire form. Is there any way to prevent this?

Members

Members will learn how to prevent users from closing forms with even a shortcut key, and will also learn how to prevent users from closing the Access application window without specific conditions being met. We'll learn about the On Unload event and how to cancel it. 

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Required Property: https://599cd.com/Required
• Validation Rules: https://599cd.com/ValidationRule
• Table-Level Validation: https://599cd.com/TLValidation
• Intro to VBA: https://599cd.com/VBA
• DLookup: https://599cd.com/DLookup
• Nz Function: https://599cd.com/Nz
• MsgBox: https://599cd.com/MsgBox

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, disable X close button microsoft access application, prevent close form, prevent close application, How to Prevent a User Closing A MS Access Form, prevent access from closing, disable the windows close x, close button, control box, max min buttons, disable ctrl-f4, disable alt-f4, on unload event, prevent form close, stop form close