NumRecs

  • Thread starter Thread starter Lauren B
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Table Code Included 4
Bug in x = y, how can this be? 2
DSum with multiple criteria 1
I inherited this.... 2
cannot create a row longer than 256 columns 2
Co-workers computer doesn't recognize date in script 5
Return records by function 2
Going quietly mad!!!!!! 1

Back
Top