A weird problem with the chart

[kbsudhir]

Hi All,

I amI am displaying three charts in my Parent Form. These charts get loaded few seconds after the teh form is loaded (I think is delay is due to the time takne by Access to generate the queries associated with these charts).

I also hava a refresh button which when clicked will update the charts with latest data.

From last one week I am facing a weird problem. One of the charts is not appearing.

This not happening to all the users, but only to few. Also it is not necessary that the same user will face the problem next day. Some times the chart wil apprear after clicking "Refersh Charts" Button. Sometime chart will get loaded initially but once the refresh button is clicked it will disapper.....!!!!!!!!!!!

No where in the code or the chart properties the chart has been made invisible.

I am using Access 2003. Thirteen users are using this tool.

Can anyone guid me regarding why this is happening....??????

[geekgirlau]

Is there any reason why the queries would not be generating data for those charts at that point in time?

[kbsudhir]

Logically no.

But is it possible that when network is slow or when the same query is being executed by many users. Access is not able to provide the data.....?????

:doh: :doh: :doh:

Thanks
Sudhir

[geekgirlau]

Shouldn't be, because no matter how long the query takes to run, the report will only display once the query is finished.

[OBP]

This sounds like the Vista/Access 2000-2003 problem, if it is I have not found a fix on my Computer, although there are some to try. One is running Access as Administrator.

[kbsudhir]

I am using Access 2003.

And this application is being used by complete team i.e 11 members.


Really this is so frustrating that Access just acting weird.

:banghead:

Sudhir

[OBP]

Do the problem Computers have Windows Vista running on them?
On mine the Graphs are there in design view but not in normal form mode.

[kbsudhir]

OBP, I am using windows XP & Acces 2003 at office so I do not know how will it respond in Vista.
The Graph is being displayed in normal form mode.

Still I tested the same in my house under Access 2007 on Vista Home Basic. Its working fine. But its the completely different environment compared to my office.

[OBP]

See this thread for possible fixes.
http://forums.techguy.org/business-applications/701896-solved-access-microsoft-graph-not.html

[kbsudhir]

Thanks OBP, I will test this out on Monay as my team has already started using my application for the day.