Ange
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Chris B
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.