devxlogo

RecordCount Incorrect

RecordCount Incorrect

Question:
VB reports the wrong number of records from an Access database with the RecordCount property. The same query to dBase files reports the correct number of records. What is the problem?

Answer:
Do a MoveLast followed by a MoveFirst on the dynaset or snapshot you created. That should take care of an invalid recordcount. Example:

rs.MoveLastrecCount% = rs.RecordCountrs.MoveFirst

devx-admin

Share the Post: