DCount Porblem

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have been told that I can use DCOUNT for counting
records...

How can I get DCOUNT to count the number of records
displayed on my continuous form. then when they get
searched (filtered) it updates and displayes the number of
records that match the filter criteria?

Many Thanks

James
 
-----Original Message-----
Hello I have been told that I can use DCOUNT for counting
records...

How can I get DCOUNT to count the number of records
displayed on my continuous form. then when they get
searched (filtered) it updates and displayes the number of
records that match the filter criteria?

Many Thanks

James

.
Click to expand...


I was never able to get DCOUNT to work the way I
wanted to... I did this:


DoCmd.GoToRecord acActiveDataObject, , acFirst
num = Me.CurrentRecord
DoCmd.GoToRecord acActiveDataObject, , acLast
num2 = Me.CurrentRecord

num-num2 = the number of records
 
Ok so this will do exactly what I want if so where do I
put this on my text box?

Many Thanks

James
 
-----Original Message-----
Hello I have been told that I can use DCOUNT for counting
records...

How can I get DCOUNT to count the number of records
displayed on my continuous form. then when they get
searched (filtered) it updates and displayes the number of
records that match the filter criteria?

Many Thanks

James

.
Just as a matter of curiosity, why isn't the built-
Click to expand...
in "Record xx of xxxx Records" display in the record
navigation bar satisfactory?
 
To me it just looks untidy its just there... I mean I just
want something where its there but not really small at the
bottom...

if you catch my meaning... I just dont like it never have
thats all... :)
 
Back
Top