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

Ask a Question

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.