You receive an "Ambiguous name detected" error message while running a procedure in Access 2000 or in Access 2003 (817411)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

When you run a procedure in Microsoft Access 2000 or later, you may receive the following error message:
The expression Event_Name you entered as the event property setting produced the following error: Ambiguous name detected: EventProcedure_Name.

CAUSE

This error occurs when there are multiple procedures with the same name in a module.

WORKAROUND

To work around this problem, delete the unwanted duplicate procedure. To do this, follow these steps:
  1. Open the form in Design view.
  2. On the View menu, click Code.
  3. On the Debug menu, click Compile Database Name.

    You receive the following error message:
    Compile error: Ambiguous name detected: Procedure Name.
  4. Notice the procedure name, and then click OK.
  5. In the code, find the other occurrences of the Procedure Name procedure, where Procedure Name produced the compile error mentioned in step 3.
  6. Select and then delete the unwanted procedure.
  7. On the Debug menu, click Compile Database Name.
  8. On the File menu, click Close.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

209907 ACC2000: Compile Error After Converting Form Macros to VBA

Modification Type:MinorLast Reviewed:6/23/2004
Keywords:kberrmsg kbprb KB817411 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.