Results 1 to 3 of 3
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Enter parameter values box loops & never closes

    I created a query that is what I call the master query in the database I created. I then created separate queries (for each manufacturer we buy from) off of this query.

    This query searches through three (3) tables and lists in alphabetical order the Manufacturer Company Name, our part number, our part description and the manufacturer's part number. There are six (6) values to enter in the parameter box when any of the queries are selected to run.

    I inadvertently entered the wrong value in the box and pressed enter before I realize what I had done.

    Now the box keeps cycling (looping) requesting the same values entered multiple times without showing the finished results.

    I've tried several options for this via Microsoft support, but they don't work. The only way I've gotten around it, is by deleting the original saved query, then recreating the query and naming it the EXACT same name.

    Any other suggestions for fixing this issue in the future?

    Thank you,

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I've never had that problem, but most of us don't use parameter prompts ("[Enter blah]") for query criteria, we use forms. You have much more control that way, and no prompts.

    Why separate queries for each manufacturer? Normally you'd just use a parameter for that, one query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    "Why separate queries for each manufacturer? Normally you'd just use a parameter for that, one query."

    1. Because when I initially created the database, I had very little knowledge of Access.
    2. Also, information keeps getting added to the Active, Suppliers and Component Description tables. And,
    3. Because, we send the reports to suppliers for item LCM status results and it is easier (on me) to run the separate query, then the report before (which are already set up), than for me to set it up from the query each time.

    Thank you,

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

Similar Threads

  1. Get Rid of Enter Parameter Values
    By rpraveen6r in forum Queries
    Replies: 2
    Last Post: 07-12-2016, 08:00 AM
  2. Replies: 8
    Last Post: 07-15-2014, 05:56 PM
  3. Forever Enter Parameter Values
    By c.yyang in forum Access
    Replies: 2
    Last Post: 06-22-2013, 07:37 PM
  4. Replies: 13
    Last Post: 01-10-2012, 09:56 AM
  5. Enter Parameter value?
    By hlcarlin in forum Forms
    Replies: 3
    Last Post: 07-06-2011, 08:09 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