Record count from tables, shown on a forms textbox

D

Dave

Hi

Sorry if this sounds like a dumb question, but im quite new to access.

I have a form that shows when my dataabse starts up. I want to show
information on the size of the database on it, in the form of record counts
of certain tables (4 or 5). Is there a way to get the number of records for
each table concerned returned to the form, into textboxes or something?

Many thanks for any help,

D
 
F

fredg

Hi

Sorry if this sounds like a dumb question, but im quite new to access.

I have a form that shows when my dataabse starts up. I want to show
information on the size of the database on it, in the form of record counts
of certain tables (4 or 5). Is there a way to get the number of records for
each table concerned returned to the form, into textboxes or something?

Many thanks for any help,

D
Click to expand...

One way ....
=DCount("*","TableName")
 
Top