K
kafkawasnotdreaming
Hello all,
I have a PivotTable on a data access page with 50 rows and forty columns. I
am trying to retrieve values from each cell, then format that cell based on
the number found.
When I try the code listed in one of the Access forums:
With PvTable.ActiveData
Set PvCell = .cells(.RowMembers(0), .ColumnMembers(0))
End With
'If row 1, column 4 is the value you want to retrieve than do this
CellValue = PvCell.DetailCells(1, 4).value[/QUOTE]
I only find one pivot cell and one detail cell, and they're empty.
I would appeeciate help iterating through all of the visible detail fields
of a Pivot Table under MS Office Web Components on a data access page,
reetrieving their values, and setting their background colors.
I also notice that detail cells have two distinct internal regions:
* A small area on the left to allow space for an arrow cursor, apparently
used to mark individual cells; and
* the remaining interna space to the right, where the cell contents appear.
Can I get rid of the arrow cursor area, leaving the entire internal space
for contents only? I have turned off filtering and expansion, but I still
get this strange-looking space inside each cell.
Thanks!
SM
I have a PivotTable on a data access page with 50 rows and forty columns. I
am trying to retrieve values from each cell, then format that cell based on
the number found.
When I try the code listed in one of the Access forums:
With PvTable.ActiveData
Set PvCell = .cells(.RowMembers(0), .ColumnMembers(0))
End With
'If row 1, column 4 is the value you want to retrieve than do this
CellValue = PvCell.DetailCells(1, 4).value[/QUOTE]
I only find one pivot cell and one detail cell, and they're empty.
I would appeeciate help iterating through all of the visible detail fields
of a Pivot Table under MS Office Web Components on a data access page,
reetrieving their values, and setting their background colors.
I also notice that detail cells have two distinct internal regions:
* A small area on the left to allow space for an arrow cursor, apparently
used to mark individual cells; and
* the remaining interna space to the right, where the cell contents appear.
Can I get rid of the arrow cursor area, leaving the entire internal space
for contents only? I have turned off filtering and expansion, but I still
get this strange-looking space inside each cell.
Thanks!
SM