B
Barron Henderson
Background:
I am creating a pivot chart to display account activity over time in Access
2002 on a Windows XP platform. If there is one account, the pivot table
opens with all sub accounts as separate pages. If there are many
accounts/subaccounts that the user would like print outs of, there is a form
to enter multiple, which will open each individually and print it.
Because I could not figure out how to use the PivotChart filter
programatically, I rebuild the dataset for each subaccount.
Problem:
If the user specifies a filter criteria while viewing in the single account
mode, the filter can end up applying to everything that follows resulting in
a blank dataset. I would like to know how to use the autofilter
programatically.
Thanks in advance,
Barron
I am creating a pivot chart to display account activity over time in Access
2002 on a Windows XP platform. If there is one account, the pivot table
opens with all sub accounts as separate pages. If there are many
accounts/subaccounts that the user would like print outs of, there is a form
to enter multiple, which will open each individually and print it.
Because I could not figure out how to use the PivotChart filter
programatically, I rebuild the dataset for each subaccount.
Problem:
If the user specifies a filter criteria while viewing in the single account
mode, the filter can end up applying to everything that follows resulting in
a blank dataset. I would like to know how to use the autofilter
programatically.
Thanks in advance,
Barron