[AccessD] Selecting Filtered records in Datasheet

[David Emerson]

Thanks Susan.  That's what we eventually discovered.  Regards David

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

David, I might not understand what you're looking for, but the following
syntax will return the current form's filter value: 

Forms![formname].Form.Filter

Susan H. 

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