Filter for true false

Discussion in 'Microsoft Access Macros' started by Biss, May 26, 2009.

  1. Biss

    Biss Guest

    Hi I am using Access 07
    I am using a macro to ApplyFilter.

    In the Where Condition I have this statement

    [Addresses]![Catagory]="Performer" And [Addresses]![InActive]="False"

    When I run the filter I receive a data mistype error.

    I have tried the following and still get the error.

    [Addresses]![InActive]="False"

    In the underlying table there is a field named [InActive] which is simple
    "Yes" or "No" Field.

    Please advise who to filter for simple yes or no answers.

    Many thanks

    Bob
     
    Biss, May 26, 2009
    #1
    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. Jeff

    setvalue forms!form1.visible=false error

    Jeff, Apr 22, 2004, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    281
    Guest
    Apr 23, 2004
  2. Peter Jamieson

    Appending record with VBA when surname is True(sic)

    Peter Jamieson, May 12, 2004, in forum: Microsoft Access Macros
    Replies:
    13
    Views:
    454
    onedaywhen
    May 17, 2004
  3. Peter Jamieson

    Attention Steve Schapel, Re True(sic)

    Peter Jamieson, May 18, 2004, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    232
    Peter Jamieson
    May 18, 2004
  4. Guest

    call a macro when record added and field set to 'True'

    Guest, Jun 10, 2005, in forum: Microsoft Access Macros
    Replies:
    4
    Views:
    330
    Guest
    Jun 10, 2005
  5. Guest

    message box if a condition is true or false

    Guest, Feb 28, 2006, in forum: Microsoft Access Macros
    Replies:
    6
    Views:
    687
    Guest
    Mar 3, 2006
  6. Jill

    DoCmd.SetWarnings False is not working

    Jill, Jan 16, 2008, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    9,994
  7. Victoria@DIG

    Using Macro to Open Filter by form, clear grid, then run filter

    Victoria@DIG, Apr 20, 2008, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    1,066
    Victoria@DIG
    Apr 20, 2008
  8. Biss

    Filter for true false

    Biss, May 26, 2009, in forum: Microsoft Access Macros
    Replies:
    6
    Views:
    879
    Steve Schapel
    May 26, 2009
Loading...