List items in listboxes

  • Thread starter Thread starter Craig
  • Start date Start date
All that I wanted was the code for producing the each and the next code that
take out the items that where selected and the amount of the selections.
 
Craig said:
All that I wanted was the code for producing the each and the next code
that
take out the items that where selected and the amount of the selections.
Click to expand...


Because Access doesn't provide any native drag/drop functionality, this is
decidedly non-trivial to implement. The links Mr. B posted for you show how
to do it in principle.

So far as I can see, your request involves three pieces of code:

1. Identify the selected items. This information comes from the list box's
ItemsSelected collection, which holds the row numbers of the selected items.
The bound-column data value for any given row can be retrieved from the
control's ItemData property, indexed by the row number; e.g.,
Me.lstMyList.ItemData(0) returns the data value of the first row in the list
box.

2. Handle drag and drop: identify when a drag begins and when the mouse
button is released to drop. Ideally, this would show a special "dragging"
mouse pointer.

3. Do something with the "dragged" row(s) when they are dropped. It's not
at all clear what you want to do here. You'd need to be a lot more specific
in your request.

Part 2, above, takes a *lot* of code, and I don't know if you're going to
get anyone to write it for you for free. Maybe someone who has already done
what you want will post in this thread. Failing that, the Microsoft
examples Mr. B posted should show the way.
 
Back
Top