B
Bill B
I want to create a chart in Access 2002. When I insert the chart, the
inserted object is of the type Graph.8. I'd like to use VBA to alter aspects
of the chart at runtime but the only references I see are to Graph10 and I
get a type mismatch when I try to set a reference to my chart. Is there some
way to refer to the Graph.8 object in code?
I've also tried inserting a Microsoft Office Chart 10.0 ActiveX control into
the report. This will not let me set up a data connection to tables/queries
in the current database (I'm using the Jet4 provider and I get a 'Database
in Use' error).
So how can I create a graph that I can manipulate at runtime? I need to
insert droplines based on user input.
Thanks,
BillB
inserted object is of the type Graph.8. I'd like to use VBA to alter aspects
of the chart at runtime but the only references I see are to Graph10 and I
get a type mismatch when I try to set a reference to my chart. Is there some
way to refer to the Graph.8 object in code?
I've also tried inserting a Microsoft Office Chart 10.0 ActiveX control into
the report. This will not let me set up a data connection to tables/queries
in the current database (I'm using the Jet4 provider and I get a 'Database
in Use' error).
So how can I create a graph that I can manipulate at runtime? I need to
insert droplines based on user input.
Thanks,
BillB