Access Table record Count

[zggs90]

I recently saw a technique for determining the number of records in an Access table without having to read the table. This was using something like "systable" or "table " properties, but of course I forgot to make a note of it.

it was a statement like :

recordcount = "Table Name ".records

can anyone guide me to the correct codeing?

Regards

Geoff

 

[GHolden]

This does it...

Sub mRecordCount()
Dim db As Database
Dim rst As Recordset
Dim intRecordCount As Integer

Set db = CurrentDb
Set rst = db.OpenRecordset("tblQuestion", dbOpenSnapshot)

rst.MoveLast
intRecordCount = rst.RecordCount

rst.Close

Set rst = Nothing

End Sub

 

[FRrogoy]

The DCount function is good for this. It works without defining a recordset. It also lets you count based on criteria. MoveLast can be quite slow if you have lots of records. Frank

 

[red22j]

To reiterate what someone already said, heres the one line function:

recordCount = DCOUNT("*", "tableName&quot