T
Tom H. Dalton
This a bug that come from way back in Access 2. I have report with a header
that displays some data taken from a query on 3 tables. In the detail is a
graph of some data that is taken from a cross tab query (a normalised
database with results in rows not columns). The query is attached to the
graph by the table/query property for the OLE (MS Graph component) object.
Below that is the Child Link and the Master link properties with a build
button to the right. In the Access 2 version you clicked the build button
and Access would show the two sets of fields that could linked and by
choosing these links the query that bound the graph to main body of the
report would be printed. This has been lost since the 97 version. The error
message that is given is that the OLE object is unbound but yet there is
still the query that fetches the data for the graph in the table/query
property. Is there anyone out there that has idea that I might not have
tried? At present I have to set the graph data query to a control on a form
(normally the one that I call the report from) which is a work around. I
have tried to use the tool provided to create the graph but it will always
return with insufficient data (I have tried a length) may be I am pushing
Access beyond it's capability!
that displays some data taken from a query on 3 tables. In the detail is a
graph of some data that is taken from a cross tab query (a normalised
database with results in rows not columns). The query is attached to the
graph by the table/query property for the OLE (MS Graph component) object.
Below that is the Child Link and the Master link properties with a build
button to the right. In the Access 2 version you clicked the build button
and Access would show the two sets of fields that could linked and by
choosing these links the query that bound the graph to main body of the
report would be printed. This has been lost since the 97 version. The error
message that is given is that the OLE object is unbound but yet there is
still the query that fetches the data for the graph in the table/query
property. Is there anyone out there that has idea that I might not have
tried? At present I have to set the graph data query to a control on a form
(normally the one that I call the report from) which is a work around. I
have tried to use the tool provided to create the graph but it will always
return with insufficient data (I have tried a length) may be I am pushing
Access beyond it's capability!