Access Select Query prompts for user to enter parameter value?

Posted on 2012-09-19
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

    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

    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.
    LVL 1

    Accepted Solution

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This is an explanation of a simple data model to help parse a JSON feed
    A short article about problems I had with the new location API and permissions in Marshmallow
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now