By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

How to show Record counts on Forms!?

P: n/a

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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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' ")


Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
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' ")


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.