David McAfee
davidmcafee at gmail.com
Wed Aug 8 16:27:45 CDT 2012
I missed the beginning of this thread, so I might not totally understand what was being discussed here. Am I the only one that makes a habit of always moving last then first before getting a count? if Not rs.BOF and not rs.EOF rs.MoveLast rs.MoveFirst debug.print rs.recordcount else 'empty recordset end if On Wed, Aug 8, 2012 at 2:12 PM, Jim Lawrence <accessd at shaw.ca> wrote: > I knew it was a problem with ADO type recordsets which may just start at > the > bottom instead of the top. I think DAO type recordsets always seem to start > at the top unless there was some intermediate processing. > > OTOH using the style, you displayed, would work for any recordset so a > developer could create simple universal recordset handling code and > classes. > > Jim >