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?

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. Jake Jessup

    Subform ApplyFilter Problem

    Jake Jessup, Aug 12, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    138
    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:
    130
    Arvin Meyer
    Aug 12, 2003
  3. Eric

    ApplyFilter Command

    Eric, Oct 21, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    130
    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:
    91
    Arno R
    Dec 30, 2003
  5. Gary

    ApplyFilter?

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

    ApplyFilter II?

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

    ComboBox ApplyFilter method

    Michelle, Feb 5, 2004, in forum: Access Forms Coding
    Replies:
    1
    Views:
    76
    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:
    261
    Marc Hillman
    Feb 7, 2004
Loading...