 | |
Getting To A "Chart" Object From VBA?
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Getting To A "Chart" Object From VBA? -
03-31-2011
, 09:25 AM
#2
| |||
| |||
|
|
Using Insert | Chart, I added a chart object to my report. Ole Class = Microsoft Graph Chart Class = MSGraph.Chart.8 But when I try to instantiate it in VBA, something is wrong: ------------------------------------------------ 1002 Dim myChart As Object 1010 Set myChart = Me.chtWACQ 1020 With myChart 1021 .Activate 1022 .HasLegend = True 1999 End With ------------------------------------------------ Starting with line 1021, I get "Error# 438: Object doesn't support this property or method". OK, maybe we need the object within.... ------------------------------------------------ 1002 Dim myChart As Object 1010 Set myChart = Me.chtWACQ 1020 With myChart 1021 .Activate 1022 .HasLegend = True 1999 End With ------------------------------------------------ I'm missing something. What, besides the line numbers, is the difference |
Quote:
|
But now line 1010 throws "Error# 2771: The bound or unbound object frame you tried to edit doesn't contain an OLE object. I've been here before, decided it was hopeless, and reverted to creating my charts on Excel spreadsheets. But now it's crunch time: this thing just *has* tb on an MS Access report. The .Activate and .HasLegend are just placeholders to see if I've got the refs right. Once I can get to the chart object, I will do a lot more. Seems like I'm doing something dumb, but what? |
chtWACQ is an ObjectFrame object that has a property called Object that
contains a reference to the contained object. Try:
dim myChart as Chart
set myChart = me!chtWACQ.Object
etc.
#3
| |||
| |||
|
|
I'm missing something. What, besides the line numbers, is the difference between these two code snippets? None. RCI on my part. |
The second one shb, per your suggestion, "Set myChart -
me!chtWACQ.Object.
Quote:
|
Failing to be explicit. chtWACQ is an ObjectFrame object that has a property called Object that contains a reference to the contained object. Try: dim myChart as Chart set myChart = me!chtWACQ.Object etc. |
that Access throws when I do chtWACQ.Object suggests to me that
it does not contain an object.
i.e. "Error# 2771: The bound or unbound
object frame you tried to edit doesn't contain an OLE object."
--
PeteCresswell
#4
| |||
| |||
|
|
Per Bob Barrows: I'm missing something. What, besides the line numbers, is the difference between these two code snippets? None. RCI on my part. The second one shb, per your suggestion, "Set myChart - me!chtWACQ.Object. Failing to be explicit. chtWACQ is an ObjectFrame object that has a property called Object that contains a reference to the contained object. Try: dim myChart as Chart set myChart = me!chtWACQ.Object etc. Intuitively, I get the "ObjectFrame" distinction, but the error that Access throws when I do chtWACQ.Object suggests to me that it does not contain an object. i.e. "Error# 2771: The bound or unbound object frame you tried to edit doesn't contain an OLE object." |
for me". Sorry
#5
| |||
| |||
|
|
My attempts to reproduce your error have failed. All I can say is "It works for me". Sorry |
the model that various web pages refer to actually works.
Gonna check my references next - make sure I've got the right
stuff behind them.
After that, on the assumption that I'm doing something dumb when
creating the chart object via the UI, I'll try to revert to 100%
VBA code... creating the object and all...
--
PeteCresswell
#6
| |||
| |||
|
|
Using Insert | Chart, I added a chart object to my report. Ole Class = Microsoft Graph Chart Class = MSGraph.Chart.8 But when I try to instantiate it in VBA, something is wrong: ------------------------------------------------ 1002 Dim myChart As Object 1010 Set myChart = Me.chtWACQ 1020 With myChart 1021 .Activate 1022 .HasLegend = True 1999 End With ------------------------------------------------ Starting with line 1021, I get "Error# 438: Object doesn't support this property or method". |
certain events. In general, I wouldn't expect this kind of thing to
work, since you can't do anything like this with subreports.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#7
| |||
| |||
|
|
Where are you putting the code? Certain objects do not exist for certain events. In general, I wouldn't expect this kind of thing to work, since you can't do anything like this with subreports. |
I want to beautify the graph in a manner that does not seem tb
supported by the UI.
Specifically, I want to replace the numbered tick marks on the
Y-axis with labels like "AAA", "AA", "AA-"... and so-forth.
The values determining the height of the bars are actually
numerical representations of security ratings. 2.75 = AAA, 2.5
= AA, 2.25 = AA- and so-forth.
But the user doesn't know from the numbers. They are an
internal artifice used to create averages and weighted ratings.
All the user knows from are the alphabetic ratings like "AAA",
"AA", "AA-" and so-forth.
--
PeteCresswell
#8
| |||
| |||
|
|
Per David-W-Fenton: Where are you putting the code? Certain objects do not exist for certain events. In general, I wouldn't expect this kind of thing to work, since you can't do anything like this with subreports. Report_Open(). |
report's Open event, if I'm not mistaken. It's like the difference
between OnOpen and OnLoad in a form.
If you want to make changes, you'll have to do them in one of the
events closer to the object, perhaps the OnFormat of the detail. I
don't see any alternatives, actually.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.