C
Charlie Frankel
recently added Pivot Tables/Charts to my Access application and incorporated
the suggestions on page 578 of Ken Getz's Access 2002 Developer's Handbook
(Desktop) for saving/loading the XML data to recreate a particular table or
chart. I'm using a routine to save and load the data into/from a Memo field
not unlike the sample code in the Chapter 8 sample mdb file. My problem is
that while this method works great for Pivot Tables, the Pivot Charts are not
saving completely or not loading back to show the exact chart configuration
when I saved the data upon closing the form.
On the Form Unload, I have included the following code for both Pivot Tables
and Pivot Charts:
strXML = Me.Chartspace.XMLData
SaveXMLData strXML, mlngReportIndex
On the Form Load event, I set the Me.Chartspace.XMLData to the saved XML
string. The only problem is that when I do this the Chartspace is blank!
I've tried adding or simply only using the PivotTable XMLData and it works
somewhat - the formatting often gets forgotten or the most recent changes
aren't saved for some reason.
Does anyone know if the Pivot Chart can take advantage of the saving/loading
XML the way that a Pivot Table can?
By the way, I'm using Access 2003 - with all of the latest service packs
installed - on a Windows XP Home edition Pentium 4 with 512 MB RAM.
Thanks for your help!
All the best,
Charlie Frankel
the suggestions on page 578 of Ken Getz's Access 2002 Developer's Handbook
(Desktop) for saving/loading the XML data to recreate a particular table or
chart. I'm using a routine to save and load the data into/from a Memo field
not unlike the sample code in the Chapter 8 sample mdb file. My problem is
that while this method works great for Pivot Tables, the Pivot Charts are not
saving completely or not loading back to show the exact chart configuration
when I saved the data upon closing the form.
On the Form Unload, I have included the following code for both Pivot Tables
and Pivot Charts:
strXML = Me.Chartspace.XMLData
SaveXMLData strXML, mlngReportIndex
On the Form Load event, I set the Me.Chartspace.XMLData to the saved XML
string. The only problem is that when I do this the Chartspace is blank!
I've tried adding or simply only using the PivotTable XMLData and it works
somewhat - the formatting often gets forgotten or the most recent changes
aren't saved for some reason.
Does anyone know if the Pivot Chart can take advantage of the saving/loading
XML the way that a Pivot Table can?
By the way, I'm using Access 2003 - with all of the latest service packs
installed - on a Windows XP Home edition Pentium 4 with 512 MB RAM.
Thanks for your help!
All the best,
Charlie Frankel