Hi 
I was hoping someone could point me in the right direction to code the
following scenario:
 
I have a pivot table on an access form (using the OWC10 component). 
The pivot table is mainly displayed at the aggregate (summary) level,
although there are detail cells hidden.
 
The user selects a range of aggregate cells in the data area, then
presses a 'hotkey' to bring up a dialog. What I'm trying to do is to
update all database records that are included within the selected
aggregate cells.
I can do this with one cell but not a range of them. 
 
I've failed to find any way of looping through each cell within the
selected range, as there are no 'offset' like methods available, or any
way of referring to the 'active cell' by coardinates other than the
column and row axis members (which can only be referred to by name or
value - not by an 'index' no).
 
Any help would be much appreciated.
 
Jamie
 
Jamie Reid
Overseas Systems Development
Ski, Lakes & Mountains Division
 
Tel:+44 (0)20 8939 8740
 
Specialist Holidays Group
King's Place
Wood Street
Kingston-Upon-Thames
Surrey KT1 1JY
 
 
 
 


************ Confidentiality Notice & Disclaimer *****************
This message, together with any attachments, is for the confidential and 
exclusive use of the addressee(s). If you receive it in error, please 
delete the message and its attachments from your system immediately and 
notify us by return e-mail. Do not disclose, copy, circulate or use any 
information contained in this e-mail.
(1) The content of this e-mail is to be read subject to Specialist Holidays Group's terms of business, as applicable. 
(2) E-mail may be intercepted or affected by viruses and Specialist Holidays 
Group accepts no responsibility for any interception or liability for any form 
of viruses introduced with this e-mail. 
(3) The sender shall remain solely accountable for any statements, 
representations or opinions that are clearly his or her own and not made 
in the course of employment. 
********************************************************
Specialist Holidays Group
Registered in England and Wales (Number 03343095)