Knowledge Base

Cannot Assign ChartObject Object to Database OLE Fields

Article ID: 153037

Article Last Modified on 10/10/2006

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