Results 1 to 2 of 2

Thread: RecordCount

  1. #1
    Join Date
    Dec 1969

    Default RecordCount

    When i use .RecordCount it returns -1, so to find an answer to my problem I headed over to the "commonly asked questions" and was delighted to find that exact question and answer in the listing. Unfortuanately it mentioned why this might happen, but didn&#039t give me an answer on what to do to fix it. Can anyboyd here help? Thanks a million..ttyl.

  2. #2
    Join Date
    Dec 1969

    Default RE: RecordCount

    You&#039ve got to use a cursor besides the forward-only cursor. You can see how to use other cursors at:<BR><BR><BR>So, use an adOpenStatic cursor, and RecordCount will work. You can also a SELECT COUNT(*) SQL-type statement...<BR><BR>Finally, to learn how *not* to count the records, be sure to read:<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts