[AccessD] RecordsetClone and Bookmark

Jim Dettman jimdettman at verizon.net
Tue Feb 7 16:32:41 CST 2012


<<So if I just want to jump to a specific record, no more, then the
Me.RecordSet FindFirst method seems the most simple - does it have any
performance drawbacks?>>

 None that I can think of.  In fact it would be a tad faster.

 The code may have been structured that way if it was older, because up
until A2000, a forms Recordset wasn't exposed and using the clone was the
only way in which you could do a Findfirst.

 But if you do multiple Find/Moves on the recordset, the forms cursor will
move and the form will react (ie. fire OnCurrent, etc), where as if you do
it on the clone, nothing happens until you match bookmarks.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Tuesday, February 07, 2012 05:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] RecordsetClone and Bookmark

Agree on this...
If for instance I would consider looping the recordset to change some
values, then using RecordsetClone and Bookmark would be more efficient than
using Me.Recordset because the form wouldn't have to be updated for each
move. (But actually I wouldn't use a recordset Edit/Update but a SQL Update
for this...).
So if I just want to jump to a specific record, no more, then the
Me.RecordSet FindFirst method seems the most simple - does it have any
performance drawbacks?

/ Asger


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman
Sendt: 7. februar 2012 22:17
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] RecordsetClone and Bookmark

 <<the finds certainly make the form show the wanted records>>

 Once you do:

Me.Bookmark = rst.Bookmark

  But until then, all the manipulation in rst won't be visible to the form
or the user.  That's the whole point.  You can jump forward and backwards
all you want, but until you set the forms bookmark property, none of what
you do affects the form.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Tuesday, February 07, 2012 04:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] RecordsetClone and Bookmark

Disagree - the finds certainly make the form show the wanted records, no
matter if I use rst.FindFirst or Me.Recordset.FindFirst

/ Asger


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman
Sendt: 7. februar 2012 21:27
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] RecordsetClone and Bookmark


 You don't move the forms cursor.  Your finds are invisible to the form and
the user.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Tuesday, February 07, 2012 10:29 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] RecordsetClone and Bookmark

Having a listbox on a form for navigation to a specific record I've always
used RecordsetClone and Bookmark like this:

Private Sub lstOrderID_AfterUpdate()
	Dim rst As DAO.Recordset
	Set rst = Me.RecordsetClone
	rst.FindFirst "OrderID = " & Me.lstOrderID
	Me.Bookmark = rst.Bookmark
End Sub

Now I notice that the code apparently might as well be just:

Private Sub lstOderID_AfterUpdate()
	Me.Recordset.FindFirst "OrderID = " & Me.lstOrderID
End Sub

Can't remember the reason for using RecordsetClone and Bookmark in this
case. Any suggestions?

/ Asger	


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


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