|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 27th, 2007, 05:49 PM
posted to microsoft.public.access.queries
|
|||
|
|||
How do I disable 'Enter Parameter Value' prompt on an existing Que
I'm getting a pop up box when I try to open an exisitng, saved Query that
says "Enter Parameter Value" - I'm positive that that's a new thing, because I've saved most of the Queries in there and never had to enter it before. How can I disable that pop-up box? 
|
|
#2
December 27th, 2007, 05:53 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I disable 'Enter Parameter Value' prompt on an existing Que
That pop-up pops up because Access looks at the query and sees a parameter
for which it needs to prompt for an input value. Have you opened the query in design view and looked for a parameter? Regards Jeff Boyce Microsoft Office/Access MVP "QuickQuestion" wrote in message ... I'm getting a pop up box when I try to open an exisitng, saved Query that says "Enter Parameter Value" - I'm positive that that's a new thing, because I've saved most of the Queries in there and never had to enter it before. How can I disable that pop-up box?
|
|
#3
December 27th, 2007, 06:16 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I disable 'Enter Parameter Value' prompt on an existing Que
QuickQuestion wrote:
I'm getting a pop up box when I try to open an exisitng, saved Query that says "Enter Parameter Value" - I'm positive that that's a new thing, because I've saved most of the Queries in there and never had to enter it before. How can I disable that pop-up box? Whatever you are prompted to enter is something you used in the query. Maybe you misspelled a field name or mistyped an expression. -- Marsh MVP [MS Access]
|
|
#4
December 27th, 2007, 08:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I disable 'Enter Parameter Value' prompt on an existing
Make sure you actually look at the SQL, since the parameter may not be
visible on a criteria row in the design view. Dale -- Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. "Jeff Boyce" wrote: That pop-up pops up because Access looks at the query and sees a parameter for which it needs to prompt for an input value. Have you opened the query in design view and looked for a parameter? Regards Jeff Boyce Microsoft Office/Access MVP "QuickQuestion" wrote in message ... I'm getting a pop up box when I try to open an exisitng, saved Query that says "Enter Parameter Value" - I'm positive that that's a new thing, because I've saved most of the Queries in there and never had to enter it before. How can I disable that pop-up box?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
