Add a Boolean field (yes no) called "locked" and a button that sets the value to true, or toggles it.
With the oncurrent event of the form, have me.allowedits = false if the me.locked = true.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 20, 2018 11:33 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] locking individual records
I'm in the process of updating information in a database over a several week period. Each "customer" has more than 70 different fields of data what must be reviewed and there's more than 3,500 customers in the database.
Is there any way to "lock" an individual customer's record so I don't mistakenly change something after I've reviewed and changed an individual customer.
I suspect there isn't, but asking just in case someone knows of something.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar