Y
yboti
I am working with an Access 2003 application that contains 6-7 Pivot
Tables. The actual database file is in Access 2000 format. I've been
tasked with finding a way to save the user's field selections so they
can be easily reloaded if and when the database, including the query
on which the Pivot Table is built, is refreshed (overwritten). Can
anyone in this gorup tell me
a) where and how Access stores those settings
b) how I can access them to save and reload them
Much of the reading I have done always begins with creating a form.
These queries are not linked to a form from what I can tell.
Tables. The actual database file is in Access 2000 format. I've been
tasked with finding a way to save the user's field selections so they
can be easily reloaded if and when the database, including the query
on which the Pivot Table is built, is refreshed (overwritten). Can
anyone in this gorup tell me
a) where and how Access stores those settings
b) how I can access them to save and reload them
Much of the reading I have done always begins with creating a form.
These queries are not linked to a form from what I can tell.