Microsoft Graph Chart: Only work on my machine

[MBorofsky]

I have created a variety of reports that use the Microsoft Graph Chart in Access. Unfortunately, they do not work on anyone else's machine. I have looked for references but can't find any that are appropriate. Does anyone know how I make these work on other people's machines?

I am using Access 2003.

Mostly everyone else is using Access 2002....

 

[GingerR]

How do they not work? Does the db open, and reports open, but the graph is blank? Do other things in the DB work properly? When you say "Most everyone else" do you mean some are NOT using Acc2002? What are THEY using? And do the charts work for them?

Try checking your REFERENCES. On someone else's machine, start a new module. from the toolbar pick TOOLS+REFERENCES. see if any say MISSING.

 

[MBorofsky]

The report opens and the graph is blank.

I am not entirely certain the everyone else is using 2002, but I think it is a mostly valid assumption.

It appears that the "Microsoft Graph 11.0 Object Library" is not on anyone else's machine. They have the "Microsoft Graph 10.0 Object Library". If they include 10.0 instead of 11.0, the graphs still appear as blank.

I figure that I need to include it as a reference when I compile and send out. Even though it is included as a necessary reference in the VB code window, it does not come up in the compile screen.

I tried to include the file manually (graph.exe, as it is listed in the references window), but that also doesn't work. I find it odd that it is an executable file and assume there must be other related files I don't know to include.

 

[GingerR]

On your machine, open in design mode. Make the reference to Graph 10 (you'll have to uncheck Graph 11 first), debug+compile, compact, send it out. see if that works.

 

[MBorofsky]

I don't have graph 10.0. I even tried unchecking 11.0 and exiting, then going back in. No 10.0. Someone else did that on their 2002 machine. The graphs still didn't work.

 

[GingerR]

Sorry about that. At work I have 2002, so it was a shot in the dark.

I have 2003 at home. I'll build something this weekend and see how it works at work on monday. Sorry I can't do anything faster for you.

Just more stabs in the dark...does the rest of the database work for the other users? are they able to successfully run the query/table that is the recordsource for the chart? Is this something they have used in the past and it worked ok, and now it doesn't work any more? I just want to make sure it's not a server issue, a bad query, or other things besides the graph thing.

 

[MBorofsky]

I appreciate you trying to help me.

Everything else seems to work fine, though there was one oddity. I created 2 additional tables (Access 2003). When I sent out the database, the tables did not exist on anyone else's machine. I had to create a special subroutine that would look for the table, and on error create it. It was very strange as the file format is 2000 so the tables I created should have been in 2000.....

Everything else seems to work fine 2000/2002/2003. The graphs never worked before, but I made the mistake of letting the client know I had created some new interesting graph-based reports.

 

[GingerR]

re: new tables, that is very wierd.
so are the graphs still not working? did you find out if the query/tables behind them do work? Or do they work now and the issue was the '2 additional tables'?

 

[MBorofsky]

The 2 tables were for a seperate set of reports, I was just mentioning as an additional weird thing.

The graphs still don't work but the underlieing queries do. I am on the verge of calling MS technical support

 

[MBorofsky]

Fixed it. It turns out that I had created a table that the queries relied on that ran the graph. Everything worked fine on my computer because the table existed on my computer. Nothing worked on anyone else's computer because the table didn't exist on their computer. I am creating a subroutine to create and populate that table with the proper data and the problem will be solved. Thanks for your help.