Results 1 to 2 of 2
  1. #1
    DPowell is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2014
    Posts
    2

    Dynamic search string in Web App - How to use it in the WHERE of RequeryRecords?

    Hey folks -
    I'm having a bit of trouble migrating a DB to a web app. I've skimmed through the other entries in this forum, and didn't manage to find what I was hoping, so sorry if this is a re-ask.

    I've got a text string held in a variable in a macro action on a button click. How can I use this variable as the input for a WHERE clause in RequeryRecords?
    Or should I be doing something else to return a subset of records based on check marks on 15 check boxes?



    Thanks for your help,
    Dan

  2. #2
    DPowell is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2014
    Posts
    2
    So, I have found that these variables can not be used as arguments in WHERE clauses.
    So, let me explain differently, and tell me what you recommend :
    I've got a DB of organisations, that all exist in their own provinces, and each one is active in a number of sectors (Trans, Bat, Eaux, etc.), and each organisation is best described by one or more exciting acronyms (OSBL, ONGE, ResdONGE, etc).
    So, I want the (does-not-want-to-learn-complicated-search-text) end user to be able to click fields on a page, select a province, select one or more sector(s), and then hit search, and have the organisations list reduced to just those matching the search terms.

    Suggestions or examples would be appreciated.
    Thanks,
    Dan

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

Similar Threads

  1. Replies: 5
    Last Post: 12-22-2012, 01:36 PM
  2. Search for a String in VBA code.
    By dandoescode in forum Access
    Replies: 3
    Last Post: 06-21-2012, 11:00 AM
  3. Simple Dynamic Client Search
    By Lorne in forum Forms
    Replies: 4
    Last Post: 12-21-2011, 04:58 PM
  4. Creating a dynamic search box in Access 2010
    By bob500000 in forum Access
    Replies: 1
    Last Post: 11-24-2011, 02:27 PM
  5. Create dynamic connection string to Access
    By janwane in forum Access
    Replies: 2
    Last Post: 10-07-2011, 06:56 AM

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