putting grid on access form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make a "editable crosstab"..each row and cell are unique. So
even though the query I uses creates a crosstab (using group by and pivot)
and Access won't let the form using it update the data. I know that each
value IS unique and can be updated.

One way is to detect onclick, put up a prompt. update using a update query
and then requery the form to refresh the data.
The other way is to use a fancy grid thingy, where the user can edit on the
grid. on tab out, or lose focus. update the value they changed back to the
table.

The above can be done reasonably..though its a lot of onclick repetative
code. The last works nicer and I'd rather do it that way. I'm not able to use
the MSFlexGrid in design mode however (bummer) why does MS do that? Is there
another grid I can use...or is PivotTable able to do this?

Any help would be great.
Elvis
 
I'm not able to use
the MSFlexGrid in design mode however (bummer) why does MS do that?
Click to expand...

I not aware that the flexGrid can't be used? It takes a big whack of code to
run and manipulate MSFlexGrid, (as most activeX controls do!). None of the
activeX controls every worked in "design mode" in c++, vB, or ms-access. You
have to manipulate the activeX object via code. And, this applies to virally
all developer platforms. However, the MSFlexGrid should work in ms-access,
but you have to load it up with the data etc. via code (just like you do in
any other development programming environment).

At any rate, the cross-tab query is no updateable anyway. (try editing it in
the query view to see what I mean).

Are you sure you have to use a cross tab here?

Perhaps you can use some kind of side by side idea. There is some screen
shots here that might give you some ideas.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

So, you should be able to use the flexgrid contorl, but you have to write
the code to make the grid work....
 
Elvis said:
I would like to make a "editable crosstab"..each row and cell are unique. So
even though the query I uses creates a crosstab (using group by and pivot)
and Access won't let the form using it update the data. I know that each
value IS unique and can be updated.

One way is to detect onclick, put up a prompt. update using a update query
and then requery the form to refresh the data.
The other way is to use a fancy grid thingy, where the user can edit on the
grid. on tab out, or lose focus. update the value they changed back to the
table.

The above can be done reasonably..though its a lot of onclick repetative
code. The last works nicer and I'd rather do it that way. I'm not able to use
the MSFlexGrid in design mode however (bummer) why does MS do that? Is there
another grid I can use...or is PivotTable able to do this?

Any help would be great.
Elvis
Click to expand...
 
When I try to drop the MSFlexGrid on to the form..I get a "you do not have
licence" error. I know I could dynamically create it..but I'm good at
C++...but not VBA. If there is some sample code on something similar...I
would be most appreciative.

elvis.
 
Back
Top