Multi-selected records in a form?

[Guest]

Hi,

How can I make some operations on records that are multi-selected on a form?
I found the possibility for a listbox. Listbox1.Selected does the job. Is
there a corresponding way to do something like Me.SelectedRecords or similar?

Thanks
Kamil

 

[Marshall Barton]

How can I make some operations on records that are multi-selected on a form?
I found the possibility for a listbox. Listbox1.Selected does the job. Is
there a corresponding way to do something like Me.SelectedRecords or similar?

You will have toi create a mechanism to indicate which
on=nes are selected. In a single user database, this is
usually done by adding a Yes/No field to the table. Use an
Update query to clear all the records when the form opens.

An alternative that is quite nice is Albert's Multi Select
Example at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

Thanks Marshall,

I was rather looking for a possibility to choose records by clicking on the
record-selector and darkening several of them at the same time. Maybe this
feature doesn't exist.

Albert Kallal's page was full of goodies. Thanks for the tip.

Kamil

 

[Marshall Barton]

There is no built in mechanism for selecting random records
in a form. You can select a contiguous block in
datasheet/continuous view and use the form's SelTop and
SelHeight properties to figure out the start and how many
were selected, but that's useless for randomly selecting
records.