Microsoft KB Archive/303134

= &quot;Enter Parameter Value&quot; dialog box appears when you run a query, a form, or a report =

Article ID: 303134

Article Last Modified on 4/11/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q303134



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2000 version of this article, see 301545.



For a Microsoft Access 97 version of this article, see 302690.



SYMPTOMS
When you try to run a query, a form, or a report, the Enter Parameter Value dialog box may appear unexpectedly.



CAUSE
This behavior occurs when a field, a criteria, an expression, or a control in a query, a form, or a report references a name that Access cannot find. For example, a name could be misspelled or a field may not be available within that scope.



RESOLUTION
To resolve this behavior, rename the reference to a valid field name. If you do not know where the reference is located, run the Database Documenter for the object listed in the Enter Parameter Value dialog box, and then output the information to a text file. To do so, follow these steps:
 * If you use Access 2002 and 2003, follow these steps:
 * On the Tools menu, point to Analyze, and then click Documenter.
 * Click the tab that corresponds to the type of database object that you are looking for, and then click to select the check box of the query, the form, or the report that you tried to run.

Note If the object is a form or a report, include all source queries and subforms or subreports in your list of selections.
 * Click Options to specify which feature of the selected object you want to print, and then click OK.
 * Click OK to close the Documenter dialog box.
 * On the File menu, click Export.
 * In the Save as type list, click Text Files, and then complete the remainder of the information as needed.
 * Open the exported file in Microsoft Word, and then search for the parameter requested in the Enter Parameter Value dialog box.
 * If you use Access 2007, follow these steps:
 * On the Database Tools tab, click Database Documenter in the Analyze group.
 * Click the tab that corresponds to the type of database object that you are looking for, and then click to select the check box of the query, the form, or the report that you tried to run.

Note If the object is a form or a report, include all source queries and subforms or subreports in your list of selections.
 * Click 'Options' to specify which feature of the selected object you want to print, and then click OK.
 * Click OK to close the Documenter dialog box.
 * In Data group, click Text File, and then complete the remainder of the information as needed.
 * Open the exported file in Microsoft Word, and then search for the parameter requested in the Enter Parameter Value dialog box.

If you cannot run the Database Documenter, check to see if there is a missing reference. The most common missing reference in this case is to the Utility.mda. To check for this reference, follow these steps:
 * 1) In the Database window, click Modules under Objects.

Note If you use Access 2007, on the Database Tools tab, click Visual Basic, and then go to step 3.
 * 1) Select any existing module, and then click Design or insert a new module. This will start the Visual Basic Editor.
 * 2) On the Tools menu, click References.
 * 3) In the Available References list, look for any reference that has &quot;MISSING: &quot; in front of the name. Click to clear the check box.

NOTE: If you do not need a reference to Utility.mda, skip to step 8.
 * 1) Click Browse.
 * 2) In the Files of type list, click Add-ins (*.mda).
 * 3) Browse to the folder that contains Utility.mda, select it, and then click Open. By default, this file is in the folder C:\Program Files\Microsoft Office\Office\1033.
 * 4) Click OK.
 * 5) On the Debug menu, click Compile  .
 * 6) On the File menu, click Close and Return to Microsoft Access.



Steps to reproduce the behavior in Access 2002 or in Access 2003
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.


 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Order Subtotals query in Design view.
 * 3) Rename the OrderID field to OrderIDNumber.
 * 4) Close the query, and then click Yes to save the changes.
 * 5) Run the Order Subtotals query.
 * 6) Note that the Enter Parameter Value dialog box appears.

Additional query words: prb trim ACC2002 ACC2003 reviewdocid ACC2007 kbnoOfficeAlertID

Keywords: kbreport kbprb KB303134

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.