Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Pivot Table Form

Status
Not open for further replies.
sandiclaus

sandiclaus

MIS
Aug 27, 2002
19
US
The following code works fine when the pivot table data is in a worksheet in an Excel workbook:

ActiveSheet.PivotTables("PivotTable1").PivotFields("PRODUCT LINE").PivotItems.Select
With ActiveSheet.PivotTables("PivotTable1").PivotFields ("PRODUCT LINE")
.PivotFields("BONE MARROW TRANSPLANT").Visible = False
.PivotFileds("BURNS").Visible = True
End With

However in my Pivot Table created in an Access(2000)form, I get the following error message:
Run-time error '1004': Unable to set the Visible property of the PivotItem class.
Anyone know how to make this work?
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
781
dhookom
dhookom
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
442
Xavierparkash
Xavierparkash
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
600
TrekBiker
TrekBiker
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
533
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top