By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Chart Problem Under Vista

P: n/a
I posted about this problem over 12 months ago and even after Vista
SP1 the problem still exists when running an Access database (A2003
and A2007 tested) under Vista. A workaround was suggested by another
group member at that time, but it's hardly ideal. MS should really
look at this and fix it.

When a form containing a chart is opened the chart object is visible,
but no chart data is visible. If any other form is opened over the
top of the form that contains the chart and is then closed, the chart
data becomes visible. It seems to be a screen painting problem.

Does anyone know if a real fix for this has been posted anywhere that
I may have missed? I am assuming that MS would know about this
problem and have not addressed it.
Sep 13 '08 #1
Share this Question
Share on Google+
14 Replies


P: n/a
On Sep 13, 1:38*am, Wayne <cqdigi...@volcanomail.comwrote:
I posted about this problem over 12 months ago and even after Vista
SP1 the problem still exists when running an Access database (A2003
and A2007 tested) under Vista. *A workaround was suggested by another
group member at that time, but it's hardly ideal. *MS should really
look at this and fix it.

When a form containing a chart is opened the chart object is visible,
but no chart data is visible. *If any other form is opened over the
top of the form that contains the chart and is then closed, the chart
data becomes visible. *It seems to be a screen painting problem.

Does anyone know if a real fix for this has been posted anywhere that
I may have missed? *I am assuming that MS would know about this
problem and have not addressed it.
Wayne

I posted the same issue some time ago; I tried all sorts of
workarounds after trawlling this and other groups and have found that
the only thing that has worked has been upgrading my version of
msoffice to 2007. Charts now seem to display fine.

David
Sep 13 '08 #2

P: n/a
I posted the same issue some time ago; I tried all sorts of
workarounds after trawlling this and other groups and have found that
the only thing that has worked has been upgrading my version of
msoffice to 2007. *Charts now seem to display fine.

David
David, I'm still experiencing the problem using Access 2007 under
Vista. Is anyone else seeing this? It can be replicated by doing the
following.

Create a new A2007 database.
Create a simple table (Table1) and populate a few lines with numeric
values.
Create a new form (Form1) and insert a chart into the form that is
based on the table.
Create another new form (Form2).

Open Form1. The chart object will be visible but no data is visible.
Open Form2 over the top of Form1.
Close Form2.
The chart data in Form1 will now be visible.

Can anyone else replicate this or am I the only one seeing it?
Any feedback is appreciated.
Sep 14 '08 #3

P: n/a
On Sep 14, 4:33*am, Wayne <cqdigi...@volcanomail.comwrote:
I posted the same issue some time ago; I tried all sorts of
workarounds after trawlling this and other groups and have found that
the only thing that has worked has been upgrading my version of
msoffice to 2007. *Charts now seem to display fine.
David

David, I'm still experiencing the problem using Access 2007 under
Vista. *Is anyone else seeing this? *It can be replicated by doing the
following.

Create a new A2007 database.
Create a simple table (Table1) and populate a few lines with numeric
values.
Create a new form (Form1) and insert a chart into the form that is
based on the table.
Create another new form (Form2).

Open Form1. *The chart object will be visible but no data is visible.
Open Form2 over the top of Form1.
Close Form2.
The chart data in Form1 will now be visible.

Can anyone else replicate this or am I the only one seeing it?
Any feedback is appreciated.
Hi Wayne

Yes it does seem strange, but what i discovered in the end is that you
have to requery any chart you wish to see- usually on a form load
event or via another control on event within the form- ie using a
combo selection to requery the data source underlying the graph. I
still had to upgrade to Office 2007 though as I found that with my old
version of Access 2000 and Vista charts just weren't displaying even
after a requery and the only thing that worked was by having another
form pop up over the chart form and then close to reveal the chart-
which seemed very bizarre.

Anyway, I hope that works for you.

David
Sep 15 '08 #4

P: n/a
Hi Wayne

Yes it does seem strange, but what i discovered in the end is that you
have to requery any chart you wish to see- usually on a form load
event or via another control on event within the form- ie using a
combo selection to requery the data source underlying the graph. *I
still had to upgrade to Office 2007 though as I found that with my old
version of Access 2000 and Vista charts just weren't displaying even
after a requery and the only thing that worked was by having another
form pop up over the chart form and then close to reveal the chart-
which seemed very bizarre.

Anyway, I hope that works for you.

David
Thanks for the feedback David. I've found the same thing i.e. a
requery on the form's load event fixes the problem in A2007. However
when using A2003 the requery has no effect, the same as you have found
in A2000. This is a very sorry state of affairs as there are still a
lot of people using A2003. Are there any MVPs reading this who know
if Microsoft is definitely aware of this problem? Given that it's
A2003 that is being effected, I'm not holding my breath waiting for a
fix. Unless someone can pull a fix out of their hat, the only
alternative that I can see when running an A2003 database under Vista
is to open the chart in a report instead of a form, as reports
thankfully don't seem to exhibit the bug.
Sep 15 '08 #5

P: n/a
Br
On Sep 16, 7:17*am, Wayne <cqdigi...@volcanomail.comwrote:
Hi Wayne
Yes it does seem strange, but what i discovered in the end is that you
have to requery any chart you wish to see- usually on a form load
event or via another control on event within the form- ie using a
combo selection to requery the data source underlying the graph. *I
still had to upgrade to Office 2007 though as I found that with my old
version of Access 2000 and Vista charts just weren't displaying even
after a requery and the only thing that worked was by having another
form pop up over the chart form and then close to reveal the chart-
which seemed very bizarre.
Anyway, I hope that works for you.
David

Thanks for the feedback David. *I've found the same thing i.e. a
requery on the form's load event fixes the problem in A2007. *However
when using A2003 the requery has no effect, the same as you have found
in A2000. *This is a very sorry state of affairs as there are still a
lot of people using A2003. *Are there any MVPs reading this who know
if Microsoft is definitely aware of this problem? *Given that it's
A2003 that is being effected, I'm not holding my breath waiting for a
fix. *Unless someone can pull a fix out of their hat, the only
alternative that I can see when running an A2003 database under Vista
is to open the chart in a report instead of a form, as reports
thankfully don't seem to exhibit the bug.
I found sometimes setting the focus to the graph object first helped.

Br@dley
Sep 16 '08 #6

P: n/a
On Sep 16, 1:45*pm, "Br@dley" <brad...@comcen.com.auwrote:

I found sometimes setting the focus to the graph object first helped.
Thanks for the reply. I've found that if the chart object has been
populated with the data, shifting focus from the chart causes the data
to show. This can be done with the timer event, but this is still
sloppy especially if the chart is being populated from a complex query
that takes several seconds to run on a slow machine. The chart object
must already be populated with data before shifting the focus from it
or the data doesn't show. If the timer interval is set for say, 1
second, and the chart doesn't get populated for 2 seconds, the data
won't show.
Sep 17 '08 #7

P: n/a
By any chance that this problem is cause by Windows Aero?

Sometimes it might be cause by your Video card drivers, you can try updating
the drivers.

Wayne wrote:
>I posted about this problem over 12 months ago and even after Vista
SP1 the problem still exists when running an Access database (A2003
and A2007 tested) under Vista. A workaround was suggested by another
group member at that time, but it's hardly ideal. MS should really
look at this and fix it.

When a form containing a chart is opened the chart object is visible,
but no chart data is visible. If any other form is opened over the
top of the form that contains the chart and is then closed, the chart
data becomes visible. It seems to be a screen painting problem.

Does anyone know if a real fix for this has been posted anywhere that
I may have missed? I am assuming that MS would know about this
problem and have not addressed it.
--
Please Rate the posting if helps you

Message posted via http://www.accessmonster.com

Sep 17 '08 #8

P: n/a
On Sep 17, 7:36*pm, "AccessVandal via AccessMonster.com" <u18947@uwe>
wrote:
By any chance that this problem is cause by Windows Aero?

Sometimes it might be cause by your Video card drivers, you can try updating
the drivers.
No, Aero is not the culprit. The problem manifests under all flavours
of the Vista interface.
Sep 17 '08 #9

P: n/a
Sky
>>When a form containing a chart is opened the chart object is visible,
>>but no chart data is visible. If any other form is opened over the
top of the form that contains the chart and is then closed, the chart
data becomes visible. It seems to be a screen painting problem.

Does anyone know if a real fix for this has been posted anywhere that
I may have missed? I am assuming that MS would know about this
problem and have not addressed it.
Hotfix:

http://support.microsoft.com/kb/956054

"When you open a chart object in Access 2007 on a computer that is running
Windows Vista or Windows Server 2008, you see a blank chart."

- Steve
Sep 17 '08 #10

P: n/a
On Sep 18, 5:21*am, "Sky" <sky @ stanley associates . comwrote:
Hotfix:

http://support.microsoft.com/kb/956054
Thanks for the link. This hotfix presumably addresses the problem in
A2007 but the problem still remains in A2003.

Without this hotfix in A2007 a requery of the chart object on the
form's onopen event fixes the problem, but not in A2003.
Sep 17 '08 #11

P: n/a
Good to hear, but what about the video drivers? I have seen related problems
way back with Win95,98 and XP. The results were due to incorrect display
settings and outdated drivers.

Wayne wrote:
>No, Aero is not the culprit. The problem manifests under all flavours
of the Vista interface.
--
Please Rate the posting if helps you

Message posted via http://www.accessmonster.com

Sep 18 '08 #12

P: n/a
On Sep 18, 12:06*pm, "AccessVandal via AccessMonster.com" <u18947@uwe>
wrote:
Good to hear, but what about the video drivers? I have seen related problems
way back with Win95,98 and XP. The results were due to incorrect display
settings and outdated drivers.
Given that MS has released a hotfix for this issue in A2007, I think
that it's more than a driver problem.

Sep 18 '08 #13

P: n/a
According to the Hotfix, it is only for users experiencing this problem. It
is not saying that Access 2007 needs this fix for all users. It was the same
problem way back with Office97, Office2000 with corrupted drivers,
incorrectly set frequency (60Hz) setting above or below the monitor settings
or video card setting out of tune.

Since the hoxfix solved the problem on A2007, in the mean time try it out the
on A2003. It may take some time for MS to come out with a hotfix for this but
it your choice. Who knows, it might work for you.

I am not sure what the hotfix does; but I think the hotfix package resolve
issues by refreshing or readjust the refresh rate to match the hardware
configuration on the PC.
Wayne wrote:
>Given that MS has released a hotfix for this issue in A2007, I think
that it's more than a driver problem.
--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 19 '08 #14

P: n/a
Br
On Sep 17, 12:07*pm, Wayne <cqdigi...@volcanomail.comwrote:
On Sep 16, 1:45*pm, "Br@dley" <brad...@comcen.com.auwrote:
I found sometimes setting the focus to the graph object first helped.

Thanks for the reply. *I've found that if the chart object has been
populated with the data, shifting focus from the chart causes the data
to show. *This can be done with the timer event, but this is still
sloppy especially if the chart is being populated from a complex query
that takes several seconds to run on a slow machine. *The chart object
must already be populated with data before shifting the focus from it
or the data doesn't show. *If the timer interval is set for say, 1
second, and the chart doesn't get populated for 2 seconds, the data
won't show.
From memory when I was doing it I was populating the data via some
complex code and setting chart properties etc.. so I just set the
focus as part of that code.

I think it has to do with somehow activiating the object by giving it
the focus?
When I was doing it it was with Access2000 on WinXP on a range of PCs.
Sep 23 '08 #15

This discussion thread is closed

Replies have been disabled for this discussion.