Repeat Paramter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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.
 
Thanks Steve.

Steve Schapel said:
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.
Click to expand...
 
after running the query the first time, from datasheet view, try Shift +
F9...works everytime.
 
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
 
Back
Top