M
Manuel
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.
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.