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:
[ Ссылка ]
PRE-REQUISITES:
Gray Out Fields: [ Ссылка ]
InputBox: [ Ссылка ]
AfterUpdate: [ Ссылка ]
RECOMMENDED COURSE:
Access Developer 24: [ Ссылка ]
LINKS:
Simple Security: [ Ссылка ]
Access Security Seminar: [ Ссылка ]
Access Data Encryption Seminar: [ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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.
