how many rows in table?

[Tcs]

This is PROBABLY really easy, but since I haven't done it before...

I need to find out how to determine the numbers of rows in a table, in VBA. Is
there an easy way without having to read thru the entire table and incrementing
a counter?

Thanks in advance.

Tom

 

[Allen Browne]

Local table?
Try:
CurrentDb().TableDefs("MyTable").RecordCount

Linked table?
Try:
? DCount("*"), "MyTable")

 

[Lynn Trapp]

The code on the following website is designed to determine the number of
records in a recordset. You might be able to modify this to get what you
want.

http://www.ltcomputerdesigns.com/RecOfRecs.htm

 

[Allen Browne]

Last example has spurious bracket. Should be:
DCount("*", "MyTable")

Note to self: do not post while asleep.
(It's after midnight here.)

 

[Tcs]

Excellent! JUST what I needed. Thanks.

 

[Lynn Trapp]

Note to self: do not post while asleep.

(It's after midnight here.)

If you weren't on the wrong side of the world, you wouldn't have that
problem...<g>