Applyfilter

Discussion in 'Access Forms Coding' started by Parker, Sep 16, 2012.

  1. Parker

    Parker Guest

    When I use the applyfilter method how do I check to see if any records were
    returned? I'm using Access 2002 sp3.

    Thankyou
     
    Parker, Sep 16, 2012
    #1
    1. Advertisements

  2. On Sun, 16 Sep 2012 15:12:54 -0500, Parker <> wrote:

    >When I use the applyfilter method how do I check to see if any records were
    >returned? I'm using Access 2002 sp3.
    >
    >Thankyou


    I presume this is on a Form? Check the form's recordsetclone:

    If Me.RecordsetClone.RecordCount > 0 then
    ' records were returned
    Else
    ' none were
    End If
    --

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    http://social.answers.microsoft.com/Forums/en-US/addbuz/
    and see also http://www.utteraccess.com
     
    John W. Vinson, Sep 16, 2012
    #2
    1. Advertisements

  3. Parker

    Parker Guest

    John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in
    news::

    > From: John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
    > Newsgroups: microsoft.public.access.formscoding
    > Subject: Re: Applyfilter
    > Date: Sun, 16 Sep 2012 15:18:40 -0600
    > Organization: Wysard of Information
    > Reply-To: oup
    > Message-ID: <>
    > References: <XnsA0D0A538DB00Cmparker1504@216.196.97.131>
    > X-Newsreader: Forte Agent 6.00/32.1186
    > MIME-Version: 1.0
    > Content-Type: text/plain; charset=us-ascii
    > Content-Transfer-Encoding: 7bit
    > NNTP-Posting-Host: static-74-41-143-137.br1.mcl.id.frontiernet.net
    > X-Trace: news.bnb-lp.com 1347830323
    > static-74-41-143-137.br1.mcl.id.frontiernet.net (16 Sep 2012 17:18:43
    > -0400) Lines: 21
    > X-Authenticated-User: pa1113
    > X-DMCA-Complaints: Send abuse or DMCA complaints to
    > X-DMCA-Complaints: The subject line should contain only the 4 letters
    > DMCA Path:
    > border1.nntp.dca.giganews.com!border4.nntp.dca.giganews.com!

    border2.nnt
    > p.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail

    That worked. Thank you.
     
    Parker, Sep 16, 2012
    #3
    1. Advertisements

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jake Jessup

    Subform ApplyFilter Problem

    Jake Jessup, Aug 12, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    157
    HSalim
    Aug 12, 2003
  2. Paul Kirkaas

    How to "ApplyFilter" on form, without using Menu

    Paul Kirkaas, Aug 12, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    143
    Arvin Meyer
    Aug 12, 2003
  3. Eric

    ApplyFilter Command

    Eric, Oct 21, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    145
    Graham Mandeno
    Oct 21, 2003
  4. webvigator2k

    Need help with forms and applyfilter command

    webvigator2k, Dec 30, 2003, in forum: Access Forms Coding
    Replies:
    2
    Views:
    107
    Arno R
    Dec 30, 2003
  5. Gary

    ApplyFilter?

    Gary, Jan 8, 2004, in forum: Access Forms Coding
    Replies:
    0
    Views:
    98
  6. Gary

    ApplyFilter II?

    Gary, Jan 8, 2004, in forum: Access Forms Coding
    Replies:
    2
    Views:
    120
  7. Michelle

    ComboBox ApplyFilter method

    Michelle, Feb 5, 2004, in forum: Access Forms Coding
    Replies:
    1
    Views:
    88
    Greg Casper
    Feb 5, 2004
  8. Marc Hillman

    Access 97 - Bug in ApplyFilter Event handler

    Marc Hillman, Feb 7, 2004, in forum: Access Forms Coding
    Replies:
    0
    Views:
    279
    Marc Hillman
    Feb 7, 2004
Loading...