By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 696 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

Access 2007 and Filtering

P: 3
I'm working on testing a large application with Access 2007. It has been running under 2003 and XP with no obvious errors.

However with 2007 many forms seem to have lost the ability to filter. When the form is loaded, the record source specifed, a filter applied, and filtering set to on, either no records are displayed, or ALL of the records displayed.

Click on the "Toggle Filter" on the ribbon and voila, the resordset is displayed.

It's acting like there's an Access Option that says "Disable Programmatic Filter switch"

The code is shown below
/CODE/
Me.Filter = sBuildFilter
Me.FilterOn = True
' Save Filter info for report
SaveSetting APP_NAME, ROUTINE_NAME, "Filter", sBuildFilter
txtFilter = sBuildFilter
Me.Requery
/CODE/

Putting a Watch on "Me.FilterOn" shows TRUE when run in 2003, but remains FALSE when run under 2007. Same results when FilterOn is moved up a line.

Anyone working with the 2007 beta having similar problems

Dave
Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
There are always filter problems and they seem to occur a lot during version changes. Me.Filter = "" has been known to turn a filter off so in your example if sBuildFilter = "" it could be turning the filter off.

I haven't done any work in 2007 yet but I know they have been doing a lot of work on filters.

Check out this blog ...

http://blogs.msdn.com/access/archive...11/595718.aspx

I'm working on testing a large application with Access 2007. It has been running under 2003 and XP with no obvious errors.

However with 2007 many forms seem to have lost the ability to filter. When the form is loaded, the record source specifed, a filter applied, and filtering set to on, either no records are displayed, or ALL of the records displayed.

Click on the "Toggle Filter" on the ribbon and voila, the resordset is displayed.

It's acting like there's an Access Option that says "Disable Programmatic Filter switch"

The code is shown below
/CODE/
Me.Filter = sBuildFilter
Me.FilterOn = True
' Save Filter info for report
SaveSetting APP_NAME, ROUTINE_NAME, "Filter", sBuildFilter
txtFilter = sBuildFilter
Me.Requery
/CODE/

Putting a Watch on "Me.FilterOn" shows TRUE when run in 2003, but remains FALSE when run under 2007. Same results when FilterOn is moved up a line.

Anyone working with the 2007 beta having similar problems

Dave
Oct 25 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.