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
Solved

Lock imported data in access table

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

829 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