469,926 Members | 1,791 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

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.


Nov 13 '05 #1
1 2450
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)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Clive Moss | last post: by
1 post views Thread by rummey | last post: by
2 posts views Thread by Carl Gilbert | last post: by
3 posts views Thread by Jerry K via DotNetMonster.com | last post: by
3 posts views Thread by GoalieGW | last post: by
9 posts views Thread by PeteCresswell | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.