Re: Recordset.FindFirst

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx>
Date: Thu, 20 Sep 2007 19:59:15 -0500

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in
news:OxQoJPz#HHA.700@xxxxxxxxxxxxxxxxxxxx:

FWIW, I've had better results from:
Set rs = Me.RecordsetClone
rather than:
Set rs = Me.Recordset.Clone

I just don't understand why you'd bother to set a recordset variable
for the recordsetclone, instead of just using:

With Me.RecordsetClone
...
End With

It's much more efficient and doesn't require any cleanup. Given that
this recordset exists before you use it, I don't see what benefit
there is to assigning a pre-existing object to a newly created
variable.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

References:
- Re: Recordset.FindFirst
  - From: Allen Browne

Prev by Date: Re: What is common practice?
Next by Date: Re: Go to new record on a new day
Previous by thread: Re: Recordset.FindFirst
Next by thread: Filtering a Form
Index(es):
- Date
- Thread

Relevant Pages

Re: Cant use recordset after splitting
... That should read "table-type" recordset. ... *AHEM* actually entered is true, ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(comp.databases.ms-access)
Re: How do I check if recordset exist?
... I wouldn't bother checking, I'd just try to close it and ignore the ... error this may raise: ... >whether recordset is exist or not? ... John Nurick ...
(microsoft.public.access.gettingstarted)
Re: Dim rs as recordset or object? How to check if an rs is open?
... something which is NOT a recordset (and NOT automatically ... Dim y As New ADODB.Recordset ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(microsoft.public.access.modulesdaovba)
Re: Data entry into table field.
... creating a recordset that cannot be updated ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(microsoft.public.access.forms)
Re: Me.Requery and Me.Recordsetclone dont work in Module
... Set db = CurrentDb ... which recordset do you want to use? ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(microsoft.public.access.forms)