NumRecs

[Lauren B]

Is there an alpha equivalent to the "NumRecs" code?

Thanks,

LB

 

[Guest]

What is the NumRecs code? I don't believe I have heard of that.

 

[Graham R Seach]

Lauren,

In both DAO and ADO it is the RecordCount method.

'In DAO...
Set rs = CurrentDb.OpenRecordset("tblMyTable")
rs.MoveLast '*** Very important
MsgBox rs.RecordCount
rs.MoveFirst '*** Equally as important

'In ADO...
rs.Open "tblMyTable", conn
MsgBox rs.RecordCount

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia