How to show Record counts on Forms!?

[John Baker]

Hi:

I am using Access 2000, and have a form which is linked to a table ("tblSetup"). I would
like to be able to show on the form the count of the number of records in 3 different
tables. The form is directly linked to "tblSetup" so that various system parameters can be
changed. The sheets I would like to be able to show the count on are "tbltimesheetsnew"
"tblHistory" and "TblPending".

I have been trying to do it with a bound field, and all I get is "error".
The formulation I have been using is : =Count("[tbltimesheetsnew]"). Variations do not
appear to work either!
Can someone suggest an approach that would work for me.

[DFS]

"John Baker" <Ba******@Verizon.net> wrote in message
news:v3********************************@4ax.com...

Hi:

I am using Access 2000, and have a form which is linked to a table ("tblSetup"). I would like to be able to show on the form the count of the number of records in 3 different tables. The form is directly linked to "tblSetup" so that various system parameters can be changed. The sheets I would like to be able to show the count on are "tbltimesheetsnew" "tblHistory" and "TblPending".

I have been trying to do it with a bound field, and all I get is "error".
The formulation I have been using is : =Count("[tbltimesheetsnew]"). Variations do not appear to work either!
Can someone suggest an approach that would work for me.

Use the domain function DCount() in the ControlSource:

=DCount("Field","Table")
or
=DCount("Field","Table","Field = 'Jones' ")

[Mike Storr]

Are these being done as datasheets? As single forms? The approach you use
may depend on how it is being displayed.

Mike Storr
www.veraccess.com

"John Baker" <Ba******@Verizon.net> wrote in message
news:v3********************************@4ax.com...

Hi:

I am using Access 2000, and have a form which is linked to a table ("tblSetup"). I would like to be able to show on the form the count of the number of records in 3 different tables. The form is directly linked to "tblSetup" so that various system parameters can be changed. The sheets I would like to be able to show the count on are "tbltimesheetsnew" "tblHistory" and "TblPending".

I have been trying to do it with a bound field, and all I get is "error".
The formulation I have been using is : =Count("[tbltimesheetsnew]"). Variations do not appear to work either!
Can someone suggest an approach that would work for me.

[John Baker]

Yjaml you. that worked very well.

However, I now have aq slightly different problem. When I remove records from the table I
am counting the count on the fome does not change. I have tried using refresh (as a macro)
and that dosent do it. Can you suggest what command I should issue to refresh the
calculations so that they reflect the new reality of the table contents count?

Regards

John Baker

"DFS" <no****@nospam.com> wrote:

"John Baker" <Ba******@Verizon.net> wrote in message
news:v3********************************@4ax.com.. .

Hi:

I am using Access 2000, and have a form which is linked to a table

("tblSetup"). I would

like to be able to show on the form the count of the number of records in

3 different

tables. The form is directly linked to "tblSetup" so that various system

parameters can be

changed. The sheets I would like to be able to show the count on are

"tbltimesheetsnew"

"tblHistory" and "TblPending".

I have been trying to do it with a bound field, and all I get is "error".
The formulation I have been using is : =Count("[tbltimesheetsnew]").

Variations do not

appear to work either!
Can someone suggest an approach that would work for me.

Use the domain function DCount() in the ControlSource:

=DCount("Field","Table")
or
=DCount("Field","Table","Field = 'Jones' ")