Creating Pivot charts and tables with OCW10

F

Friedi

Hello everybody,
I am Friedi and I have a problem.
I would like to establish a pivot chart with this component on a form under
MS Access 2002/2003 and programm the layout etc with VBA. The layout
programming is no problem but connecting the recourdsouce being a SQL is.
Putting directly in the property sheet of the Active X Control the
ConnectionString and cmdText (the SQLStatement) , then there is no problem -
if I try to do it under VBA - no reaction. Can anyody help?

Thenks
Friedi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Programming Pivot Tables and Charts 0
OWC11 Pivot Table : Data provider didn't supply any further error 1
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0
Define the size of an Excel Chart (Office 2007)?? 0
office web components: pivot table control (ver/ 11/0) 3
Pivot chart publishing problem 4

Top