Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Thu Feb 3 00:40:28 CST 2005
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