Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MS Access Database Check Box List Filters Missing On SQL Server back end

When I connect Access 2007 to SQL Server (whether by ADO recordset or by linked table) I no longer get check box lists (of available filter values) in the datasheet column filters.

Is this feature available only with MDB/ACCDB and/or DAO?

like image 710
pghcpa Avatar asked May 01 '10 23:05

pghcpa


People also ask

How do I enable filters in Access?

On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid. In the Criteria row of each field, specify a criterion.

Why is filter not working in Access?

If your form filters do not work, be sure to add all locations to your "trusted list". Within Access, add any location that contains data, program or client files to the "Trusted Locations" and be sure to click "include sub-folders". Once I did this, all filters worked without fail.

How do I permanently filter a query in Access?

To filter data in a query, open it in Datasheet View, click the down-arrow at the top of a column, and select a filter option. Here's how it looks in an Access app: You can select multiple values from the list, but in an app, the filter list closes each time you select an option.


1 Answers

I think the check box in datasheet view of native Access tables is governed by the "Display Control" property in the table design. I don't recall what's available when the table is in SQL Server. If you provide a form in "datasheet view", you should be able to bind a check box control to the SQL Server column.

Edit: I think I misunderstood your question yesterday. If you click the Office Button, select Current Database, then put a check in the "ODBC fields" box under "Filter lookup options" ... does that do what you want?

like image 162
HansUp Avatar answered Oct 04 '22 00:10

HansUp