Select random values from query column

[willybgw]

You can select contiguous values from a table or query by clicking in a column, holding the shift key, then clicking in the same column (either up or down) - then you can right click and copy.

Is there a key or combination of keys that will let you chose non-contiguous items?

Thanks for your help.

willybgw

 

[boblarson]

Hold your Ctrl key down while clicking.

Bob Larson
FORMER Microsoft Access MVP (2008-2009, 2009-2010)
Free Tutorials/Samples/Tools:

http://www.btabdevelopment.com

 

[willybgw]

Thanks for the reply. When I hold down the ctrl key it doesn't select the record. I am using access 2000.

willybgw

 

[boblarson]

Oh, sorry - I got confused there for a bit. I don't know of any way to select records like that. What is the purpose?



Bob Larson
FORMER Microsoft Access MVP (2008-2009, 2009-2010)
Free Tutorials/Samples/Tools:

http://www.btabdevelopment.com

 

[willybgw]

The purpose is to allow the user to select account numbers of properties (from a select query of like properties) to use as comparibles (5) to a subject property. These selected acct nos. are then used as input to pull all fields necessary for the comparison calculations.

These numbers can be entered manually easily enough - I just thought if there was a way to do this it would be easier and more accurate.

willybgw

 

[MajP]

What about a multiselect listbox to select the values, or a listview with checkboxes?

 

[MajP]

These images are foxpro, but the same is doable in Access.

http://www.alvechurchdata.co.uk/foxmulti.htm

 

[MajP]

Or you can create paired listboxes:

http://msdn.microsoft.com/en-us/library/Aa167285.405riordan1(l=en-us,v=office.11).jpg

 

[willybgw]

Thanks for the suggestions and examples. But I really just wanted to know if there was any way to highlight and copy non-contiguous items from a given column.

willybgw

 

[MajP]

Nope.

 

[alvechurchdata]

Rather than having the users click on the record to select it can you add an extra boolean field to the query so that users click on this new column and tick the records that they want. You can then write code to pick the records where Selected=True.

Geoff Franklin

http://www.alvechurchdata.co.uk