Chart problem - Desperate!!!

[Guest]

Unable to create charts on forms or view a chart created by someone else.
Error message,
"Access cant start the application required to open this object- would you like to repair"
When click on yes to repair, Access tries to install component "application server"
which then ends with the error message
"cant find the file containing the linked ole object you tried to update using the ole/dde links command"

I am using access2002 have tried detect / repair and a complete re-install of access to no avail, dont know what to try now,

please any suggestions!!

 

[Arvin Meyer]

If you really must work with charts in Access, you'll need to re-install
Office. First uninstall it then clean out the registry of the old
installation junk. Then try the reinstall.

I decided some time ago that it was not only easier for me to do charts in
Excel, but I could do better charts. Using the OutputTo method, you can
output your data to an Excel named range or use automation (OLE) you can
just plop the data into specific cells. From there it is easy to have a
prebuilt Excel chart which will give to exactly what you want. There is some
code to show you how to automate Excel at the Access Web:

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Unable to create charts on forms or view a chart created by someone else.
Error message,
"Access cant start the application required to open this object- would you like to repair"
When click on yes to repair, Access tries to install component "application server"
which then ends with the error message
"cant find the file containing the linked ole object you tried to update

using the ole/dde links command"

I am using access2002 have tried detect / repair and a complete re-install

of access to no avail, dont know what to try now,

 

[Van T. Dinh]

Hi Arvin

I believe both Excel and Access use Microsoft Graph to produce charts so
there should be no difference in creating charts whether we use Excel or
Access.

I suppose we are so used to associate charts with Excel so we are more
familiar with the Excel interface in creating charts. We also have to
change out thinking from "relational" to "flat" and ocassionally have to
de-normalise data in the source query to have a flat structure before
feeding to MS Graph.

 

[Guest]

Thanks for comments...

I have just tried re-installing office, and I still have the problem, despite removing registry entries for msoffice, maybe I didnt dig deep enough for all office entries but..... how far to go!!

I am resigned to the fact I have a dodgy office install, but cannot find the problem.

 

[Arvin Meyer]

You are correct. The exact same graphing engine is used by both Access and
Excel. The difference being in the implementation. Excel has a much richer
implementation of the engine and a fuller utilization of the object model.
It is easier to set up a range in Excel that the query will write to using
automation. (at least easier for me.) What I do is create the query
(actually several) in Access and output the data to an Excel worksheet, I
then analyze the results I want to graph.

If I can always reduce the output to a single line in Access, I'll use a
Xtab query and automate Excel. If not, I output to a single sheet and
calculate the greatest number of rows that I'll ever get. Then I'll build a
totals line on that sheet, several hundred rows below that. The totals line
becomes a second named range which is then used to feed the graph.

The problem in Access is feeding the form. Requerying for a graph doesn't
happen like recalculating in Excel. In my system I can continually change
the data and have Excel create a gif or jpg of the graph and feed it back to
Access. A complex dataset usually takes no more than a second to produce
and/or update the form or report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

I guess it depends on the data.

In my case, I graph mostly test results of Quality Control Lab tests. Since
users have different specs that they test, I build a "Pre-Grapgh" form where
the user can specify the results of the specs and the time spans they are
interested in. I then use code to construct the DataSource Query for the
Graph. Using automation , I dynamically set a number of different
characteristics for the graph such as Min & Max of the value (y) axis, where
the x-axis intersects the y-axis, etc...