𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗔𝗰𝗰𝗲𝘀𝘀 |𝗦𝗶𝗺𝗽𝗹𝗲 𝘄𝗮𝘆 𝘁𝗼 𝗽𝗿𝗼𝘁𝗲𝗰𝘁 𝘆𝗼𝘂𝗿 𝗲𝗻𝘁𝗿𝘆 𝗳𝗼𝗿𝗺 𝗳𝗿𝗼𝗺 𝗲𝗱𝗶𝘁𝗶𝗻𝗴

This video will show on how to protect entry form from editing.

#MIcrosoftAccess #ProtectEntryForm #MsAccess

#VBA Masters
#Sissoko M. Prodev

#Alessandro Grimaldi

✅ Recommended playlists:

Worksheet Basics

Microsoft Excel Essentials

Ms Access Fundamentals Series

Microsoft Access Essentials

[stefanvanzyl]

With a little VBA code, there is a more simpler way to do this. I use it all the time on my forms. On your form load event, put me.allowedits=false. This prevents any editing from being done when the form opens. What I usually do, if a user search for a record and want to view the details of that specific record, it opens that record in another form with allowedits set to false. When they want to edit or update that record, they click the update button and it sets the allowedits to true. Usually I change the caption of my update button when you click update, it changes to Cancel so that it undo any changes made and sets the alllowedits back to false and the caption of the button changes back to Update

[piotrpiotrek]

Thank you very much for another great tutorial. I have used your method in my database and it works! However I have a continuous form and the data is being locked only on specific line I am currently on. I'm a beginner and don't really understand all that Access VBA codes, macros etc "magic" but what I was hoping for is that with clicking a button I would be able to lock certain columns in the form (not the entire form, just some columns). Is there any easy way to do it? Thank you again!

[RamAlaula]

Professor, first of all, I thank you for your good effort with us, but if you provide us with a download link for some of the codes that you use to benefit more, I am following you from Libya and I hope so, and thank you for your effort..