Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2007

Tip: Looking for answers? Try searching our database.

Report Graph Object Error Message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AaronWestcott - 29 Jun 2007 16:23 GMT
I hope someone can help.

I am trying to use VBA to set the colors for the slices in a pie chart.  My
problem is with accessing the object itself.

I am using the following code in a command button on a seperate form (Form1):

Dim myChart As Graph.Chart
Set myChart = Reports!Report2.Graph0.Object.Application.Chart

myChart.HasTitle = True
myChart.ChartTitle = "Aaron"

I am getting the error on click "Invalid Outside Procedure" and the problem
seems to be the Set statement.  Any ideas what I am doing wrong?

Thanks,

Aaron
JHB - 29 Jun 2007 21:00 GMT
Hello.
You are missing the Caption.
So it must be
myChart.ChartTitle.Caption = "Aaron"

Regards
Jørn

> I hope someone can help.
>
[quoted text clipped - 19 lines]
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200706/1
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.