[AccessD] Selecting Filtered records in Datasheet

David Emerson newsgrps at dalyn.co.nz
Sun Jun 5 19:56:26 CDT 2016


There are over 50 fields (it is design specifications).  They also want
multiple filtering on each field.  Not keen to set up that many list boxes
:(

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Monday, 6 June 2016 12:50 p.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Selecting Filtered records in Datasheet

can you convert it to a bound form and give them filtering options on the
form footer?

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Sunday, June 05, 2016 5:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Selecting Filtered records in Datasheet

Thanks Stuart and Rocky,

The problem is that I am not in control of the filter.  It depends on how
the user filters the records using the Access functionality.  

Currently I do what Stuart is suggesting but this sets all records in the
forms recordset, not just the ones that are left after the user has applied
their filters.

I was hoping that Access stored the filter somewhere so that I could get it
and apply it to the base records.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Monday, 6 June 2016 11:46 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Selecting Filtered records in Datasheet

Not as far as I know,  but I've done a similar thing before by just stepping
through  the filtered recordset and setting each one in turn.  I'll see if I
can dig up an example.



On 6 Jun 2016 at 11:26, David Emerson wrote:

> Hi Listers,
> 
> I have a form that is displayed in Datasheet view.  The records can be 
> filtered using the built in filtering menus.
> 
> I want to be able to identify the records that are showing so that I 
> can update a field (specifically setting a yes/no field to true).  Is 
> there a property or method that will let me know which records are 
> left when filtering is applied on a datasheet?
> 
> 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

-- 
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