A counter...

B

Bugaboo Bill

Hello,

I'm new to coding, but need to display the number of total
records on my main form. Is there a way to do this?
I'm using Access XP.
Thanks,

Bill.
 
O

Olga

-----Original Message-----
Hello,

I'm new to coding, but need to display the number of total
records on my main form. Is there a way to do this?
I'm using Access XP.
Thanks,

Bill.
.
Click to expand...
Yes, you create an unbound field on your form and put the
following as recordsourse:
=RecordsetClone.RecordCount
Good luck,
Olga
 
H

Hugh O'Neill

Bugaboo said:
Hello,

I'm new to coding, but need to display the number of total
records on my main form. Is there a way to do this?
I'm using Access XP.
Thanks,

Bill.
Click to expand...


DCount() is one option you could try.

hth

Hugh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Is this possible? 0
Macro to Select text from a point given to a specific word 2
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Split form 0
Counter in subform but... 1
QBF & Query Malfunction 0

Top