Re: Report Graph Object Error Message

From: "JHB" <woh@xxxxxxx>
Date: Fri, 29 Jun 2007 22:00:28 +0200

Hello.
You are missing the Caption.
So it must be
myChart.ChartTitle.Caption = "Aaron"

Regards
Jørn

"AaronWestcott via AccessMonster.com" <u30340@uwe> skrev i en meddelelse
news:746dba6ccd07f@xxxxxx

I hope someone can help.

I am trying to use VBA to set the colors for the slices in a pie chart.

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200706/1

References:
- Report Graph Object Error Message
  - From: AaronWestcott via AccessMonster.com

Prev by Date: Re: Export fast, my code slow =[
Next by Date: Creating a new table as a subset of two other tables
Previous by thread: Report Graph Object Error Message
Next by thread: Thank You
Index(es):
- Date
- Thread