467,219 Members | 1,382 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,219 developers. It's quick & easy.

How to draw graphs using query and open the form in pivot chart view using vba

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm stDocName, acFormPivotChart
I am using this statement to open a form in pivotchart view.

Also, in the pivotchart view of the form,I dragged the columns that I needed for the graph and when I close the form and reopen the same form with a button click,the form opens up with empty barchart in pivotchart view. Is there a way to populate the graph based on the query while the form is opened in pivot chart view?

My question is: How to create Pivot chart with graphs populated from a query using vba .Could you please provide any sample vba code that runs a query ,creates a pivot chart in a form and then opens the form as a report on a button click. Thanks for your help !
Nov 30 '11 #1
  • viewed: 1149

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by SMBR via AccessMonster.com | last post: by
reply views Thread by bjaj@vestas.com | last post: by
reply views Thread by francophone77 | last post: by
2 posts views Thread by PC Datasheet | last post: by
1 post views Thread by thomas.wordsworth@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.