How to Prevent Users from Closing Forms in Microsoft Access Unless Specific Conditions Are Met
ฝัง
- เผยแพร่เมื่อ 11 ก.ค. 2024
- 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?
Silver Members and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
• Prevent Close Form EXT...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/PreventCloseForm
LINKS:
Required Property: 599cd.com/Required
Validation Rules: 599cd.com/ValidationRule
Table-Level Validation: 599cd.com/TLValidation
Intro to VBA: 599cd.com/VBA
DLookup: 599cd.com/DLookup
Nz Function: 599cd.com/Nz
MsgBox: 599cd.com/MsgBox
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Your videos are very helpful. Thank you!
Welcome
Thank You, that was REALLY good 😉
Thanks
Went to the joint section and that’s my screen reader is overlooking Dave cost of the memberships. I don’t see a way to find out what it cost and how to subscribe as a member.
599cd.com/Join - it's $5.99/mo for Silver Membership
Wouldn't Dcount have worked better than Dlookup, then Nz would not have been needed?
Certainly. A million ways to skin a cat. :)