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. pow67

    Count selected records

    pow67, Aug 8, 2003, in forum: Microsoft Access
    Replies:
    2
    Views:
    343
  2. Peter Nunez

    Count records in a file.

    Peter Nunez, Sep 22, 2003, in forum: Microsoft Access
    Replies:
    2
    Views:
    170
    Peter Nunez
    Sep 23, 2003
  3. Steve Wright

    Long date and long time

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

    count records and sub records

    Guest, Feb 2, 2006, in forum: Microsoft Access
    Replies:
    0
    Views:
    342
    Guest
    Feb 2, 2006
  5. Guest
    Replies:
    0
    Views:
    278
    Guest
    Jun 19, 2007
  6. Guest
    Replies:
    2
    Views:
    235
    Guest
    Oct 29, 2007
  7. Palto Fondberg
    Replies:
    3
    Views:
    787
  8. Keith
    Replies:
    2
    Views:
    231
Loading...