Tough One - Update Pivot Chart in Access Report using VBA?

[jer99]

I have posted this on other forums and can't seem to find an answer,

I have a report that is based on a Oracle view.
The report contains a chart/Pivot table. I would like to have the chart
reflect the new data in the Oracle view. The refresh option in the object
doesnt do it.

Typically the steps I manually go through to update the chart are this:
Open report
Click on chart object
Click Worksheet Object --> Edit
Two toolbars appear - Chart & Pivot Table
I click on pivot table bar
Click the exclamation mark Update
Then an ODBC box appears asking for my username/password
Then I close the report saving changes when asked.

There has to be a way to do this from VBA.
The Chart itself says it's an Unbound Object Frame. (Someone else made it)
The Data Tab shows it's an
OLE Class - Microsoft Office Excel 2003
display type - content
update -automatic
OLE TYpe - Embedded
OLE Te allowed - Either
Class - Excell.Sheet.8
-----
Name - OLEUnbound338

=======================================

Anyone have any ideas?

Jerry

 

[Eric Legault [MVP - Outlook]]

Wrong forum Jerry - try one of the Access (or Excel?) development newsgroups.

 

[jer99]

Sorry - please delete if you can

Wrong forum Jerry - try one of the Access (or Excel?) development newsgroups.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/