PC Review


Reply
Thread Tools Rate Thread

Chart Object in Access 2007

 
 
zhuzhuniu
Guest
Posts: n/a
 
      23rd Oct 2008
I have simple VBA code to change Y-AXIS scale of the chart in areport and it
worked in Access 2003. But when I run it in access 2007, I keep getting error
Run-time error '2771' The bound or unbound object frame you tried to edit
doesn't contain an OLE object. Below is my code, could anyone help? Many
thanks!

Private Sub Report_Activate()
Dim objChart As Graph.Chart
Dim objAxis As Graph.Axis

Set objChart = Me!Graph0.Object
Set objAxis = objChart.axes(2)

If objAxis.Type = 2 Then
objAxis.maximumscale = 90
objAxis.minimumscale = 60
End If

End Sub

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PowerPoint 2007 error message when trying to create chart object =?Utf-8?B?RWxpemFiZXRoIFN3b29wZQ==?= Microsoft Powerpoint 14 10th Aug 2010 07:00 PM
PPT 2007 - Insert Chart Object, white background comes up Chris Bean Microsoft Powerpoint 2 30th Sep 2008 05:32 PM
Chart object in PowerPoint 2007 VBA JohnKav Microsoft Powerpoint 1 9th Jun 2008 07:38 PM
Select chart object in Excel 2007 Luca Brasi Microsoft Excel Programming 4 29th Aug 2007 02:55 PM
Get new chart's object properties created in Power Point 2007 =?Utf-8?B?Y2hyaXM=?= Microsoft Powerpoint 3 10th May 2007 03:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:37 PM.