How to stop a query's parameter prompting when I'm testing

Posted on 2007-10-17
Last Modified: 2008-09-13
I'm modifying and testing a parameter query. Each time I run it I get prompted for the parameters. Is there a way of stopping the parameter prompts while I'm doing this? I think I've done this before but I can't remember how. I've tried holding down the Shift, Ctrl or Alt key when I run the query, but that's not working.
Question by:Ange
    LVL 77

    Accepted Solution

    No, there is no way to stop them, if you have used standard parameter fields.

    If you were using form based parameters then you could just leave the form open and then you wouldn't get the prompts.

    LVL 28

    Assisted Solution

    Or write the parameter into the criteria field and replace it later with the prompt.

    Chris B

    Author Comment

    Hi Chris,
    The parameters are already written in the criteria fields. In query design when I switch from design view to datasheet view each prompt pops up. I can carriage return through them it would just be less irritating if I could get to the datasheet view without having to do that.
    LVL 77

    Expert Comment

    If you don't want to adopt either of the suggested alternatives you just have to put up with the prompts.
    LVL 28

    Expert Comment

    Hang on a minute, if you are getting a prompt you have to have something like Between [Enter from date] And [Enter to date]. To avoid this prompt, you would replace it with Between #01/01/2007# And #01/31/2007#. Does this not work for you?

    Chris B
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman

    While you may have deleted the parameters from design view of the query, the call for parametres may still exist as the first statement in the underlying SQL.
    (Something like: PARAMETERS....)
    You must delete the PARAMETERS statement from here as well.

    Click: View-->SQL


    Jeff Coachman

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now