Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / April 2006

Tip: Looking for answers? Try searching our database.

Repeat Paramter Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ahearn - 23 Jun 2005 17:45 GMT
Just learning Access so bear with me if this is a dumb question. I created a
parameter query that promts for a customer's account. The query works fine
and brings up that customer's account information, but I am querying 20
accounts so is there an easy way for the query to show me the dialog box
again? Right now I have to click on Design View then back to Datasheet View
to have the prompt come up again.
Steve Schapel - 23 Jun 2005 20:16 GMT
ahearn,

No, there is no way to do this if you are just opening the query
datasheet, apart from the way you are doing it.

However, in Access, Queries and Query Datasheets are generally regarded
as not suitable for human consumption.  They are usually attended to in
the design phase of the database, but should not really be directly used
for "production" data processes.  You should really be using a Form to
see the data returned by your query, by making the query as the Record
Source of the form.  In this case, you can put a Command Button on the
form, with a macro or VBA procedure, which will do what you want.  Just
make a simple macro with the Requery action, nothing entered in its
Control Name argument, and then assign this macro on the On Click event
property of the button, and every time you click the buttton the
parameter prompt will pop up.

Signature

Steve Schapel, Microsoft Access MVP

> Just learning Access so bear with me if this is a dumb question. I created a
> parameter query that promts for a customer's account. The query works fine
> and brings up that customer's account information, but I am querying 20
> accounts so is there an easy way for the query to show me the dialog box
> again? Right now I have to click on Design View then back to Datasheet View
> to have the prompt come up again.
ahearn - 24 Jun 2005 18:37 GMT
Thanks Steve.

> ahearn,
>
[quoted text clipped - 19 lines]
> > again? Right now I have to click on Design View then back to Datasheet View
> > to have the prompt come up again.
debsumrall - 29 Jun 2005 20:56 GMT
after running the query the first time, from datasheet view, try Shift +
F9...works everytime.

> Thanks Steve.
>
[quoted text clipped - 21 lines]
> > > again? Right now I have to click on Design View then back to Datasheet View
> > > to have the prompt come up again.
kayakfemale29102 - 26 Apr 2006 15:41 GMT
I discovered this as well and use it all the time, however, I would rather
use a one-key option.  Is there any way I can easily change shift+f9 to one
key instead.
Joy

> after running the query the first time, from datasheet view, try Shift +
> F9...works everytime.
[quoted text clipped - 24 lines]
> > > > again? Right now I have to click on Design View then back to Datasheet View
> > > > to have the prompt come up again.
jnnfrspnc - 14 Nov 2005 21:52 GMT
Steve,
Your post was very helfpul.  I would like to go one step further and was
hoping you could help.  I have a table with two fields:  customer location
and site location.  So I created a form with the command button that the user
can hit to keep getting prompted to enter customer location to get site
location information.  The problem I have is that the user can rerun this as
little as 2 times or as many as 50 times.  So in that case we would like the
form (or maybe a report could do this) to print a log of the results from the
form.  So say the user entered one location and hit the command button to run
again to enter another location - he wants to see both results instead of
having to stop and write each one down.  Thanks for your help.  

>ahearn,
>
[quoted text clipped - 19 lines]
>> again? Right now I have to click on Design View then back to Datasheet View
>> to have the prompt come up again.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.