[AccessD] Filters in Datasheet View

[David Emerson]

Ah, thanks for the explanation.  It is always good to know why things are
what they are.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Friday, 21 September 2018 2:36 a.m.
To: Access Developers discussion and problem
Subject: Re: [AccessD] Filters in Datasheet View

Filters are not meant for complex conditions so they are implemented in a
simple fashion.  The query engine can handle complex conditions and refuses
to execute if you are getting too complex.  The filter capability is there
for quickly viewing a subset of data but it does nothing more.

On Thu, Sep 20, 2018, 2:53 AM David Emerson <newsgrps at dalyn.co.nz> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com