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.

ความคิดเห็น • 8

  • @Everyday_Richard
    @Everyday_Richard 2 ปีที่แล้ว +1

    Your videos are very helpful. Thank you!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @Inquire98
    @Inquire98 2 ปีที่แล้ว

    Thank You, that was REALLY good 😉

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @jamesshelton1124
    @jamesshelton1124 5 หลายเดือนก่อน

    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
      @599CD  5 หลายเดือนก่อน

      599cd.com/Join - it's $5.99/mo for Silver Membership

  • @cuddlyjake
    @cuddlyjake 2 ปีที่แล้ว

    Wouldn't Dcount have worked better than Dlookup, then Nz would not have been needed?

    • @599CD
      @599CD  2 ปีที่แล้ว

      Certainly. A million ways to skin a cat. :)