Results 1 to 4 of 4

filtering split form with mySQL back end?

  1. #1
    stephen c is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    30

    filtering split form with mySQL back end?


    When going to mySQL, you lose the nice sort/select in datasheet and splitforms for users. Ugh. What is the syntax to teach folks for "and" or "or" in using the limited boxes you have? For example, if you drop the choices for a split form, you get can get "contains" as an option. What I don't know is how to say "this AND that" and get it to work. Maybe it just wont?

    Thanks in advance.

    Stephen.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,287
    Please tell us more. An example may help if you have one.

  3. #3
    stephen c is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    30
    Our client's sites are named things like HOM.123 for Home Depot store #123. Or LOW.123 for Lowes #123. So in a "clientSite" field of a split form, you will have thousands of sites, all using this naming convention. There are many different customers. If you wanted to display a list of those "beginning with" LOW or HOM, how would you do that?

    The native drop list has "begins with" which is fine, but I don't know what to tell it. I've tried a few different "and" "or" and other operations, and am clearlhy missing something.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,287

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

Similar Threads

  1. Filtering split form with selections from a listbox
    By stephenaa5 in forum Programming
    Replies: 5
    Last Post: 02-17-2016, 05:36 PM
  2. back color based on value in split form
    By vicsaccess in forum Programming
    Replies: 5
    Last Post: 12-16-2015, 10:04 PM
  3. Replies: 3
    Last Post: 07-30-2014, 05:04 PM
  4. Filtering records on a split form
    By Accessbeginner23 in forum Programming
    Replies: 1
    Last Post: 07-02-2012, 03:23 PM
  5. access split DB to mySQL (backend only)
    By rnbwkat in forum Access
    Replies: 1
    Last Post: 05-31-2010, 07:19 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
  •  
Tech Forums: Microsoft Office Forums