Knowledge Base

ACC95: Can't Requery Microsoft Graph Object on Report

Article ID: 154455

Article Last Modified on 10/11/2006

Microsoft Access 95 Standard Edition

This article was previously published under Q154455

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you attempt to requery a Microsoft Graph object on a report, you may receive the following message:

Microsoft Access doesn't allow you to use this method in the current view.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0. This problem no longer occurs in Microsoft Access 97.

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database Northwind.mdb.
Open the Sales By Category report in Design view.

Add the following code to the form's module:

      Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As _
         Integer)
         Me!Graph10.Requery
      End Sub

Close and save the report.
Print Preview the report. Note that you receive the error mentioned in the SYMPTOMS section.

Additional query words: doesn t

Keywords: kbbug kberrmsg kbfix kbinterop kbprogramming KB154455