Access Select Query prompts for user to enter parameter value?

Posted on 2012-09-19
Medium Priority
Last Modified: 2013-01-22
I have a simple select query in MS Access that relies on another query and table joined to provide the fields needed in the select query.

My query has two field that are based on the results of the query used as a data source, which I have grouped the one field using 'Count' and the other using 'Sum'.

When I launch my select query Access prompts the user to 'Enter Parameter Value' with an ok/cancel window.  I do not want to enter a parameter (obviously) as I'm trying to sum and count the data for those two fields so I just click 'OK' and Access does what I need.

My question is:  Is there a way to pass a default value or a way to turn off that prompt?

My database is intended for less savvy users and I do not want them to be prompted by the Enter Parameter Value windows.  Thanks!
Question by:WEBEJOH
LVL 61

Expert Comment

ID: 38415012
What are the SQL statements for your queries, and what parameters are you being prompted for?  

MS Access that relies on another query

Does that other query prompt you for a parameter?
LVL 31

Expert Comment

by:Helen Feddema
ID: 38418456
Check that all field names are correct; one cause of this popup is an invalid field name, say one that has been changed or no longer exists in the table.  If that is not the problem, you may need to run a make-table query from the Totals query, and then use that as the record source of a final query.

Accepted Solution

dzaldivar earned 2000 total points
ID: 38419281
If something changes in the previous queries or you added "Totals/First/Last/Sum..." to one of the previous queries the field names change to "Firstof...", "Last of..." or "Sumof...". This then makes the Query prompt you for a "Parameter". Also check to see if there is a value in the "Parameters" (See attached 2007  example).
LVL 53

Expert Comment

ID: 38804736
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Starting up a Project
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question