[AccessD] ADO Record Counts

While that is true with a DAO recordset, an ADO recordset does not
necessarily open at EOF or BOF, so I've seen that test fail.

Charlotte Foust


-----Original Message-----
From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] 
Sent: Wednesday, February 02, 2005 10:40 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] ADO Record Counts



Recordcount will not be accurate when opening the table, you should
first do a movelast before getting the correct count.

 
Checking for .eof = true and .bof = true is more acurate and faster to
know is 1 or more records exists.


Erwin


-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Jeremy Toves
Verzonden: woensdag 2 februari 2005 20:12
Aan: Access Developers discussion and problem solving
Onderwerp: Re: [AccessD] ADO Record Counts

Sorry about the typos.  My coding is done on a different computer than
the computer I send emails from.  I'll try your solution too. 

Thanks,
Jeremy Toves
--
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