"Ambiguous name detected" error when you run a procedure in Access
Original KB number: 817411
Note
Requires basic macro, coding, and interoperability skills.
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:
Open the form in Design view.
In Microsoft Office Access 2003, click Code on the View menu.
In Microsoft Office Access 2007, click View Code in the Tools group on the Design tab.
On the Debug menu, click Compile Database Name.
You receive the following error message:
Compile error: Ambiguous name detected: Procedure Name.
Notice the procedure name, and then click OK.
In the code, find the other occurrences of the Procedure Name procedure, where Procedure Name produced the compile error mentioned in step 3.
Select and then delete the unwanted procedure.
On the Debug menu, click Compile Database Name.
On the File menu, click Close.
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για