A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Edit PivotTable Form



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2004, 11:29 AM
Manuel
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.