record count

[JB]

Hello
In a form I have a subform which of which I've removed the navigation
controls. But I would like to keep just the record count.
Can I create a box/field that shows how many records there are in that
subform for that particular parent form without using the default navigation
controls?
Can anyone help.

 

[George]

Dear friend,

Assuming that your subform is in a continuous format and you have a primary
key for that subtable then add an unbound (textbox), either at the subform
header or the subform footer as:

=count([YourPrimaryField])

Hope this helps,

GeorgeCY

Ο χÏήστης "JB" έγγÏαψε:

 

[JB]

Thank you that worked great.
For some reason it's counting the 'next' record as well. You know the blank
one that's ready for a new entry? Can I do something to not show that until
the user clicks the 'New' cmd?
Thank you
Jen

Dear friend,

Assuming that your subform is in a continuous format and you have a
primary
key for that subtable then add an unbound (textbox), either at the subform
header or the subform footer as:

=count([YourPrimaryField])

Hope this helps,

GeorgeCY

Ο χÏήστης "JB" έγγÏαψε:

Hello
In a form I have a subform which of which I've removed the navigation
controls. But I would like to keep just the record count.
Can I create a box/field that shows how many records there are in that
subform for that particular parent form without using the default
navigation
controls?
Can anyone help.

 

[George]

Well, I tried it and works great in my databases (I use ms-access 2003 - what
ver. do you use?)

Some ideas:

1. Backup first your database and then compact and repair it.
2. Is there any default value for the new record?


Ο χÏήστης "JB" έγγÏαψε:

Thank you that worked great.
For some reason it's counting the 'next' record as well. You know the blank
one that's ready for a new entry? Can I do something to not show that until
the user clicks the 'New' cmd?
Thank you
Jen

Dear friend,

Assuming that your subform is in a continuous format and you have a
primary
key for that subtable then add an unbound (textbox), either at the subform
header or the subform footer as:

=count([YourPrimaryField])

Hope this helps,

GeorgeCY

Ο χÏήστης "JB" έγγÏαψε:

Hello
In a form I have a subform which of which I've removed the navigation
controls. But I would like to keep just the record count.
Can I create a box/field that shows how many records there are in that
subform for that particular parent form without using the default
navigation
controls?
Can anyone help.

 

[George]

If problem insists then use =count([YourPrimaryField])-1 (although is not a
good idea)


Ο χÏήστης "JB" έγγÏαψε:

Thank you that worked great.
For some reason it's counting the 'next' record as well. You know the blank
one that's ready for a new entry? Can I do something to not show that until
the user clicks the 'New' cmd?
Thank you
Jen

Dear friend,

Assuming that your subform is in a continuous format and you have a
primary
key for that subtable then add an unbound (textbox), either at the subform
header or the subform footer as:

=count([YourPrimaryField])

Hope this helps,

GeorgeCY

Ο χÏήστης "JB" έγγÏαψε:

Hello
In a form I have a subform which of which I've removed the navigation
controls. But I would like to keep just the record count.
Can I create a box/field that shows how many records there are in that
subform for that particular parent form without using the default
navigation
controls?
Can anyone help.

 

[JB]

Yeah and the odd thing is that when I add a new Parent record, it doesn't
count anything in the subform except the records I add. It must be something
to do with how I imported the existing data to begin with.
Thanks for your help.
Jen

If problem insists then use =count([YourPrimaryField])-1 (although is not
a
good idea)


Ο χÏήστης "JB" έγγÏαψε:

Thank you that worked great.
For some reason it's counting the 'next' record as well. You know the
blank
one that's ready for a new entry? Can I do something to not show that
until
the user clicks the 'New' cmd?
Thank you
Jen

Dear friend,

Assuming that your subform is in a continuous format and you have a
primary
key for that subtable then add an unbound (textbox), either at the
subform
header or the subform footer as:

=count([YourPrimaryField])

Hope this helps,

GeorgeCY

Ο χÏήστης "JB" έγγÏαψε:

Hello
In a form I have a subform which of which I've removed the navigation
controls. But I would like to keep just the record count.
Can I create a box/field that shows how many records there are in that
subform for that particular parent form without using the default
navigation
controls?
Can anyone help.