How to open by VBA a "pivot Grath"

M

Martin

The Access automactically generate VBA as below to open a PIVOTTABLE:
DoCmd.OpenForm stDocName, acFormPivotTable, , stlinkcriteria


My question is:
I want to open the "pivot GRATH", how to write this VBA? (--- that is, I
want to open the GRATH of this acFormPivotTable. but I don't know whether
the Englih is GRATH)

Thanks.

Martin
 
B

Brendan Reynolds

I'm guessing, but my guess, for whatever that may be worth, is that you may
want acFormPivotChart, e.g.

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria
 
M

Martin

You help me a lot!

Thanks! :)

Brendan Reynolds said:
I'm guessing, but my guess, for whatever that may be worth, is that you
may want acFormPivotChart, e.g.

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria
 
Í

ÍõÈÙ

gaDFKSJAghdjkaJDKLAhdkja
Brendan Reynolds said:
I'm guessing, but my guess, for whatever that may be worth, is that you may
want acFormPivotChart, e.g.

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria
 
Í

ÍõÈÙ

GJLK
Brendan Reynolds said:
I'm guessing, but my guess, for whatever that may be worth, is that you may
want acFormPivotChart, e.g.

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria
 
Top