Edit datasheet as Spreadsheet

[no1biscuit]

Ok guys and gals I have a tough one here (at least for me).

I have a subform that I viewed as a datasheet. The customer would like to edit it more like a spreadsheet with the ability to insert rows anywhere in the table, not just at the bottom. My only thought would be to have a hidden field with an order by number that vba will control, then make it a running form instead of a datasheet with buttons to insert a new row, move up, move down, delete, etc. But I thought there may be an easier way since I am guessing that is going to take some considerable coding.

Any suggestions?


Thanks in advance
Thom

 

[no1biscuit]

So since I have not got a response for the masters I feel that it is safe to assume that I will be using a continuous form with a bunch of vb code and an additional buttons to preform the functions. Hopefully I am wrong...

 

[dhookom]

The only way to reliably display records in a particular order is to have a value in the record that describes that order. I am not aware of a simple way to accomplish what your customer would like.

I have only had to do this once and it involved using a numeric double field and finding the average of the two records on either side of where the record needs to be inserted. The user never needs to see the "sorting field" value.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[no1biscuit]

As I figured. I was planning on adding a number field to the table. Running a query to prepopulate all the fields based on there current order. Then vb from there.

Thanks again dhookom.