Solved

Lock imported data in access table

Posted on 2011-02-18
3
269 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 39

Expert Comment

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

Accepted Solution

by:
Rey Obrero 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

760 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now