Rearrange Record Sort Order
Sometimes, the sort order of table records cannot be easily determined by simply using the values in its fields. In those cases, it might be necessary to add a "sort order" field where the user will explicitly define the record's sort order within the table.
I’ve had a couple of requests in the forums for a demo on how to easily rearrange or reorder the records based on a “sort order” field value using a GUI. So, I have decided to create a demo based on a couple of methods I have seen while using SharePoint.
When creating or editing a Standard or Datasheet List View in SharePoint, you can set the order of the columns using a combobox. Selecting a number from the combobox sets that columns position in the View from left to right.
When you modify the Global or Quick Launch Navigation for a Site in SharePoint, you can select a Heading or a Link and then use the “Move Up” or “Move Down” links on the small menu bar to change the order of the Navigation Items.
Using the above methods as my inspiration, I created this demo for rearranging records sort order using a form. To download the demo, click on the link on the left bar.
This demo was created using Access 2007 and tested using Access 2007 and 2010.
If you need an Access 2000 version of this demo, please visit UtterAccess.
Updated demo to version 1.1 to combine both methods into one form and use a Standard Module for the sort reordering routines.
Please report all bugs to theDBguy@gmail.com.