Access Design View - working on a button

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yallair408
    New Member
    • Apr 2015
    • 1

    Access Design View - working on a button

    I am trying to have a button in my database and the following message keeps appearing.
    The expression ON Click you entered as the event property setting produced the following error: Ambiguous name detected: forms-in-client-folder-Click.
    I played in my form properties and if I erase event it still not working.
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Ambiguous name errors typically occur when there are two or more procedures in the code with the same name, a field or control duplicate names, or a reserved name/token is used as either a control or field name.

    Here's the info from Microsoft: The expression Event_Name you entered as the event property setting produced the following error: Ambiguous name detected: EventProcedure_ Name.
    To work around this problem, delete the unwanted duplicate procedure. To do this, follow these steps:
    1.Open the form in Design view.
    2.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.
    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.

    Comment

    Working...