[AccessD] updating PivotChart's query

When you you look at the properties of the objects on the form created by
the wizard I've never been able to figure out how to "get at" the pivot
table object to manipulate it. Actually your question would be a great one
to send to Acceess Office Advisor VB or Smart Access. I've seen very little
written that describes what the wizard is doing under the hood.
Jim Hale

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com]
Sent: Wednesday, July 02, 2003 11:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] updating PivotChart's query


Yes, used the wizard. ;(  I'll try PivotChart view and do it manually and
see what happens. 
 
Susan H. 

 

Did you create it using the Pivot table wizard? If so I have never found a
way to add fields after the fact that the pivot table would recognize. I've
quit using the wizard altogether and have gone to excel templates that I
refresh through code. These spreadsheets can easily be changed to
accommodate new fields.

Jim Hale 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030702/ed3becf7/attachment-0001.html>