Solved

Lock imported data in access table

Posted on 2011-02-18
3
306 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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