Charts in Access 1

[wichtel]

Hello

I want to create charts in Access with VBA but unfortunately, I can't find much in the Access help. Also the Macro record in Excel is not a good help because VBA in Access seems to be not the same as in Excel. Therefore, where can I find a reference guide? Are there good books you can recommend or websides? (For example, how do I know what the different .ChartType are?)

Thanks for your help
Tim

 

[TomHW]

If you add a reference to "Microsoft GraphX.o Object Library" in your program, you can use intellisense and the object browser to get better help with the chart object.

For instance, after adding the reference:

-Press F2 to bring up the object browser
-Select 'Graph' from the combo box that says '<All Libraries>' near the top left
-Select 'Chart' from the Classes listbox
-Select 'ChartType' from the 'Members of 'Chart'' listbox
-You will see 'Property ChartType As XlChartType' at the bottom of the window
-Clicking 'XlChartType' will bring up a list of all of the chart types

You could also have just selected 'XlChartType' from the 'Classes' listbox after choosing the 'Graph' library, or even have searched for XlChartType but this way works best especially if you do not know exactly which enumeration type you are looking for.

Now you can just do some studying of the 'Graph' library to get a better handle on how to use it.

Hope this helps,
Tom