Counting rows (1 Viewer)

[Insentive]

How do you count the amount of rows in a specific table using VBA ofcourse.

 

[Rabbie]

Open the table as a recordset then do a .movelast and a .movefirst. The number of records(rows) can be obtained from.recordCount

 

[Insentive]

so how am i gonna put that together?

 

[Rabbie]

so how am i gonna put that together?

You could try reading Access help and looking at the examples for the commands I mentioned. That way you will learn something

or

You could hire somebody to do the work for you.