recordcounts & filters

Results 1 to 4 of 4

Thread: recordcounts & filters

  1. #1
    MelD Guest

    Default recordcounts & filters

    Can you use these together?<BR>I want to grab a recordset, filter it, get a count, change the filter, get a new count. (I&#039;m using Access 2000)<BR><BR>I think I might have my cursorLocation and/or my cursorType wrong.<BR><BR>Thanks for your help,<BR>Melissa

  2. #2
    MelD Guest

    Default And the cursors are...

    Sorry, when I was doing the recordcount, I used 1, 1<BR>and for the filtering: 3, 3.<BR>When I use either the filtering OR the recordcount it works fine.

  3. #3
    Join Date
    Dec 1969

    Default RE: And the cursors are...

    Yes, you can set a filter to the recordset and then do a recordcount. A cursor other than forwardonly should work.

  4. #4
    MelD Guest

    Default Thanks!

    I just discovered that the exception error had nothing to do with the recordcount..... <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