pivot chart within form

garbett_d

Registered User.
Local time
Today, 20:01
Joined
Jan 28, 2003
Messages
36
Me again lol! :)

Is it possible to put a pivot chart into a form? just looking at it now and im not sure?

Cheers
Dan
 
Yeah its posible, but you have some specific problems dealing with column names....

Regards
 
so it is possible but would be difficult?
 
Not that difficult but your column names will be changing (probably) which make it hard. Access and forms work (in principle) with fixed column names (fields). With using In in a crosstab you can force empty columns.

That is the one thing which makes it hard is if you have changing column names. But if that is needed then you can catch that with some VBA coding changing the bound columns of the controls "on the fly". Then your left with the expansion problem for a crosstab can have a different number of columns depending on the parameters and stuff... again In might be your sollution

Short conclusion, depending on the crosstab it can be quite easy or quite hard to put it into a form.

But why into a form? The resulting recordset of a crostabb query is NEVER updatable....

Regards
 
i guess it was just something we were looking into and they said would be a good idea, but could be a problem as they will need to be updated?
 

Users who are viewing this thread

Back
Top Bottom