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

Refering to graph properties (Newbie)

P: 2
Access 2003 (previous 2000)
Windows XP Pro

I am fairly new at VBA within Access, learning as I go thorugh forums and discussion groups. I generally find my answers through previous posts, but I have been unable to find how to specifically refer to properties within a graph object.

Below is a snippet of code from my module in which the graph ('chart_DataSet') is in a subform ('frm_sub_Chart') that is contained within a control ('control_GraphWindow') on the main form ('frm_PrimaryView')

Eventually I will be working with quite a few different properties, though here is the first property I am working with: ChartType

1: I have MS Graph linked through the Object Library (I think I am saying that correctly)
2: I have the option of calling this reference from the SubForm itself, or from a different SubForm that holds the RecordSet of the graph. Either way, I currently believe it should be the same reference text.

What am I doing wrong with my reference?

Expand|Select|Wrap|Line Numbers
  1. With Forms!frm_PrimaryView.control_GraphWindow.Form![chart_DataSet].Graph
  2.    Select Case List_ChartType
  3.       Case 1 '3-D Clustered Bar
  4.         .ChartType = xl3DBarClustered
  5.       Case 2 '3-D Column
  6.         .ChartType = xl3DColumn
  7. 'etc...
(The List_ChartType is a 2 column combobox through which the user can select what chart type they wish to see. Bound column is reference value for the layman's terms of the chart types in second column)

-Can of Worms
May 9 '07 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,494
Does (Referring to Items on a Sub-Form) help?
If not, which item are you having difficulty with exactly?
May 15 '07 #2

P: 2
No, that does not help. I am comfortable with referencing subforms clearly.

I have having trouble with refering to properties of a graph as through the MS Graph reference library. Such as the axis scale, title of the graph, format of the axis labels, etc. It seems to need several more dot and/or bang operators, and I can't seem to get them right.

More than just knowing the proper reference string for any 1 property, I would like to educate myself (or be educated) on how to know what series of bang/dot operators to use in different circumstances, or refering to different levels.

I understand the difference between bang and dot, and when to use each, just need to know when to use what words between the bangs and dots :)
May 15 '07 #3

JConsulting
Expert 100+
P: 603
No, that does not help. I am comfortable with referencing subforms clearly.

I have having trouble with refering to properties of a graph as through the MS Graph reference library. Such as the axis scale, title of the graph, format of the axis labels, etc. It seems to need several more dot and/or bang operators, and I can't seem to get them right.

More than just knowing the proper reference string for any 1 property, I would like to educate myself (or be educated) on how to know what series of bang/dot operators to use in different circumstances, or refering to different levels.

I understand the difference between bang and dot, and when to use each, just need to know when to use what words between the bangs and dots :)
might try here

http://support.microsoft.com/kb/154582
J
May 15 '07 #4

JConsulting
Expert 100+
P: 603

NeoPa
Expert Mod 15k+
P: 31,494
No, that does not help. I am comfortable with referencing subforms clearly.

I have having trouble with refering to properties of a graph as through the MS Graph reference library. Such as the axis scale, title of the graph, format of the axis labels, etc. It seems to need several more dot and/or bang operators, and I can't seem to get them right.

More than just knowing the proper reference string for any 1 property, I would like to educate myself (or be educated) on how to know what series of bang/dot operators to use in different circumstances, or refering to different levels.

I understand the difference between bang and dot, and when to use each, just need to know when to use what words between the bangs and dots :)
In general then, you may want to play with the Object Browser (F2) from within the VBA window. That enables you to see what is a property of what, and what the hierarchy is around an object you're interested in. Searching for objects within available libraries (references) is also supported. I'm afraid I haven't any direct experience of using graphs from within Access myself, but I find F2 invaluable when I'm working in any unfamiliar area.

HTH -NeoPa.
May 15 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.