Graphs - RecordSource editing

[MartinF]

Hi,

I am trying to alter a Graph on a report with this command:

Me.Graph12.Object.RowSource = SQL

However, it produces an error saying that the 'Object Frame doesn't contain an OLE object', but it does, cause it contains the graph that i am tring to edit.

Any ideas?

 

[MichaelRed]

I have generally approached this process by having hte object frame rowsource just be a query. I "manipulate: the query to always generate the recordset of interest for the graph.

There are several properties of the chart object which need to be carefully set to be able to manipulate the graph. I ues the unbound frame and place the ZGraph object in the frame. In this situation, You need to be careful of the Properties of the Unbound Object Frame:

Ole Class
Row Source Type
Row Source
OLE Type
Class

Ms. Access appears to be a VERY picky old lady when negotiating w/ the Ms. Graph applet, and There may be other properties to negotiate using Bound object froame or other controls to hold graphs.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[MartinF]

Hi MichaelRed,

Thanks for responding. I have now got round the problem another way:

The reason the SQL statement for the Graph needed to be altered was because depending on a particular selection off a menu the SQL statement would have to extract data from a certain table. What i have now done is set the SQl statement to a non-existent table name, and then before the report is called a module changes the relevant table name to this non-existent name, and then changes it back afterwards.

 

[accessuserit]

I have a query thath build two series of value
(quality1,price1),(quality2,price2), (quality3,price3), ...
for example(95, 82),(97, 88),(96, 84)in same row (record)

i need to compose a sigle graph with on X axis the quality value, and on y axis the price values of each groups.

if i use only two values or one group(quality1,price1) not have a problem

if i try to use 4 or more values (two or more groups of data) dont work

In need another help to create a tendence line.

Help me

Tanks for all