M
Michael
Hello,
(I already searched through help & news with no success)
ENVIRONMENT
- Access XP, OWC10
- Form in Pivottable view
- Datasource: Relational Query
PROBLEM
I want to pass all actual row members from different fields to a function
after doubleclick on a rowmember in a Pivottable .
That does especially make sense for the fields to the left of the clicked
rowmember (to the right there usually are more than one members).
Of course the fields are basically independent within Pivottable, i.e. the
clicked field might be dragged to the very left and is then "higher" than
fields former to the left. Though - since there is something like an
ActiveView - one should be able to evaluate this programmatically. I just
want to get by code what I see when looking to the left. In other words: Get
the members of the fields where the clicked member is right/below in the
active view.
Unfortunaltely I couldn´t find a way to do this in a Pivot way like
Pseudocode:
strWhatIseeXfieldsLeft = Selection(0).fieldoffset(acLeft, x).caption
Thanks in advance for quick help
Michael
(I already searched through help & news with no success)
ENVIRONMENT
- Access XP, OWC10
- Form in Pivottable view
- Datasource: Relational Query
PROBLEM
I want to pass all actual row members from different fields to a function
after doubleclick on a rowmember in a Pivottable .
That does especially make sense for the fields to the left of the clicked
rowmember (to the right there usually are more than one members).
Of course the fields are basically independent within Pivottable, i.e. the
clicked field might be dragged to the very left and is then "higher" than
fields former to the left. Though - since there is something like an
ActiveView - one should be able to evaluate this programmatically. I just
want to get by code what I see when looking to the left. In other words: Get
the members of the fields where the clicked member is right/below in the
active view.
Unfortunaltely I couldn´t find a way to do this in a Pivot way like
Pseudocode:
strWhatIseeXfieldsLeft = Selection(0).fieldoffset(acLeft, x).caption
Thanks in advance for quick help
Michael