Moving a record (not the pointer) in a table

[Neil]

Hi
Is there a way to move a record from one position to
another position by using drag and drop method? I am
looking for a method similar to View -> Tab Order in
Access forms where you can change the tab order of a form
by dragging selected row(s) to move them to a desired tab
order

Thanks

Neil

 

[Ken Snell]

A table does not store records in any specific order; thus, "moving" a
record will not accomplish anything. All data records are "ordered" in
ACCESS by the "ORDER BY" clause in queries and by the "SORTING & GROUPING"
option in reports.

 

[Guest]

Thanks Ken for your quick response - Neil

-----Original Message-----
A table does not store records in any specific order; thus, "moving" a
record will not accomplish anything. All data records are "ordered" in
ACCESS by the "ORDER BY" clause in queries and by the "SORTING & GROUPING"
option in reports.

--
Ken Snell
<MS ACCESS MVP>




.

 

[RSGinCA]

There's no way to do it without some work.

You'd have to modify your table by adding some kind of sequence field and then
sorting on that field.

Then, if you wanted a capability like the drag and drop method in the Access's
Tab Order window, you'd have to do all the coding to implement that.

Rick

Subject: Moving a record (not the pointer) in a table
From: "Neil" (e-mail address removed)
Date: 2/6/2004 6:47 PM Pacific Standard Time
Message-id: <[email protected]>

Hi
Is there a way to move a record from one position to
another position by using drag and drop method? I am
looking for a method similar to View -> Tab Order in
Access forms where you can change the tab order of a form
by dragging selected row(s) to move them to a desired tab
order

Thanks

Neil

Rick G

 

[Peter De Baets]

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

Hope this helps,