Creating a chart in VBA

[JMG]

Help, I am beating my head against the wall

with the query below, how do I output it into a report called "report1" as a
chart?

chart = "SELECT Null AS Expr1, ReportTable.Col7, ReportTable.Col8 AS " &
head2 & ", ReportTable.Col9, ReportTable.Col10, ReportTable.Col11 FROM
ReportTable;"

thanks
JMG

 

[Duane Hookom]

Are you hoping to create a graph? I would recommend that you start with a
report with a graph on it created using the graph/chart wizard. If you need
to change the row source of the chart control, consider changing the sql of
the row source query prior to opening the report.

 

[JMG]

Ok, will do. But is this an oversight with Access? It seems sad that there is
no explicit way to manipulate charts in VBA.

cheers
JMG

 

[Duane Hookom]

You can use code/vba to modify almost every attribute/property of a chart.

 

[JMG]

Can you plesae indicate some online references that provide both notation and
examples.

cheers
JMG

 

[Duane Hookom]

Do a google search on "Access Graph Chart VBA". Also check out this site
with info on the object models
http://support.microsoft.com/default.aspx?scid=kb;en-us;222101

 

[JMG]

Thanks a lot

Cheers

Do a google search on "Access Graph Chart VBA". Also check out this site
with info on the object models
http://support.microsoft.com/default.aspx?scid=kb;en-us;222101

 

[raypiscopo]

JMG,

how did you go? I too would like to manipulate as ms access 2000 graph in
vb/vba

RAy