[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

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

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.
3 Solutions
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.

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

Chris B
AngeAuthor Commented:
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.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

If you don't want to adopt either of the suggested alternatives you just have to put up with the prompts.
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
Jeffrey CoachmanCommented:

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now