Microsoft KB Archive/153037

= Cannot Assign ChartObject Object to Database OLE Fields =

Article ID: 153037

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q153037





SYMPTOMS
When you use a Microsoft Excel Visual Basic for Applications module that has an assignment of a ChartObject object to an OLE field in a Microsoft Access for Windows 95 version 7.0 database, you may receive the following error message:

ChartObject does not have Value property



CAUSE
Even though data access objects (DAO) provides a type property of Long Binary specifically for OLE objects, Visual Basic for Applications does not offer a way of assigning a ChartObject object's (or a DrawingObject object's) binary information to a database OLE field. Because the ChartObject object lacks the Value property common to many other objects, the error occurs.



RESOLUTION
Use the Clipboard to copy the chart from Microsoft Excel to the OLE database field in Microsoft Access.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 7.00a OLEObject VBA XL7

Keywords: kbprogramming KB153037

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.