RE: [MS_AccessPros] locking individual records

 

You can shorten that code to this:

Me.AllowEdits = Not Me.Locked

 

But I suggest a different name for the field since "Locked" is a property name. Maybe "Reviewed".

 

Regards,

Bill

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, February 21, 2018 6:47 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] locking individual records

 

 

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: "Bill Mosca" <wrmosca@comcast.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___