[AccessD] Selecting Filtered records in Datasheet
stuart at lexacorp.com.pg
Sun Jun 5 21:06:30 CDT 2016
Couldn't find an old example, so I just knocked this up. It does what you want - just updates
the currently displayed records.
Private Sub Command8_Click()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
While Not rs.EOF
rs!chk = True
On 6 Jun 2016 at 9:46, Stuart McLachlan wrote:
> 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
> Website: http://www.databaseadvisors.com
More information about the AccessD