<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: [AccessD] updating PivotChart's query</TITLE>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=111261819-02072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=111261819-02072003><FONT face=Arial color=#0000ff size=2>Jim
Hale</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Susan Harkins
[mailto:harkins@iglou.com]<BR><B>Sent:</B> Wednesday, July 02, 2003 11:58
AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] updating PivotChart's
query<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Yes, used the wizard. ;( I'll try
PivotChart view and do it manually and see what happens. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<P><FONT size=2>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.</FONT></P>
<P><FONT size=2>Jim Hale</FONT> </P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>