Moving a record (not the pointer) in a table

  • Thread starter Thread starter Neil
  • Start date Start date
N

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
 
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.
 
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>




.
Click to expand...
 
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
Click to expand...


Rick G
 
Back
Top