OWC 10 - Pivot Table events

[rusty cranbrook]

I know that the OWC pivot table is an activex control. I'd expect it's
events to be available in the VBA Editor just like a Treeview
control's events are. But I don't see how to tap into them. There is
no control on a form to refer to, as there is with the Treeview. So
how does one work with the pivot table events? The pivot table is the
most obscure component I've ever run into.

 

[Guest]

Look at:
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/defaul
t.aspx

For my part, I'm using the events in this way:

<script language="javascript" event="CommandExecute
(Command, Succeeded)" for="OWCPivotTable">OnCommandExecute
(Command, Succeeded);</script>
<script language="javascript" event="SelectionChange()"
for="OWCPivotTable">OnSelectionChange();</script>
<script language="javascript" event="Query()"
for="OWCPivotTable">OnQuery();</script>
<script language="javascript" event="ViewChange(iReason)"
for="OWCPivotTable">OnViewChange(iReason);</script>
<script language="javascript" event="PivotTableChange
(iReason)" for="OWCPivotTable">OnPivotTableChange
(iReason);</script>
<script language="javascript" event="DataChange(iReason)"
for="OWCPivotTable">OnDataChange(iReason);</script>

and the javascript functions are in an included js file.

Good luck,
Claude

 

[rusty cranbrook]

Claude, thanks again. I found that my problem in this case was that
I'd used the pivot table wizard in Access XP to build the first trial
forms with pivot tables. Somehow, and I'd still like to know how if
anyone can say, the forms created with the wizard do not have an
ActiveX control on them, nor do they display any of the usual hooks
into the event model of such. Since I first posted, I tried creating a
form by adding the ActiveX control via Insert etc and that does create
a semi typical ActiveX control. Now I can refer to it's events and so
forth. Looks like the brains at Microsoft just set up the pt wizard in
such a way that it is implements pivot tables completely differently
than one would usually use them. First time I've used an Access wizard
in about 9 years... looks like the last time too.

 

[Claude Vernier]

;-)