A
Al Camp
In Access2003, I use the right-click shortcut menu to FilterFor all my
records
by a particular City. (say "Boston") That works just fine.
Then I use the shortcut menu to Remove Filter/Sort, and I'm back to all
my
records.
Now I do a FilterByForm on a Date field on that same form, and then Apply
Filter... and I end up with the date range I wanted, but with the City
filter
too!
Removing the Filter/Sort didn't "clear" the FilterProperty, just turned
Filteron = False. (so says Help)
How can the user... using just the resident (built-in) Access filtering
tools to do multiple seperate filtering tasks. I could add a button to
"null" out the filter, but I shouldn't have to... I would think Access
should be able to "clear the filter", using the tools given, and not have a
previous filter pop back up into a new filter scheme.
What am I missing here. Is there another way to use the Access filtering
tools that I'm not aware of.
Thanks for any assistance,
Al Camp
records
by a particular City. (say "Boston") That works just fine.
Then I use the shortcut menu to Remove Filter/Sort, and I'm back to all
my
records.
Now I do a FilterByForm on a Date field on that same form, and then Apply
Filter... and I end up with the date range I wanted, but with the City
filter
too!
Removing the Filter/Sort didn't "clear" the FilterProperty, just turned
Filteron = False. (so says Help)
How can the user... using just the resident (built-in) Access filtering
tools to do multiple seperate filtering tasks. I could add a button to
"null" out the filter, but I shouldn't have to... I would think Access
should be able to "clear the filter", using the tools given, and not have a
previous filter pop back up into a new filter scheme.
What am I missing here. Is there another way to use the Access filtering
tools that I'm not aware of.
Thanks for any assistance,
Al Camp