How can I count the number of records in a recordset

MaryJolly

New Member

Join Date: Aug 2008

Posts: 3
#1

How can I count the number of records in a recordset

Aug 13 '08, 04:52 AM

I am doing project in VB6. I want to count the records in a recordset. Is there any function for doing that?
Tags: None
QVeen72

Recognized Expert Top Contributor

Join Date: Oct 2006

Posts: 1445
#2

Aug 13 '08, 06:52 AM

Hi,

Open Recordset and use this :

If Not RS.EOF Then
RS.MoveLast
MsgBox RS.RecordCount
RS.MoveFirst
End If

Regards
Veena
Comment

Comment