Number of records = -1

dhstein · Mar 13, 2009

I have the code below:

NumRecords = CurrentDb.TableDefs(TblName).RecordCount

MsgBox TblName & " has " & NumRecords & " records"

I get a display that the record count is -1

Any ideas why this is wrong ? Thanks.

Stefan Hoffmann · Mar 13, 2009

hi,

NumRecords = CurrentDb.TableDefs(TblName).RecordCount
MsgBox TblName & " has " & NumRecords & " records"

Nice idea.

I get a display that the record count is -1

For linked tables it is always -1.

mfG
--> stefan <--

Clifford Bass · Mar 13, 2009

Hi,

You may wish to use the DCount() function:

NumRecords = DCount("*", "TblName")

It should work regardless of whether the table is linked or local.

Clifford Bass

Michel Walsh · Mar 13, 2009

You are using a disconnected recordset? a forward only recordset?

Vanderghast, Access MVP

dhstein · Mar 13, 2009

Thanks Stefan and Clifford for your replies. The Dcount worked perfectly.

Clifford Bass · Mar 13, 2009

Hi,

Good. You are welcome.

Clifford Bass

555 · Mar 17, 2009

Number of records = -1

dhstein

Stefan Hoffmann

Clifford Bass

Michel Walsh

dhstein

Clifford Bass

555