Listbox drag & drop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JWS315 - 05 May 2005 13:28 GMT

Is there any way to allow users to re-sequence items in a listbox by using
drag and drop, if so where could I find examples for Access 2003/VBA? I have
a sequence number field that I use to sort the listbox and I would like to
enable the ability to change the sequence of an item by draging it to a
different row location and re-assign the sequence number.

Thanks in advance for any help!

Jerry

Reply to this Message

Wayne Morgan - 05 May 2005 13:43 GMT

I don't know of any way to do this with the listbox that comes with Access.
You may be able to find a third party listbox that will do this. The closest
thing I can think of using the Access listbox would be to place two buttons
(up and down) next to the listbox to move the selected item up or down the
list. You could set the AutoRepeat property of the buttons to Yes to allow
the button to be held down and continue to move the item in the list. If you
do, you'll probably need to Requery the listbox after each increment and
include a DoEvents in the code after the Requery to allow the listbox to
refresh so that you can see what is happening.

Signature

Wayne Morgan
MS Access MVP

> Is there any way to allow users to re-sequence items in a listbox by using
> drag and drop, if so where could I find examples for Access 2003/VBA? I
[quoted text clipped - 6 lines]
>
> Jerry

Reply to this Message

JWS315 - 05 May 2005 14:40 GMT

Thanks Wayne - I will give your suggestion a try, it should accomplish what I
am trying to do.

> I don't know of any way to do this with the listbox that comes with Access.
> You may be able to find a third party listbox that will do this. The closest
[quoted text clipped - 16 lines]
> >
> > Jerry

Reply to this Message

Jeff Polack - 26 Jun 2005 18:46 GMT

Not sure if this will be helpful, but I found this in the KB while searching
for something else:

http://support.microsoft.com/default.aspx?scid=kb;en-us;233274

Talks about how to simulate drag/drop functionality.

Best of luck!

> Is there any way to allow users to re-sequence items in a listbox by using
> drag and drop, if so where could I find examples for Access 2003/VBA? I have
[quoted text clipped - 5 lines]
>
> Jerry

Reply to this Message