If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|