Automating a pivot chart from access using vba

[jsilveira]

Hi,

I currently managed to automate the generation of a pivot table from information in an access table by clicking one button(all code written in vba). However, I wish to do the same so that my users can click one button and it would now create a pivot chart. I have been looking for a while now, and it seems this is not possible, can anyone confirm this?

I'm using access 2000.

Regards,
jsilveira

 

[PHV]

Have a look here:

http://www.tek-tips.com/viewthread.cfm?qid=1117317

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886