In this Microsoft Access tutorial, I'll show you how to use the Before Update event to cancel the editing of a field if certain conditions are or are not met. For example, you can see if a record is "locked" by a manager and require a password before unlocking it.
Michaela from Winston-Salem, North Carolina (a Gold Member) asks: I watched your InputBox video a few days ago. That was awesome. Thank you. Is there any way to just password protect a few specific fields on a form, instead of the whole form? I want everyone to be able to see fields like credit limit, but I only want managers to be able to edit them if they're locked.
LEARN MORE:
599cd.com/BeforeUpdate
PRE-REQUISITES:
Gray Out Fields: 599cd.com/GrayOut
InputBox: 599cd.com/InputBox
AfterUpdate: 599cd.com/AfterUpdate
RECOMMENDED COURSE:
Access Developer 24: 599cd.com/ACD24
LINKS:
Simple Security: 599cd.com/SimpleSecurity
Access Security Seminar: 599cd.com/Security
Access Data Encryption Seminar: 599cd.com/Encryption
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, beforeupdate, before update, locked, enabled, password protect fields, Confirm Changes using the Before Update Event, BeforeUpdate vs. AfterUpdate, Cancelling a Record Update with BeforeUpdate Event
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Use the Before Update Event in Microsoft Access VBA to Cancel Editing a Field in Certain Conditions
Пікірлер: 14