Terence-
To help you navigate the Chart object, you need to download and install the Office Web Components library from here:
Load that library into your VBA project, then you can use the Object Browser to discover all the properties and methods. The object you want in the library is the ChChart object. I do not see a showAllFieldButtons property at all.
Note that if you also have Access 2003 installed, you should be able to find that library on your machine already.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 5, 2014, at 1:48 PM, <buffalome000@yahoo.com> <buffalome000@yahoo.com> wrote:
I have a form named "form1"
On this form is a subform with a control name of "mypivit", that subform is the PIVOTCHART Ii want to reference. I thoght I could reference "ShowAllFieldButtons" as follows:
Forms!form1.mypivit.Form.ChartSpace.charts(0).ShowAllFieldButtons = True
The error I get is Object doesnt support this property or method.
documentation I have found states only "chart.showAllFieldButtons", what am I doing wrong , asside from being in the wrong proffesion :)
terence
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar