Display number of Records in a Text Box

  • Thread starter Thread starter weircolin
  • Start date Start date
W

weircolin

Hi There

I have set up a button that opens a form with selected criteria. I
would like for, when the form is open, to display the number of
records with that specific data. I know access has the record
navigation at the bottom, but I have removed that and I don't want it
to show. Is there anyway I can do this?

Colin
 
I have set up a button that opens a form with selected criteria. I
would like for, when the form is open, to display the number of
records with that specific data. I know access has the record
navigation at the bottom, but I have removed that and I don't want it
to show.
Click to expand...


Use a text box with the expression:
=Count(*)
 
Use a text box with the expression:
        =Count(*)
Click to expand...

Well that was a lot easier than I imagined! Thank you. Is there
anyway I can say what record it is of the number?

i.e 2 of 54?

I'm thinking two text boxes with "of" in a lable in the middle, but
dunno what I would put in the first text box.

Cheers

Colin
 
Well that was a lot easier than I imagined! Thank you. Is there
anyway I can say what record it is of the number?

i.e 2 of 54?

I'm thinking two text boxes with "of" in a lable in the middle, but
dunno what I would put in the first text box.
Click to expand...


you can just use one text box with the expression:

=Count(*) & " of " & CurrentRecord

Personally, I think it's more proper and possibly a little
faster to use the more explicit:

=Count(*) & " of " & Form.CurrentRecord
 
Linq said:
Wouldn't

=Count(*) & " of " & CurrentRecord

show

54 of 2?

How about

=CurrentRecord & " of " & Count(*)
Click to expand...


Well yeah, that would be more in line with the question ;-)
 
hehe

Thanks, I had noticed it and changed it round. Didn't want to correct
someone who was very kindly helping me though!

Thanks again
 
Back
Top