Protecting A Table

[Keith Burgess]

Hi There,

We have a fairly basic contact db at work which we use for incoming enquiries. Users need to be able to make ammendments to one particular field "Comments" after they have spoke to or received a call from someone. What I want to do is protect all the other fields in the table so a user cannot change any data by accident but can still input data into the "Comments" field. Is there a simple means of protecting the other fields, leaving "Comments" avilable for edit???

Regards
Keith

 

[RichardP1978]

Assuming you are using a from for the 'comments' field, cant you just lock the reamining fields on the form, so they cant be changed?

 

[Michael J Ross]

If you are using a form to update the table you can use Locked Property on the Data Tab of the text box to prevent edits being made to the fields that you dont want changing.

 

[MStef]

Hello Keith!

I suggest to inform users that they try to change some data.
Look at "DemoCommentsA2000.mdb".
Open Form1 and try.

 

[Keith Burgess]

Hi Richard,
What I want to do is run a search for the correct enquiry, then enter data into the "Comments" field but protect all the other fields from damage. I can enter the data via a form but how do I link the query that finds the correct entry to the form for editing the comments. I hope this is coming across OK.
Best Regards
KeithB

 

[KeithG]

You can set the forms filter to show the specified record. Also locking your controls will prevent the user from making changes.

 

[Michael J Ross]

Hi Richard,
What I want to do is run a search for the correct enquiry, then enter data into the "Comments" field but protect all the other fields from damage. I can enter the data via a form but how do I link the query that finds the correct entry to the form for editing the comments. I hope this is coming across OK.
Best Regards
KeithB

Set the Record Source of your form to the query (if you use the Forms wizard you can specify the source query or alternatively set the Record Source in the Form Properties to the query), and use the locked property to protect the other fields apart from the comments.

See attached.