[AccessD] RecordsetClone and Bookmark

Asger Blond ab-mi at post3.tele.dk
Tue Feb 7 16:44:20 CST 2012


Have to answer myself on this: it shouldn't be new to me, since a *clone* is not a *copy*. That's what makes RecordsetClone efficient: it's just a new pointer to the existing recordset, not a new set.
Which also makes me clarify my previous answer concerning the sort order: The recordset clone inherits the forms record order as said - and it also stays in sync with the forms order, i.e. changing the order on the form also changes the order of the clone (because it actually points to the same set).

/ Asger

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

You pointed me to a new testing: and the rst clone actually changes when the record on the form changes - that's completely new to me!

/ Asger


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af William Benson
Sendt: 7. februar 2012 23:08
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] RecordsetClone and Bookmark

Yeah thanks. I don't have Access or I would have tested. But I am still
curious about rst. (Object variable ). I don't think it changes when the
form is changed. If not then.... then.... well I don't know then what, nor
why I brought it up.

<vbg>
On Feb 7, 2012 5:03 PM, "Asger Blond" <ab-mi at post3.tele.dk> wrote:

> I can confirm that the recordsetclone inherits the record order of the
> form at the time the clone is created.
>
> / Asger
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] På vegne af William Benson
> Sendt: 7. februar 2012 22:23
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] RecordsetClone and Bookmark
>
> Nothing to contribute except to say I really am interested in how this
> thread turns out. And you left clone off the word recordser Asger... don't
> make the clones mad.
>
> By the way what about when a form is sorted contrary to the
> recordsource.... I assume (based on an answer I got from one of the kind
> folk here ) that recordsetclone is going to always have records in the same
> order as the form at the time the property is "read". If you assign it to a
> variable however I am not sure that sorting the form affects the variable.
> On Feb 7, 2012 4:08 PM, "Asger Blond" <ab-mi at post3.tele.dk> wrote:
>
> > 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
>
-- 
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