Results 1 to 5 of 5
  1. #1
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2013
    Posts
    93

    Trouble With User Query

    On my attached database, I want the user to search for any item they want, and the query to pull up all orders in "Load List" table with matching that item's description.
    What I would like to do is modify the query "Part Query" to allow a user to enter their own criteria. I am told through internet search that I must go through a very complicated process using forms and macros.
    I have tried to do this, using the form "Find An Item" and the query "User Search Query"
    When I use the search form, it pulls quantity from table "Load Lists" but I want it to pull description. At first the search was working (although pulling from wrong field) but now it is not at all.

    This seems like a really easy thing to do but is actually complicated. I think I'm missing something.

    Any help would be appreciated! Thanks!

    P.S. Tried to attach my database but file size exceeds max. How can I reduce the size of my file, to attach? Tried making a copy and deleting records, but can't delete multiple records at once.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Do a compact and repair on your database, then create a zip file.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    If file still too large after those steps, can upload to fileshare site such as Box.com and post link.

    Options for the filtering:

    1. dynamic parameterized query references form controls for input, review: http://datapigtechnologies.com/flash...mtoreport.html

    2. use VBA to construct filter criteria string, review: http://www.allenbrowne.com/ser-62code.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2013
    Posts
    93
    OK Here goes. File attached...
    Attached Files Attached Files

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Suggest you adopt a naming convention that only allows alpha and numeric characters and underscore "_". Special characters like space/blank and "#" will cause you all sorts of syntax errors. Change now, you'll be glad you did.

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

Similar Threads

  1. SQL Query Trouble in Access
    By aglenn in forum Queries
    Replies: 4
    Last Post: 12-18-2013, 06:51 PM
  2. Login Form/User ID Trouble.
    By Addanny in forum Forms
    Replies: 2
    Last Post: 07-03-2013, 10:25 AM
  3. Trouble Designing a Query
    By marshymell0 in forum Queries
    Replies: 5
    Last Post: 12-20-2012, 02:17 PM
  4. Trouble Printing Report on User Machine.
    By Robeen in forum Access
    Replies: 1
    Last Post: 02-27-2012, 02:40 PM
  5. Trouble with Query
    By jbarrum in forum Access
    Replies: 1
    Last Post: 01-13-2010, 04:10 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