swap rows by dragging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would anyone know how to code a list in a form where you could swap the rows in this list by drag and dropping the rows to a different position? Basically being able to order the rows by dragging any row to any position.

Hard to describe. Basically, EXACTLY the way tab order box in forms design works. Just like how you can drag and drop the fields into any custom tab order. That's what I'd like to be able to do with a specified list to have a user drag rows and put them in custom order? Is this possible?

Using Access 2000 or 2002.
 
ChapcoRyno,

Drag and drop functionality in Access is complicated to describe. You have
to use a combination of te MOuseDown, Mouse Move and MouseUp events. Here
is a KB article about it.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;287642

HTH,
Josh

ChapcoRyno said:
Would anyone know how to code a list in a form where you could swap the
Click to expand...
rows in this list by drag and dropping the rows to a different position?
Basically being able to order the rows by dragging any row to any position.
Hard to describe. Basically, EXACTLY the way tab order box in forms
Click to expand...
design works. Just like how you can drag and drop the fields into any
custom tab order. That's what I'd like to be able to do with a specified
list to have a user drag rows and put them in custom order? Is this
possible?
 
Use a subform in datasheet view rather than a listbox. Column drag and drop
is built-in functionality.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
ChapcoRyno said:
Would anyone know how to code a list in a form where you could swap the
Click to expand...
rows in this list by drag and dropping the rows to a different position?
Basically being able to order the rows by dragging any row to any position.
Hard to describe. Basically, EXACTLY the way tab order box in forms
Click to expand...
design works. Just like how you can drag and drop the fields into any
custom tab order. That's what I'd like to be able to do with a specified
list to have a user drag rows and put them in custom order? Is this
possible?
 
Access has nothing built-in to allow dragging and dropping within a listbox.
We have an Access tool that might help:

A shareware version of Drag-N-Dropper for MS Access is available at this web
site: http://www.peterssoftware.com/dd.htm It allows listbox re-ordering via
drag-n-drop.


Hope this helps,

--
Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

ChapcoRyno said:
Would anyone know how to code a list in a form where you could swap the
Click to expand...
rows in this list by drag and dropping the rows to a different position?
Basically being able to order the rows by dragging any row to any position.
Hard to describe. Basically, EXACTLY the way tab order box in forms
Click to expand...
design works. Just like how you can drag and drop the fields into any
custom tab order. That's what I'd like to be able to do with a specified
list to have a user drag rows and put them in custom order? Is this
possible?
 
Back
Top