by NAGARAJ (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 13th January 2006
Date Added: Mon 8th February 2021
Rating: (1 Votes)
To count records from a table
rs.open "Select * from table",con,adopenstatic,adlockoptimistic
intcount=rs.recordcount
msgbox "Total records " & intcount
'be carefull to select adopenstatic