98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Make some fields read-only on a query
Make some fields read-only on a query
Resolved · Medium Priority · Version 2000
Mon 27 Oct 2008, 16:54Delegate Andrew said...
Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Make some fields read-only on a query
Is it possible to set some fields in a query as read-only, while still allowing editing of other fields?
Wed 29 Oct 2008, 21:41Delegate Mark said...
RE: make some fields read-only on a query
Hi Andrew,
If you create a form to display the queried information or if it is already in a form then go to design view, click into the text boxes for each field you wish to lock, go to properties (right click and select or press F4), then go to Data tab, change Locked from No to Yes.
Regards, Mark (delegate)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |
