I used to know about F9 in Excel, but these days I so rarely do anything in it except for looking at someone else's spreadsheets that I'd forgotten all about it. In fact, I've forgotten way too much.
As Homer Simpson says, "Every time I learn something new it pushes out some of the old stuff."
Bill
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> 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