Recordcount

[accessman2]

Hi,
In MS Access table, I have a question,

I have a table "Hist", I open it and see the no. of records, it is 35149 records.

But, I write the VBA,
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Hist")

msgbox rs.recordcount

it shows 70298 records. Why the no of the records is different? What's wrong with it?
Please let me know, thanks.

 

[Brookelyn]

Hi, I'm really new to VBA but obviously that way is doubling the amount of records you have. Have you tried using a DCOUNT()?

http://msdn.microsoft.com/library/d...en-us/vbaac11/html/acfctDCount_HV05187157.asp

Has a complete definition of it. I just tried it on my program and it worked pretty well. Let me know what happens

 

[ejstefl]

Typically you have to move to the end of a recordset in order to get an accurate number.

http://www.fontstuff.com/mailbag/qaccess04.htm

 

[Brookelyn]

According to ejstefl's page posted the recordcount is supposed to be better. so if you want to have it displayed in a msgbox just take aout the

Me.txtStaffCount.Value = rst.RecordCount

and replace it with

msgbox rst.recordcount

it works Hope that helps