access 2007 filtering

[Mike]

Somehow, in a database with four tables, I've lost the ability to filter on
all tables.
That is, when you click on the column header, only the sort option is
available. The "select all" and other field values do not show.

 

[Pendragon]

In the ribbon toolbar, click on the button FILTERS. This simply changes the
column headings to something similar to what you would see in Excel
(unfortunately). If you click on the dropdown for one of the column
headings, you can then select the value for that column on which you wish to
filter.

 

[Mike]

Thanks for replying.
All fields (columns) have headers
When I click the button FILTERS, (or click on the icon in header field) the
sort/filter window opens, but no check boxes are displayed.

They were there previously, now they're not. It's a table of college
courses. I filtered for a particular semester, toggled filter on and off. I
also created a query for a particular semester. When I reopened the db the
next day, filtering was somehow disabled.

 

[Clint]

Some times we disable filtering when there are too many records for the
check box control to be performant. Do you still have text filters
available?

Clint Covington

 

[Mike]

Thanks,

I've found a fix, although I still don't know why it happened. Text filters
were still available. But, I went to "Access Options"/ current database /
filter lookup options -- and checked both ODBC fields and increased number
of records.

(I just took over a new task, and didn't know at first that we are using MS
Access as a "front end' to a sql database.)

Mike