Editable Crosstab query or similar

[realmfighter]

Hi,

I know it isn't possible to edit data in a crosstab view or pivottable view but is there an easy way around this - a way to create a view where I can select the column heading and row heading (from data in another table), and edit the data in that view (only edit, not append)?

Thanks.

 

[boblarson]

I hate using ActiveX controls due to possible reference issues when used on different computers, but you might be able to use a grid, or FlexGrid, control. I am not sure what the coding requirements are, but you could look into using one of those.

 

[realmfighter]

Well my coding skills aren't any good at all and I've never even heard of Flexigrid, but I'll give it a go!

thanks.


edit: can it be used in access, because search results only show it implemented in vb?

 

[boblarson]

There is a grid control as well as the flex grid. I know you can use at least one or the other, and possibly both, in Access - just like any other ActiveX control as long as you are licensed to use it.

 

[Banana]

Here's a prototype that has a editable crosstab query: Class Attendance Database

Be warned, this has lot of code and takes time to get hang of it.