number of rows in table?

[hyrogen]

Im just wondering does anyone know how to get the number of rows in a table on the current page only, for word, using vba?

I've been struggling on this for ages,
cheers

 

[ZmrAbdulla]

Three different ways

=DCount("*", "TableName")

=Me.RecordSetClone.RecordCount

SELECT Count(*
) As NumberOfRecords
FROM TableName;

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[hyrogen]

is that even if the table spans multiple pages in word? AND it will only return the number of rows on the Current page?


Many thanks