User-sort

[ListO]

I have a table which needs to be manually put into the order needed by the user. The order required can only be determined by the user.

I am seeking a way to gracefully do this. I've made it work by adding a sequence field for the user to set and then running a sort based on that field, but this is very clumsy.

Ideally, I would like be able to show the table in datasheet view and allow the user to simply grab a record and drag it to the desired position, much like the TAB ORDER window works in design view.

Any suggestions?

 

[S]

I think that the only way to do what you want is to export the table in excel where your users will be able to move and modify the records.
Good luck, S.

 

[Axis]

If you only need simple sorts, here's a solution I've used before. Show the table as a continuous form, with the fields names as buttons in the header. Clicking on the button resets the form record source to a query that sorts for that field, so the user can click on any button and show the table sorted any way they want.