Results 1 to 5 of 5
  1. #1
    Hashirama is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Location
    Mount olympus
    Posts
    11

    [Macro]Apply filter's where expression is not working.

    Button (Command 133) On click:
    Apply filter:



    Where=
    Code:
    [Status]="Done_s" Or [Status]="No_s"
    I don't see anything wrong there.
    When I click on this I get nothing

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    That command returns a TRUE or FALSE...
    You want the or in the string:

    "[Status]='Done_s' Or [Status]= 'No_s'"

  3. #3
    Hashirama is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Location
    Mount olympus
    Posts
    11
    Oh, I see. Thank you very much
    What about [Status]="'Done_s' Or 'No_s'"?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    no, it has to know what field is filtered on each.

  5. #5
    Hashirama is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Location
    Mount olympus
    Posts
    11
    Ok, thank you very much

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro to apply filter to form
    By mattzkn in forum Macros
    Replies: 3
    Last Post: 12-11-2013, 12:57 AM
  2. Replies: 1
    Last Post: 04-28-2013, 09:43 PM
  3. Replies: 2
    Last Post: 02-25-2013, 10:47 AM
  4. Replies: 5
    Last Post: 02-07-2013, 12:21 PM
  5. Macro Filter not working....
    By avarusbrightfyre in forum Access
    Replies: 2
    Last Post: 06-18-2011, 04:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums