Long Winded Records Count

Discussion in 'Microsoft Access' started by Guest, Nov 9, 2007.

  1. Guest

    Guest Guest

    This has been bothering me since Access 95, but someone might be able to
    explain to me how to get the record count without unneccessary steps.

    Every form in which the "navigation buttons" property is set to yes,
    displays the total number of records as well as the current record number.
    Why is it that then such counts are not available with a simple
    "me.recordcount" -for instance- and one has to go through the long winded
    procedure of:

    -creating a recordset clone,
    -movefirst,
    -movelast, and then finally extract the
    -record count.

    or, in alternative, one has to create a query just to count the number of
    records which is already displayed in the actual form navigation area?

    Thank you
     
    Guest, Nov 9, 2007
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Gino,

    You should be able to use:

    Me.recordsetclone.recordcount.


    --
    Don''t forget to rate the post if it was helpful!

    Email address is not valid.
    Please reply to newsgroup only.


    "Gino" wrote:

    > This has been bothering me since Access 95, but someone might be able to
    > explain to me how to get the record count without unneccessary steps.
    >
    > Every form in which the "navigation buttons" property is set to yes,
    > displays the total number of records as well as the current record number.
    > Why is it that then such counts are not available with a simple
    > "me.recordcount" -for instance- and one has to go through the long winded
    > procedure of:
    >
    > -creating a recordset clone,
    > -movefirst,
    > -movelast, and then finally extract the
    > -record count.
    >
    > or, in alternative, one has to create a query just to count the number of
    > records which is already displayed in the actual form navigation area?
    >
    > Thank you
     
    Guest, Nov 9, 2007
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thank you Dale. It works and it is simple as it should be.


    "Dale Fye" wrote:

    > Gino,
    >
    > You should be able to use:
    >
    > Me.recordsetclone.recordcount.
    >
    >
    > --
    > Don''t forget to rate the post if it was helpful!
    >
    > Email address is not valid.
    > Please reply to newsgroup only.
    >
    >
    > "Gino" wrote:
    >
    > > This has been bothering me since Access 95, but someone might be able to
    > > explain to me how to get the record count without unneccessary steps.
    > >
    > > Every form in which the "navigation buttons" property is set to yes,
    > > displays the total number of records as well as the current record number.
    > > Why is it that then such counts are not available with a simple
    > > "me.recordcount" -for instance- and one has to go through the long winded
    > > procedure of:
    > >
    > > -creating a recordset clone,
    > > -movefirst,
    > > -movelast, and then finally extract the
    > > -record count.
    > >
    > > or, in alternative, one has to create a query just to count the number of
    > > records which is already displayed in the actual form navigation area?
    > >
    > > Thank you
     
    Guest, Nov 9, 2007
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steve Wright

    Long date and long time

    Steve Wright, Feb 19, 2004, in forum: Microsoft Access
    Replies:
    4
    Views:
    272
    Ken Snell
    Feb 19, 2004
  2. Guest

    count records and sub records

    Guest, Feb 2, 2006, in forum: Microsoft Access
    Replies:
    0
    Views:
    251
    Guest
    Feb 2, 2006
  3. Guest
    Replies:
    0
    Views:
    230
    Guest
    Jun 19, 2007
  4. Guest
    Replies:
    2
    Views:
    210
    Guest
    Oct 29, 2007
  5. Keith
    Replies:
    2
    Views:
    195
Loading...

Share This Page