[AccessD] RecordsetClone and Bookmark

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


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




More information about the AccessD mailing list