Record count from tables, shown on a forms textbox

[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

 

[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

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

 

[Dave]

Thanks a lot

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