Remove a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A table was opened and a filter used on the table and upon exiting Access
asked if the design change was to be saved and mistakingly I hit yes. Now
when I open the table it is always limited to the filter. How can I
remove/undo this? Thanks.
 
Open the table in design view
From the menu select View > properties > There remove the filter from the
Filter property
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 filters on forms change the properties 3
Access 2003 vs 2010 1
joined tables in query, will not filter "no" properly 7
Saving filtered tables 6
filter on a MS Access table 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
clear pivot filter 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1

Back
Top