Excel - Chart in Excel

Asked By Neville on 14-Feb-09 06:11 PM
I posted this on the Access newsgroup but did not get an answer.  I have a
form in Access with a chart which I am manipulating with VBA.  This is the
message I posted on the Access Newsgroup.

I have a chart in a form. When I open the form it is blank until I click
around the form. It then displays. I have tried playing with the Auto
Activate property of the unbound object frame as well as including in the
form open event
Me.oleGraph.Verb = acOLEVerbOpen
Me.oleGraph.Verb = acOLEVerbHide
Me.oleGraph.Action = acOLEActivate
Me.oleGraph.Requery
in various combinations. the acOLEActivate displays the chart but in edit
mode. Has anyone come across this before.




ShaneDevenshir replied on 14-Feb-09 07:26 PM
Hi,

I think the Access group what the correct place for this.  You should let
them know what version of Access you are using.  One reason you may not be
getting a lot of response is that Access is not the app of choice for
charting.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Neville replied on 15-Feb-09 06:18 PM
Hi Shane
Thanks for responding but the reason I posted here was I received no
response from the Access group.  Seems there is much more knowledge about
charts in Excel groups than Access.
Ed Ferrero replied on 17-Feb-09 05:23 AM
Hi NevilleT,

You still need to ask in the Access groups because the charting engine used
by Access is different to the one in Excel.

Also, this sounds more like a form refresh problem than a charting problem.
Try adding commands like
DoEvents
Me.Recalc
Me.Refresh

Ed Ferrero
www.edferrero.com