[AccessD] Filters in Datasheet View

David Emerson newsgrps at dalyn.co.nz
Thu Sep 20 04:51:57 CDT 2018


However, now I find that only one filter can be applied using the check
boxes, then any other columns don't show the boxes (even though they are
showing if no columns are filtered).  Is this is feature of Access?

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Thursday, 20 September 2018 9:43 p.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Filters in Datasheet View

Found the answer.  In the options for the Current database is a filter
option "Don't display records when more than this number is read".  It was
set to 0 (I thought this means no limit).  I changed it to 1000 and the
selection lists appeared.

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Thursday, 20 September 2018 8:05 p.m.
To: Access Developers discussion and problem
Subject: Re: [AccessD] Filters in Datasheet View

You have to use a query for that.  It is outside the capabilities of a
filter.

On Wed, Sep 19, 2018, 7:22 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
> Access 2010.  Access table back end.
>
> I have a datasheet view of a form which shows the sort and filter dropdown
> in the column headings.  I see the sort options, and standard filters (eg
> Text filters for Equals, Does Not Equal, etc).  However, I don't see in
the
> list the options to select several items.  EG a countries field should
have
> a list of the countries in the data so that I can filter several at the
> same
> time by checking boxes.
>
> I have simplified the data source so that it is only 1 table.
>
> I have the same problem if I open any table directly.
>
> Is there a setting or condition that has turned this off?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list