Update Crosstab Query's Values in Flexgrid

[ShredDude]

I've read several posts on these boards regarding the desire to change data in the matrix view that a crosstab query provides, and the dillemas associated with this task.

I discovered this link... http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=429&KW=listbox&PID=425#425

with an example DB utilizing the MSFlexgrid ActiveX control. It appears to do what I'm hoping to accomplish, however when I try to implement this approach in my own form, I'm confronted with a window claiming I do not have the license required to use this control when I try to insert the MS Flexgrid control into one of my forms. I'm using Access 2007 on Windows XP. I've successfully utilized other ActiveX controls from the same lsitbox of choices that Access presents however.

Does anyone know what the deal is with that?

Also, there is another "Flexgrid" control offered in the list of choices named: " Vidoesoft FlexArray Control" I can insert that into a form without the Required LIcense issue, but I haven't tried programing it yet. Anyone have experience with the object model of that control?

Having the ability to allow users to update a certain set of Data Variables in a matrix format would make my app much nicer. Right now I facilitate it through a Split Form; the user can adust the number of rows displayed in the underlying datasheet with the Filtering tools on the column headers, and then sort to get the data in a format that makes data entry easier. they can then either update directly in the underlying datasheet, or the text boxes on the top of the split form. A matrix would eliminate this and make my users happier.

Any ideas?

 

[HiTechCoach]

I've successfully utilized other ActiveX controls from the same lsitbox of choices that Access presents however.

If I understand what you are doing, the list you are seeing is all the library files installed on the computer by any software program installed on your PC. Just because it is in the list does not mean that it can be used with Access.

The demo you provided a link to states :

This demo program shows how to display a Crosstab query in a Flex Grid control on a form.

I don't think it is for editing the data. Only displaying it.


About the VB6 FlexGrid control:

You must have a design-time license to use Visual Basic 6.0 ActiveX controls.

from:
You receive an error message "You do not have a license to use this control" when you use Visual Basic 6.0 controls

AFAIK, to use the control in design-time, you must purchase VB6.

 

[ShredDude]

OK, thanks. I do not have VB6 installed on this machine. Perhaps thats the source of the message.

With regards to the task at hand, hte Demo DB referred to doesn't really show updating the values directly in the flexgrid, it merely produces a from when you click in the cell of the flexgrid, within which you can then update a value.

I've been playing with that concept in my context where I display the results of the crosstab query in a datasheet view, and have OnClick event code that brings up a form with the value in that field of the crosstab's results when the user clicks that field. In that second form the user can change the value, then I requery the original form with the crosstab query results to display that it has been changed.

Is this the best way?

Basically, I want to present the existing data in a matrix format, which the crosstab query facilitates nicely. Then, allow the user to click on a value in the resulting matrix to change it. Is popping up another form the best way to meet this requirement?

I'm just trying to learn. I'm sure there are many ways to achieve the same end.

Thanks for the inputs.

Shred

 

[HiTechCoach]

Is this the best way?

If it makes meets your goals, then it is.