Article ID: 815284 - Last Review: September 26, 2003 - Revision: 3.0

ACC97: "Ambiguous Name Detected" Error Message When Procedure Is Executed

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2000 version of this article, see 817411  (http://support.microsoft.com/kb/817411/EN-US/ ) .
Expand all | Collapse all

SYMPTOMS

When you run a procedure, 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: <Procedure_Name>.
Back to the top

CAUSE

This behavior occurs when multiple procedures with the same name are in a module.
Back to the top

WORKAROUND

To work around this problem, you can delete the duplicate procedures. 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 Loaded Modules.

    You receive the following error message:

    Compile error:
    Ambiguous name detected: <Procedure Name>.
  4. Write down the <Procedure Name> and then click OK.
  5. Look through the code and find the other occurrences of the <Procedure Name>, where <Procedure Name> is the procedure that produced the compile error in step 3.
  6. Select and then delete the unwanted procedure.
  7. On the Debug menu, click Compile Loaded Modules.
  8. On the File menu, click Close.
Back to the top

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
163842  (http://support.microsoft.com/kb/163842/EN-US/ ) ACC: Compile Error After Converting Form Macros to VBA
171072  (http://support.microsoft.com/kb/171072/EN-US/ ) ACC97: No Error When AddFromFile Creates Duplicate Procedure
Back to the top
APPLIES TO
  • Microsoft Access 97 Standard Edition
Back to the top
Keywords: 
kberrmsg kbprb KB815284
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations