Click to See Complete Forum and Search --> : recordcount on a table type recordset
November 18th, 1999, 09:25 PM
Has anyone experienced the phenomenon of a table type recordset reporting an incorrect record count? I have 376 records in a table. When a dynaset type recordset object is used the correct # of 376 records is reported for its "recordcount" value. Although when I use the table type recordset the amount of 302 is reported for its "recordset" value. Can anyone help solve this mystery?
santulan
November 18th, 1999, 10:09 PM
Hi,
Use .movelast statement before record count.
Santulan
Santulan
November 18th, 1999, 10:45 PM
Sorry man you really didn't read my question did you? : )
I have refreshed the db by the .movelast .movefirst the problem that the tye dynaset reports the correct # of records while the type table does not. I am perplexed as to why this is happening
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.