[AccessD] Using a dynamic recordset field.

David McAfee davidmcafee at gmail.com
Thu Aug 19 08:23:19 CDT 2010


Darryl, just a slightly off topic comment. IIRC with DAO, if you want an
accurate count, you want to do something like this:

If not rs.bof and not rs.eof then
   Rs.movelast
   Rs.movefirst
   ' now do something with rs
Else
   'Empty recordset
End if

Sent from my Droid phone.

On Aug 18, 2010 9:10 PM, "Darryl Collins" <Darryl.Collins at iag.com.au> wrote:

_______________________________________________________________________________________


Note: This e-mail is subject to the disclaimer contained at the bottom of
this message.
___________...
ok.. thanks Stuart, I was just considering following up that very issue.  Is
it better to be explict by using the ".fields" syntax, or is that redunant?
 It worked fine without it, but that may have been good luck rather than
good coding.

cheers
Darryl.





-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at d...

Subject: Re: [AccessD] Using a dynamic recordset field.

or just rsDAO(strField)

On 18 Aug 2010 at ...
_______________________________________________________________________________________


The information transmitted in this message and its attachments (if any) is
intended
only for the ...



More information about the AccessD mailing list