DerekN
07-23-2010, 09:26 AM
Hey!
I'm a coop student on my first workterm. I have been designing a Quality Management System for the company that hired me. I have created all the access databases I need to, but now I need to focus on reporting.
My trouble comes when I try to use VBA with pivot tables.
I'm trying to have a button open a pivotchart. This is easy. Above the chart, however, there is a combobox for the user to select the month. When the button is clicked, the PivotChart should open for the current month by selecting the month from the field category. I just can't figure out any VBA code at all that would work with PivotCharts in access 2007. For example,
How can I declare a chart? Dim Chart As ....? What Refrences should I include?
Any help would be much appreciated.
I'm a coop student on my first workterm. I have been designing a Quality Management System for the company that hired me. I have created all the access databases I need to, but now I need to focus on reporting.
My trouble comes when I try to use VBA with pivot tables.
I'm trying to have a button open a pivotchart. This is easy. Above the chart, however, there is a combobox for the user to select the month. When the button is clicked, the PivotChart should open for the current month by selecting the month from the field category. I just can't figure out any VBA code at all that would work with PivotCharts in access 2007. For example,
How can I declare a chart? Dim Chart As ....? What Refrences should I include?
Any help would be much appreciated.