Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Nov 12 15:05:01 CST 2007
Arthur: Why don't you post your DIMs and opening statement? Maybe we'll see something there. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, November 12, 2007 12:54 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.30/1125 - Release Date: 11/11/2007 9:50 PM