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
|
|||
|
|||
"inter parameter value"
"inter parameter value"
i get prompt "inter parameter value" when i open query . how do i can to prevent it? thanks |
#2
|
|||
|
|||
"inter parameter value"
siahman wrote:
"inter parameter value" i get prompt "inter parameter value" when i open query . how do i can to prevent it? thanks Your query is referring to an object that does not exist within its scope when the query runs. A misspelled field name, prehaps? Or a reference to a form control whose form is not open? To prevent it, you have to fix whatever is wrong. You can figure out for yourself what the problem is by removing elements from the query until the symptom stops appearing when you test the query. For more specific help, you need to show us the query that is causing the problem. Switch to SQL View and copy/paste the sql statement into your reply to this message. It would really help if you followed the advice given above to try to identify the text in the query that is causing the error. -- HTH, Bob Barrows |
#3
|
|||
|
|||
"inter parameter value"
That's Enter Parameter Value. Access is looking for some value to run the
query properly. It could be a number of things. There's only one practical way for us to know: Show us the SQL. Open the query in design view. Next go to View, SQL View and copy and past it here. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "siahman" wrote: "inter parameter value" i get prompt "inter parameter value" when i open query . how do i can to prevent it? thanks |
#4
|
|||
|
|||
"inter parameter value"
On Tue, 19 Jan 2010 08:21:01 -0800, siahman
wrote: "inter parameter value" i get prompt "inter parameter value" when i open query . how do i can to prevent it? thanks dig a hole and bury (inter) it...??? The prompt (if you have an English languange installation) is surely "Enter parameter value", and it's asking you to provide the value of some parameter (it tells you what parameter, but you didn't tell us) that it can't recognize. If you have anything in your query in [square brackets] which Access can't recognize you'll get the prompt. Sometimes this can be a valid way to ask the user to provide a criterion for a query; or it can be a misspelled fieldname, or something else that Access can't recognize. Please open the query in design view, select View... SQL from the menu, and post the SQL text of the query to a message here. Indicate what parameter Access is prompting you for, and if need be the fieldnames in your table. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|