Creating a chart in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Can you plesae indicate some online references that provide both notation and
examples.

cheers
JMG
 
JMG,

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

RAy
 
Back
Top