I have an access report that contains a pivot table/chart that is linked to an Oracle view.
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.