Article ID: 282361
Article Last Modified on 9/27/2006
APPLIES TO
- Microsoft Access 2002 Standard Edition
This article was previously published under Q282361
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).
SYMPTOMS
When you view a table or query in PivotTable or PivotChart view and then save it as a data access page, the PivotChart toolbar is not displayed on the page as expected.
RESOLUTION
To work around this issue, enable the Toolbar property in the Pivot component's properties in Design view of the data access page. To set the Toolbar property, follow these steps:
- Open the data access page in Design view.
- Right-click the PivotChart object, and then click Commands and Options.
- On the Show/Hide tab, click to select the Toolbar check box, and then save and close the page.
NOTE: If you are using a PivotTable object, the Toolbar check box is displayed on the Behavior tab.
- Open the page and notice that the PivotChart toolbar is now displayed at the top of the page.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce the Problem
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
- Open the sample database Northwind.mdb.
- In the Database window, under Objects, click Tables.
- Select Orders, and then click Open.
- On the View menu, click PivotChart View.
- Drag EmployeeID from the Chart Field List box to the PivotChart's Drop Category Fields Here area, drag Ship Via to the Drop Series Fields Here area, and drag Freight to the Drop Data Fields Here area.
- On the File menu, click Save to save the table's layout.
- On the File menu, click Save As, type Orders in the Save Table 'Orders' to box, select Data Access Page in the As list, and then click OK.
- In the New Data Access Page dialog box, click OK to save the page. Notice that the data access page opens and displays the PivotChart, but the PivotChart toolbar is not displayed on the page as expected.
Additional query words: pra function view stored procedure
Keywords: kbbug kbnofix KB282361
