what does "Ambiguous Name Detected" Mean?

[Guest]

I have a button that runs a macro containing a condition that makes the
action dependent on a couple of passwords in
[Forms]![Viewer_Login]![txtUserpwd]

The button works fine on forms that are the "children" of the main
switchboard but when I try to make it work from the main switchboard I get
the error message,"Ambiguous Name Detected: Command59_click".

Help!

Thanks
Paul

 

[tina]

sounds like you have more than one procedure with the same name in your
switchboard form's VBA module. open the form in design view, and click once
on the command button to select it. in the Properties box, click on the
Events tab and scroll down to the OnClick event. you should see
[Event Procedure]
on the line. click anywhere in that line, and you'll see a Build button
(...) at the right. click the button, and it will take you into the VBA
Editor window, to the procedure - well, to one of them, anyway. leave your
cursor where it is, and on the menu bar click Edit | Bookmarks | Toggle
Bookmark.
scroll through the code until you find the other procedure with the same
name. you need to delete one of them. if you don't know which to delete,
then post back with an explanation of what is supposed to happen when the
command button is clicked, and copy/paste *both* procedures into the post.
that way we can help you determine which procedure to remove from the form.

hth

 

[Jeff Conrad]

In addition to Tina's excellent answer, here are some KB articles on the subject.

You receive an "Ambiguous name detected" error message while running a
procedure in Access 2000 or in Access 2003:
http://support.microsoft.com/?id=817411
ACC97: http://support.microsoft.com/?id=815284

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[tina]

you go, Jeff!
btw, thanks for the plug <bows> talk about painting a word picture...hmm,
possible subject for one of my .pdf illustrations? <g>

In addition to Tina's excellent answer, here are some KB articles on the subject.

You receive an "Ambiguous name detected" error message while running a
procedure in Access 2000 or in Access 2003:
http://support.microsoft.com/?id=817411
ACC97: http://support.microsoft.com/?id=815284

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

I have a button that runs a macro containing a condition that makes the
action dependent on a couple of passwords in
[Forms]![Viewer_Login]![txtUserpwd]

The button works fine on forms that are the "children" of the main
switchboard but when I try to make it work from the main switchboard I get
the error message,"Ambiguous Name Detected: Command59_click".

 

[Jeff Conrad]

in message:

you go, Jeff!
btw, thanks for the plug <bows> talk about painting a word picture...hmm,
possible subject for one of my .pdf illustrations? <g>

Yep that sounds good.
How about pressing the Control Wizard from last week as well?

 

[tina]

How about pressing the Control Wizard from last week as well?

thanks, good idea - it definitely goes on the list.

 

[Guest]

Well, I'm happy my little question brought you two together :O)

Thanks, Tina, I'll try that.

Paul

 

[tina]

Well, I'm happy my little question brought you two together :O)

oh, most of us "regulars" run into each other in the NGs from time to time,
and occasionally have a little sidebar. we've both had a sharp eye on you,
though, to see if you needed any further assistance in this thread.

Thanks, Tina, I'll try that.

you're very welcome, post back if you hit a snag.