Custom Pivot forms

[SJM]

I have a reporting database that has a series of pre-defined Pivot Table
screens. What I would like to do is to enable users to be able to save their
own configurations. I found 2 ways of doing this. One involved saving the
Pivot Table XML, which seemed a great concept but one which seemed ot only
work on MS Access 2003 and not on Access 2002. The other method involved
having code to save the Pivot Table as a new form, and populating a table of
Pivot Table formats from which users could choose. This worked well, until I
compiled the database....and consequently discovered that you cant create a
new form on the fly in an mde. The db needs to distributed in compiled
format. Has anyone come up with a method that allows users to
create/configure a Pivot form and save it for use next time in a mde.

[MGFoster]

SJM wrote:

I have a reporting database that has a series of pre-defined Pivot Table
screens. What I would like to do is to enable users to be able to save their
own configurations. I found 2 ways of doing this. One involved saving the
Pivot Table XML, which seemed a great concept but one which seemed ot only
work on MS Access 2003 and not on Access 2002. The other method involved
having code to save the Pivot Table as a new form, and populating a table of
Pivot Table formats from which users could choose. This worked well, until I
compiled the database....and consequently discovered that you cant create a
new form on the fly in an mde. The db needs to distributed in compiled
format. Has anyone come up with a method that allows users to
create/configure a Pivot form and save it for use next time in a mde.

By its very nature an .mde file cannot have new forms, reports. What I
do is create another .mdb file that links to the same tables as the .mde
and let the users create new queries, forms, reports in that file.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)