MS Graph Type in Reports

[Striker99]

Hi,

I am fairly new to MS Access but I am learning slowly though! I have done
some work using MS Access 2003. I have a form to allow users to select
criteria. My report produces customised data report and a graph (line chart).
Data is fed through row source using my query.
Now my question is: Is it possible through VBA code to select chart type i-e
pie or bar chart etc when users select criteria from form and based on users
criteria produce type of graph they want in report?
If it is possible then, does any one has example to follow?

Thanks

 

[Duane Hookom]

I think the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane has code
that modifies the chart type dynamically based on user selection.

To create code that modifies a chart control, I usually
- create a similar chart in Excel
- Turn on the macro recorder
- make changes as desired to the chart
- turn off the macro recorder
- copy and paste the code into your form or report
- make a few updates to the code to reference the chart control

 

[Striker99 via AccessMonster.com]

Thanks Duane for your reply. I will look at the link you suggested and the
tip to get relevant code from Excel chart code.

I think the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane has code
that modifies the chart type dynamically based on user selection.

To create code that modifies a chart control, I usually
- create a similar chart in Excel
- Turn on the macro recorder
- make changes as desired to the chart
- turn off the macro recorder
- copy and paste the code into your form or report
- make a few updates to the code to reference the chart control

Hi,

[quoted text clipped - 8 lines]

Thanks