G
Guest
How do I lock certain columns in a Query. I know how to lock the whole Query
sheet but not individual columns.
sheet but not individual columns.
R
Roger Carlson
You don't. Queries are not spreadsheets. If you really need to do this,
display the data in a Continuous or Datasheet view and lock individual
textboxes.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
display the data in a Continuous or Datasheet view and lock individual
textboxes.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
G
Guest
How is this done because the Query is already in Datasheet view?
R
Roger Carlson
As I said, you can't do it in a query. You'll have to create a form that
uses the query as its record source.
Instructions:
1) Click on the Forms tab in the Database Window.
2) Click the New button
3) In the dialog box, choose Autoform
atasheet and select your query in the
drop-down box.
You will get a form that looks like a query in datasheet view.
4) Click the Design button
5) Select the field you want locked. Note: It won't be a column here, just
a single text box.
6) Click the Properties Button on the toolbar (looks like a hand pointing to
a piece of paper)
7) Scroll down the properties until you come to the Locked property. Set
this to Yes.
8) Repeat for each "column" you want locked.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
uses the query as its record source.
Instructions:
1) Click on the Forms tab in the Database Window.
2) Click the New button
3) In the dialog box, choose Autoform
atasheet and select your query in thedrop-down box.
You will get a form that looks like a query in datasheet view.
4) Click the Design button
5) Select the field you want locked. Note: It won't be a column here, just
a single text box.
6) Click the Properties Button on the toolbar (looks like a hand pointing to
a piece of paper)
7) Scroll down the properties until you come to the Locked property. Set
this to Yes.
8) Repeat for each "column" you want locked.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L