[MS_AccessPros] I could use help locating documentation for the PivotChart object - also staill having trbl with datasheet/datatable

 

I could use some help locating info/documentation on the Pivotchart Object, similar to the MS Graph Object Model reference. At present I have not been able to find a way to toggll (Hide/Show) the data table for the PivotChart. The code beow is what I am using to toggle the dataTable for the Graph object, I am attempting to perfrom the same for the PivotChart via VBA.

With Me![Graph5].Object.Application.chart
  .hasdatatable = True
End With

 

I have attemted to use the Macro recorder in Excel and retro-fit the code to VBA, but I often have difficulties with alterring the code to succesfully work in VBA/MS Access.

Terence

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___