[AccessD] recordset count = -1?

Susan,

You give me more credit than I deserve.  I don't even work with DAO
recordsets any more, so my memory is failing.  I suspect a forward only
type will do this, but can't remember for sure.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, November 12, 2007 12:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] recordset count = -1?

Oh my... this is an old one Arthur -- so old, I can't even remember the
exact cure -- I think it has to do with the type of cursor. I wrote
about it years ago, I'll see if I can find the article. Charlotte will
know. Maybe she'll see this.

Susan H.



> I've got a DAO recordset and codes that does rs.moveFirst and 
> rs.MoveLastand debug.print rs.RecordCount, but it consistently returns

> -1, when I know there are records in the set. What am I doing wrong?

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com