Microsoft KB Archive/304898

From BetaArchive Wiki

Article ID: 304898

Article Last Modified on 4/7/2006



APPLIES TO

  • Microsoft Access 2002 Standard Edition



This article was previously published under Q304898

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS

Charts in Microsoft Access 2002 reports may intermittently display sample data rather than real data when you print or print preview the report.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

307841 OFFXP: How to Obtain the Latest Office XP Service Pack


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft Office XP Service Pack 1.

MORE INFORMATION

Steps to Reproduce the Problem

  1. In a new database create an Access table, as follows:

       Table: tblSampleData
       ----------------------------
       Field Name: ID
       Data Type: Text
       Indexed: Yes (No Duplicates)
    
       Field Name: Name
       Data Type: Text
    
       Field Name: Price
       Date Type: Number
       Field Size: Long Integer
                        
  2. Switch to Datasheet view, and then type the following records:

       ID     Name     Price
       ---------------------
        A     John     10
        B     Mary     20
        C     Tony     30
                        
  3. In the Database window, click Reports under Objects, and then click New.
  4. In the New Report dialog box, click Chart Wizard, and then select tblSampleData from the list of tables and queries. Click OK.
  5. Move ID, Name, and Price from the Available Fields list to the list of fields for the chart. Click Finish.
  6. Close and then save the form as rptChartReport.
  7. Close and open the report several times. Note that intermittently you see sample data instead of the actual data.



Additional query words: pra at times from time to sometimes now and then

Keywords: kbbug kbfix kbofficexppresp1fix kbqfe kbofficexpsp1fix kbhotfixserver KB304898