I Insentive Registered User. Local time Today, 22:04 Joined Mar 12, 2008 Messages 13 Apr 18, 2008 #1 How do you count the amount of rows in a specific table using VBA ofcourse.
Rabbie Super Moderator Local time Today, 22:04 Joined Jul 10, 2007 Messages 5,906 Apr 18, 2008 #2 Open the table as a recordset then do a .movelast and a .movefirst. The number of records(rows) can be obtained from.recordCount
Open the table as a recordset then do a .movelast and a .movefirst. The number of records(rows) can be obtained from.recordCount
I Insentive Registered User. Local time Today, 22:04 Joined Mar 12, 2008 Messages 13 Apr 18, 2008 #3 so how am i gonna put that together?
Rabbie Super Moderator Local time Today, 22:04 Joined Jul 10, 2007 Messages 5,906 Apr 18, 2008 #4 Insentive said: so how am i gonna put that together? Click to expand... 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.
Insentive said: so how am i gonna put that together? Click to expand... 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.