copy-paste-rearrange-drag/drop records in subform

[blacy]

I need to copy, paste, rearrange records in subform for the purpose of creating and revising items in quotes. I am currently using ACCESS 2003 but I can upgrade if I can get this ability. Or if there is another method or tool that I can use for this purpose I could look at that.

When a quote is created we select items from a drop down list but often we need to revise the order or we may need to add something in the middle of the list later.

If anyone can offer help I would be greatful..

 

[dhookom]

Records in a table are like marbles in a bag. They have no order.

You need to add a numeric field that allows you to enter/store a value that identifies the sort order of the item. I would use a numeric double so it would be easy to change a number from 5.5 to 3.25 in order to get it to sort between 3.0 and 3.4. Sort the items by this [SortOrder] field in your subform's record source and then requery the subform in the after update of the [SortOrder] field.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Using Duane's idea here are some ideas of controls to allow you to sort a list.

http://www.4shared.com/file/243834646/e2a2ef98/SortContinous.html

http://www.4shared.com/file/243834684/a019c1b8/SortList.html

I prefer to use a listbox and arrows to move around the sort order. Then save Duane's sort index based on the position in the listbox.