Close table with filter without saving

Question

Is there a setting for the save object when Access is closed? It doesn't seem to be working correctly with a table with a filter.

I am using the new Access 2010 Advanced Filter "feature". I have to use this since Access 2010 locks up when I try to right-click on a date field and go to Date Filters (unfortunately, the Filter Lookup options don't seem to work correctly either). 

The issue is: When I am done with the table and I close Access, a prompt appears asking if I want to save the changes to the table. As usual I say NO, but now instead of closing without saving as it should, Access 2010 doesn't do anything - appparently NO is now the same as CANCEL when there's a filter.

Clicking Yes to save doesn't seem to work correctly either - nothing happens and I can no longer exit out.

Is there a way to fix this? Or does this Work As Designed?

Answer 1

There are numerous instances where Access CLOSE dialog no longer works correcly.

The form and query design controls were "updated" for Office 2007 and has been crappy ever since. I've had the same issues in Access 2013 too. Microsoft seems to have no quality control and no longer performs Beta testing - relying on users to find issues and then make excuses for not fixing the issues.

It's sad cuz I used to like Microsoft but now it seems they spend more time and money advertising and trying to make everything look like an iPhone than actually making better products.

Windows 9 (or maybe not till 10) will probably look like Windows 8 but with out the Windows 7 compatibility to make things even worse.

Answer 2

That sounds similar to a couple of problems I ran into using the old menu Filter feature.  What I ended up doing for users was to create a few general queries that provided the table/fields that everyone used as the basis for their ad hoc queries.  Then I created a form with text boxes for users to to enter their search criteria, a command button with code to construct the appropriate query's criteria and stuffing the entire query into a subform's record source property.

Answer 3

Unfortunately, I rarely have time to build a form with text boxes whenever someone has an ad-hoc query.

Upon further review, it seems there are multiple instances where the close dialog doesn't seem to work correctly. When I try to close Access with an Advanced Filter on, the close dialog doesn't appear at all. But when I close the filter, Access is able to be closed.

Answer 4

I can't help in that situation because it is a bad idea to use a table's sheet view for anything other than checking the values while debugging a query or code that modifies values.

To view/edit records in a table, you should ALWAYS use a form and text boxes on the same or another form to specify the criteria.  The few time I have tried to use the built in menu/ribbon filter features, I have run into trouble of one kind or another, so now I never use them.