Selecting Data on Continuous Forms

  • Thread starter Thread starter KontactKrap
  • Start date Start date
K

KontactKrap

Hello,

I am using a continuous form to display data to user. Column Names (labels)
are contained in the Form Header and fields (text boxes) are in the Detail
section. The form's record source is a simple SQL statement with a WHERE
clause that limits the records to those applicable to that user. I would now
like to enable the user to highlight (select) a finite number of fields for a
finite number of records then be able to Copy said selected data to the
Windows Clipboard. I am familiar with copying data to the Windows Clipboard
- no help needed there. However, I am clueless as to how I can enable the
user to perform the field selection as described above. I know I can select
a single ENTIRE record using:
DoCmd.RunCommand acCmdSelectRecord
I can also select All records using:
DoCmd.RunCommand acCmdSelectAllRecords
But, selecting only a few fields on a few records within a Continuous Form
is beyond me. All help is much appreciated!
 
That sounds like "fun" I suspect it would be awkward in Access.
You can capture individual fields with a mouse click event and the contents
could be stored in a (sparse) array based on the field name and record ID
(Where is MUMPS when you need it?).
That's the simple way.
I suppose you could use the mouse to select but probably not high light an
area. It knows where it is to a certain extend, then run through code to
pick what you want.
 
Back
Top