Saving Database with Filters Applied?

**cmf0106** · 11-03-2012, 11:46 PM

Is it possible to save a database with filters applied? I ran several filters on a large database today, saved the database, and closed it down. When I reopened the database later that day the filters were removed.

Is there a way to save the filters, such that the next time you open the database the filters you specified will remain active?

**alansidman** · 11-04-2012, 12:15 AM

How and where are your filters? Forms? Queries? Give us some more details.

**cmf0106** · 11-04-2012, 12:23 AM

Here is an example of the filters I am using, on tables.

example2.jpg

**FDibbins** · 11-04-2012, 01:35 AM

Please do not upload pictures, rather, upload a sample of you're file, with any confidential info removed

**alansidman** · 11-04-2012, 07:33 AM

While Access developers have given you the opportunity to filter tables, there really is no good reason for doing it. Users should not be playing in your tables. Tables are for storing your data. Any calculation, filter, sort, etc. should be done in forms and queries. If in a query, as part of the design, Access maintains sort order and maintains filter sequence. If you are doing this in a form, then you have to apply a macro or VBA to the form in the ONLOAD event to have it sorted or filtered in a particular manner.

As an aside, while tables resemble Excel spreadsheets in appearance, their functionality is not the same. It matters not how they are filtered and sorted as forms and queries are where you need to be doing this.