Thanks Crystal!
Time and again, you come up with such gems. Really nice of you to keep sharing with us all.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Crystal
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, June 30, 2012 01:52
Subject: Re: [MS_AccessPros] Is There a More Efficient Way to Run a Parameter Driven Query?
you're welcome, Bill :) thank you
a variation is to press F9 in a combo to requery it
F9 is the Calculate key in Excel
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Bill Mosca
Crystal -
What a handy little tip! Thanks!
Bill
--- Crystal wrote:
>
> Hi Terry,
>
> SHIFT-F9
>
> will prompt you for Query parameters again and show you the new results.
>
>
> Have you thought of using a form to collect the parameters instead of typing them in as a parameter? Then you have the great advantage of choosing from combos and re-using criteria :)
>
>
> Warm Regards,
> Crystal
>
> Access Basics by Crystal (Bill Mosca's site)
> http://thatlldoit.com
> Free 100-page book that covers essentials in Access
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Terry Olsen
>
> I use queries a lot to examine data exception cases. A good number of them accept a parameter. I usually
> Right now, the only ways that I know to run them is to either double-click, enter the parameter, and view the results. To re-run the query with a different query, I either need to close the result set and double-click the query name again OR switch to design view and hit the Run selection.
> Is there a different way to just double click the query name again, respond to the prompt and have the current result set be refreshed.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar