Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Data from Chart or PivotTable Is Not Copied When You Copy Chart or PivotTable from One Data Access Page to Another

ACC2000: Data from Chart or PivotTable Is Not Copied When You Copy Chart or PivotTable from One Data Access Page to Another

View products that this article applies to.

This article was previously published under Q202841

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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

You can copy and paste Office Charts and Office PivotTables from one data access page to another. However, the data in the Chart or the PivotTable is not copied from one page to the other.

↑ Back to the top

Cause

The process does not copy the schema information. Therefore, the data does not appear in the destination data access page.

↑ Back to the top

Resolution

Instead of copying and pasting the Chart or the PivotTable, create a new Chart or PivotTable on the destination page.

↑ Back to the top

More information

Steps to Reproduce the Behavior

1.Open the sample database Northwind.mdb.
2.In the Database window, click Pages.
3.Click the Sales page, and then click Design.
4.Click the Chart1 chart. Note that the chart contains data.
5.On the Edit menu, click Copy.
6.Press F11 to switch to the Database window, and then click New.
7.In the New Data Access Page dialog box, click Design View, and then click OK.
8.On the Edit menu, click Paste. Note that the chart does not contain any data.

↑ Back to the top

Keywords: KB202841, kbprb, kbdap

↑ Back to the top

Article Info
Article ID : 202841
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 215