What Reference library do I need for OLEunbound.Enabled

[Kotartidzo]

I am using Access 2003 and am trying to save a Microsoft Graph chart unbound object in a report as a GIF file for uploading to Sharepoint.

I have copied code from the Microsoft support shown below. However, when I run the code my system does not recognize the unbound.locked and unbound.enabled functions. I think it is because I do not have a particular reference library. Any help on why my system doesn't recognize this code would be appreciated.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
'On Error GoTo Err_Detail_Format
'for this code to work you need to have the Microsoft Graph 11.0 Object library installed in the Tools/References
'Code as downloaded from

http://support.microsoft.com/kb/287022

on 08Feb2011

Dim grpApp As Graph.Chart
Set grpApp = Me.OLEUnbound0.Object
grpApp.Export "O:\COMMON_DATA\ServicePartsData\FillRate-PastDue\FillRate\fillratechart.gif", "GIF", False

Me!OLEUnbound0.Locked = False

Me.OLEUnbound0.Enabled = True

Set grpApp = Nothing

Me.OLEUnbound0.Action = acOLEClose

DoCmd.Close

Exit_Detail_Format:
Exit Sub

Err_Detail_Format:
MsgBox Err.Description
Resume Exit_Detail_Format

End Sub

 

[PHV]

As clearly stated in your code:
you need to have the Microsoft Graph 11.0 Object library installed in the Tools/References

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hap007]

Hi,

I think PHV has answered your question.

But, did you also place the Graph object on your form and call it: OLEUnbound0

Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Kotartidzo]

I do have it checked. That is what allowes me to dimension the variable as a Graph.Chart. However, the enabled and locked actions keep comming up with an error.

 

[Kotartidzo]

I have the object defined as OLEunbound0 and have tried the solution as a form and as a report.

 

[Kotartidzo]

The problem lay in the fact that I needed the graph to be in a Form, not a report. Once I created the graph in a form all the object properties were available.