Chart in Excel
 

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.

Chart in Excel
 

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


"NevilleT" wrote:

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.

Chart in Excel
 

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.


"Shane Devenshire" wrote:

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


"NevilleT" wrote:

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.

Chart in Excel
 

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