If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Edit PivotTable Form
I would like to do some editing on PivotTable Forms. I've
tried to follow the Microsoft Access Help on this issue. I'm pasting the article: xxxxxxx Edit a PivotTable form Because a PivotTable form is an embedded Microsoft Excel object, you modify it by going to the Microsoft Access form where the PivotTable object is embedded, and then starting and using Microsoft Excel to edit the data. Open the PivotTable form in Form view. Click the Edit PivotTable Object button. Note If you prefer to use in-place editing instead of editing the PivotTable form in a separate Microsoft Excel window, point to Worksheet Object on the Edit menu in Microsoft Access, and then click Edit. On the Data menu in Microsoft Excel, click Refresh Data. Make the changes you want to the PivotTable form. Note For help on specific ways you can modify or otherwise work with the PivotTable form, use Microsoft Excel Help. When you're done editing the PivotTable form, click Exit on the File menu in Microsoft Excel. Notes If you don't find the answer you need in the Microsoft Excel Help topics, you can use Microsoft Access Help when the PivotTable form is open in Form view in Microsoft Access. If you're using in-place editing, you must first click any place on the Access form outside the PivotTable object to get Microsoft Access Help. The source data that the PivotTable form uses isn't automatically saved with the PivotTable form. xxxxxxxxx I cannot find, after having the PivotTable Form in Form View, the "Edit PivotTable Object" button. Any help would be appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Open form, Edit button, etc | Aniko | Using Forms | 14 | July 25th, 2004 08:17 AM |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Form in Edit Mode | JN | Using Forms | 0 | July 12th, 2004 05:47 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |