ACC2000: "Enter Parameter Value" Dialog Box Appears When You Run Query, Form, or Report (301545)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q301545
This article applies only to a Microsoft Access database (.mdb).

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

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

For a Microsoft Access 2002 version of this article, see 303134.

SYMPTOMS

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

CAUSE

This behavior can occur if a field, criterion, expression, or control within a query, form, or report references an object that Access cannot find. For example, a name might be misspelled or a field might not be available in that scope.

RESOLUTION

To resolve this behavior, run the Database Documenter for the database object that you were using when the Enter Parameter Value dialog box appeared. Export the report as a text file, and then search for the parameter that Access cannot find:
  1. On the Tools menu, point to Analyze, and then click Documenter.
  2. Click the tab that pertains to the kind of database object, and then click to select the check box for the query, form, or report that you are trying to run.

    If the object is a form or a report, include all source queries and subforms or subreports in your list of selections.
  3. Click Options, specify which options of the selected object you want to search through, and then click OK.
  4. Click OK.
  5. On the File menu, click Export.
  6. In the Save as type list, click Text Files, and then complete the remainder of the information as needed.
  7. Open the exported file in Word, and then perform a search for the parameter that is 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.
  2. Select any existing module, and then click Design or insert a new module. This will start the Visual Basic Editor.
  3. On the Tools menu, click References.
  4. In the Available References list, look for any reference that has "MISSING: " 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.
  5. Click Browse.
  6. In the Files of type list, click Add-ins (*.mda).
  7. 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.
  8. Click OK.
  9. On the Debug menu, click Compile database name.
  10. On the File menu, click Close and Return to Microsoft Access.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbprb KB301545
©2004 Microsoft Corporation. All rights reserved.