Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Access 2007 PivotTable Form View VBA

106 views
Skip to first unread message

JAT

unread,
Mar 31, 2010, 7:57:01 AM3/31/10
to
I am trying to use the PivotTable form view via VBA, but I am running into
problems when trying use the properties of the PivotTable.

According the documenation for Access 2002 (I could find no documentation
for 2007 either in Help or on the Microsoft web site):
http://msdn.microsoft.com/en-us/library/aa139960(office.10).aspx

The code to use is:
Dim pTable as OWC10.PivotTable
Set pTable = Forms("FormName").PivotTable
pTable.BackColor = 255

In Access 2007, changing the lines to
Dim pTable as OWC11.PivotTable
Set pTable = Me.PivotTable

Does not work - I get a type mismatch error. If I place a pivot grid ActiveX
control on the form I get no problems .

Is this a bug in Access 2007 that you cannot use the properties of the
Access Form PivotTable?

Regards
Justin

0 new messages