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

ResolvedVersion 2000

Mon 27 Oct 2008, 16:54 Delegate 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:41 Delegate 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)

Thu 30 Oct 2008, 09:40 Delegate Andrew said...

RE: make some fields read-only on a query

Thanks, Mark, that's great.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Make some fields read-only on a query

Make some fields read-only on a query

RE: make some fields read-only on a query

RE: make some fields read-only on a query

Access articles

Access tip:

Deleting duplicate records from a table