I have an access report that contains a pivot table/chart that is linked to an Oracle view. (Don't let that scare you )
When I change the data, the chart doesn't refresh.
I'm used to breaking down a task and programtically doing the steps
In this case, I am lost.
I manually do the following:
open the report in design mode
Rightclick on the object and pick Worksheet Object- edit
From the Pivot table control, pick the Refresh Data button
It then asks for the Service Name, UserName and Password for the Oracle ODBC connection
I then save the report.
The report is refreshed.
In the interest of driving the report generation and database via VBA in access, this step is critical.
I know if I get to the Worksheet Object, there probably is a .refresh method.
But I dont know how to get there.