count rows 1

[jamesmills]

simple i am sure but not for somone who does not know too much about access at moment....

i would like to count how many records there are in a table and then display this in a lable

 

[jamesmills]

lol......... i got it sorted last night!
See what i did wrong?

Dim finalCount As Integer

'finalCount = MyTableRecCount = DCount("ID", "tblCustomers&quot
'should be
finalCount = DCount("ID", "tblCustomers&quot

lblTotalCustomers.Caption = finalCount
End Sub

 

[jdegeorge]

Good for you! Happy coding!

Jim DeGeorge