How to lock a field on an Access form field protection on a form Microsoft 2007 2010 2013 2016

For Full versions of my videos or to join my mailing list go to :
How to lock a field on an Access form field protection on a form Microsoft 2007 2010 2013 2016
Tom Fragale - Expert Computer Consultant & Trainer
Custom On-Site Trainings , Webinars, and Consulting available
[phone]

Sample files can be found here:
Please share this video:

How to lock a field on an Access form

My Top 10 Most Popular Youtube Videos:

How To Create Mailing Labels from your Excel Data

How to generate a monthly or quarterly or yearly summary report with Excel pivot tables

How to use the Access Switchboard Manager

How to make an Access query using Yes/No Fields

How to generate great Summary reports with a Crosstab query in Access

How to Add data to Excel pivot tables

How to Link sheets in Excel and Link Workbooks in Excel

How to use the if function in Excel with Multiple Conditions

How to calculate years of service and age in Excel

How to calculate the week number in Excel

Contact/Conect with me at:

Tom Fragale
[phone]

Excel Macros Complete

Excel Pivot Tables Complete

Excel Charts

Top 10 Functions in Excel
Newest Videos :
Outlook Tips & Tricks

Word Basics

Excel Basics
Access Queries

[liviuvoica]

Hello.
Thank you for this tutorial.
I have a question regarding this subject. I am building up an accountancy application in access 2010 and for the order and sales invoices I have a form linked with a subform. Moreover, after the user modifies that particular invoice or order he needs to check a box weather or not that document is payed or cashed. And here comes the question: After this operation I want that document to be lock for editing and deleting. Is this possible?

Kind regards.

[DamageInc]

What about a datasheet in a subform, where the subform shows a query that has been ran? I don't see a field lock in my setup.

[MrKockabilly]

This is fine at the Form level. But user can always go to the table and edit that particular field. My question is: can I protect a field at the Table level? As to its usefulness, I'm planning to have a field that's automatically filled with Now() so that when the record entry is posted that info is sort of forever committed as no one could ever change that - at least not easily. Thanks.

[steveanddonnaneumann]

Can we lock an entry after data has been enter. I'm working on a sign-in sheet and once all the information is entered I don't any changes to be made - However, if a change would need to be made it would have to be done by an "administrator"

[vangelispapadakis]

Hello Tom. Thank you for the tutorial. I did what you said on a "short text" field. When I create a new record, Access won't allow me the initial entry, either. What am I doing wrong? By the way, my field is also a Primary Key field, so you can imagine what happens. Alt Ctrl Del. Thank you, in advance.

[PankajKumar-egsw]

Hi Sir,
Nice video. I have question.

Check-box to hide/show columns in subform-

I have multiple checkbox in Form's header and data is showing in subform. If i click on checkbox(Header checkbox) then column needs to be hide in subform and if uncheck column to be show in subform.

[TomFragale]

Hi all. Here's 3 great new PC Training videos: 

How to lock a field in an Access form: 
How to lock a field on an Access form 

How to calculate an absolute value in a Pivot Table in Excel 
How to calculate an absolute value in a pivot table 

How to create an invoice with Paypal 
How to create an invoice with Paypal 


I now have over 300 PC training videos on my Youtube channel, all 
about Excel, Access, PowerPoint, Word, Crystal Reports, SQL Server, and many othe topics. 

All of my videos can be found at 


I am also available for private consulting and seminars. 


Thank you for your continued patronage of this forum. 
Got a topic you want to see? 
Requests are always welcome. 

Enjoy, and please share! 

Tom Fragale 
www.freepcseminars.com 

(215)2801073