473,398 Members | 2,368 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

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.
Apr 21 '15 #1
1 1337
zmbd
5,501 Expert Mod 4TB
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.
Apr 21 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: David Deacon | last post by:
Hi i was given the following advise,below my OriginalQuestion I am a little new to ADOX can you direct me to the following Do i place the code behind a button on a form? Or do i place it in the...
2
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. ...
1
by: alan.rolfe | last post by:
Using Access 2002 (in Access 2000 mode). Can anyone tell me how I can alter the text size for the design view of tables etc.? I can adjust the datasheet view by using 'options' but the design view...
4
by: Seyi1 | last post by:
I am attempting to create a report with sub-totals in the body of the report and a total at the bottom. how do I go about doing this thanks: here is an example of the result I need to achive ...
2
by: Sandro997 | last post by:
There exist some forms in my application which existed before I arrived. Many of these forms are such that when they are open, then the "design view" button in the toolbar at the top of the screen...
1
by: =?Utf-8?B?VGlnZXJtYW4=?= | last post by:
The website I have saved in Front Page 2003 no longer gives me the abiolity to use the design view. I only get the code view showing the HTML. This makes it very difficult to make modifications...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
1
by: Farhaad Faaique | last post by:
Dears, how can i enable a from's design view when it is disabled? (the database doesn't have any passwords to be accessed but it has password for vba codes). thanks in advance, Farhaad
4
by: marcnz | last post by:
Hi, I am working for a company which as a MS SQL backend and Access as front end. We update automatically each access db on the user local machine when a new feature has become available. We...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.