recordcount

[Duane8889]

Hello code gurus
Is it possible to get the recordcount without using ado? I just want to know how many entries are in my employees table.

In Visual basic I used code like...

lblRecord.Caption = adoPrimaryRS.RecordCount

but as I mentioned I didn't go with using recordsets etc in this project.

 

[RoyVidar]

It is possible to get a recordcount numerous ways, but you haven't given much to work on, except an indication about ADO, where... well read one of the discussions yourself thread709-1052131. For DAO, the recordcount property is much more reliable, and you can fetch it both from the form recordset, or open a recordset. Then theres also the domain aggregates, which aren't among my favourites.

A bit more detail - or - do try out the search facilities, cause questions about recordcounts has been asked numerous times...

Roy-Vidar