Solved

Lock imported data in access table

Posted on 2011-02-18
3
300 Views
Last Modified: 2012-05-11
I have an access database in which I import data from one of our customers and then our employees enter additional data to add to the data from the customer on forms. Is there a way to lock the data that is imported from our customer in the table and still allow our employees to enter new data on the forms? Just a note the forms within our database do contain continuous forms in which will contain data from the vender and also need to allow the user to enter in the fields also.

Thank you
0
Comment
Question by:MRG_AL
3 Comments
 
LVL 40

Expert Comment

by:als315
ID: 34926318
Are you filling additional fields (empty) to imported records or you like to add new records?
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34926340
add a YesNo field (Lock) to your table
for all imported records update the Lock field to True
include the Lock field to the Record source of the form

in the current event of the form set the locked property of the controls

private sub form_current()

me.text0.locked=me!lock
me.text1.locked=me!lock


end sub
0
 

Author Closing Comment

by:MRG_AL
ID: 34926586
That worked thank you!!! : )
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question