Datasheet view

[Blorf]

Problem with MS Access 2000. I want to use a form in Datasheet view that will allow me to not only freeze colums to the left (So they are always visible) but also to freeze rows at the bottom so totals of entries can be seen. I can sort of do this using continous form view, but this view forces the user to scroll through an entire record to move down one row (Or worse, use the mouse!). This project involves a table with approximately 70 fields. Also, I am using VB code to change the names of the fields in the form to match those of the table it is based on (Changing dates that were cross tabbed) and when the data is updated by the user, I will use VB code to un-cross tab back into a normal table. The VB code is already written, and I suspect I
can use VB code to generate the totals at the bottom on the fly. So long as when the user scrolls over to the right, the totals scroll along and line up.

Hope someone can help. I have been reading every source I can come up with to give me ideas.

 

[SteveR77]

A suggestion would be to have a Main Form / Sub Form design.

Where the Main form has fixed field that would display the totals of the datasheet view of the sub form.

Of there may be an ActiveX control that I am not aware of that you give you the XL like features that you are looking for.

Just as a note of caution be careful if you are attempting to get XL features to work in MS Access. While the applications can have similiar looks you will be opening up a Pandora's Box of issues.

 

[Blorf]

I agreee with the Pandora concern. I have already told my employers that what they seek is not possible, and have forced them to use another system. But I became intrigued with the problem, not so much because I need to do it, but because I need to know how to do it, for my own sanity.

Any way,
Thanks.