Chat with a LIVE Microsoft Access Expert!
 
       
 

         

   

Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
 
Chat with a LIVE Microsoft Access Expert!
Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-13-2006, 05:04 PM
agates agates is offline
ServMgr2004
 
Join Date: Jul 2005
Location: Georgia
Posts: 3
agates is an unknown quantity at this point
Send a message via Yahoo to agates
Ambiguous name detected: IsLoad

I have a program that will allow you to enter new users. Once I click the ADD button, I get this error. "Ambiguous name detected: IsLoad". I have seen this IsLoad error before in my program when I try and compile it, but it has never seemed to be an issue, so I put it on the back-burner until now. I have a snap-shot of the error.

I know it is listed in several places throughout the macros, but I don't know how to change or fix it now. Any ideas?
Reply With Quote
Sponsored Links
  #2  
Old 01-13-2006, 08:20 PM
WayneRyan WayneRyan is offline
AWF VIP
 
Join Date: Nov 2002
Location: Camarillo, CA
Posts: 6,817
WayneRyan has a spectacular aura aboutWayneRyan has a spectacular aura aboutWayneRyan has a spectacular aura about
agates,

Go to the Module Tab on your database window. Somewhere in the
collection of modules is probably a multiple definition of a function called
"IsLoad".

Back up your database & then remove or comment one definition out.

Access will let you define two function with the same name, but it
will not try to decide WHICH one to run.

Wayne
Reply With Quote
  #3  
Old 01-15-2006, 07:53 AM
ghudson's Avatar
ghudson ghudson is offline
Dazed & Confused
 
Join Date: Jun 2002
Location: USA
Posts: 6,044
ghudson has a spectacular aura aboutghudson has a spectacular aura about
Also, the IsLoaded function was finally added to Access 2002/2003 VBA library of installed functions. The old Northwind db sample had a custom IsLoaded function that many folks have been using since Access 95. Perhaps you have the custom IsLoaded function in your db and you are using Access 2002/2003? That would be a conflict [besides Waynes suggestion that you have the function in more than one place in your module(s)].
__________________
.................................................. ......
Searching this forum or Microsoft.com or MSDN.com or Google is a great way to discover and learn the answers to your Access programming questions.

Well if it seems to be real, it's illusion...

I am using Access 2007 with Windows XP

The Advanced Search function on this forum really does work.
.................................................. ......
Reply With Quote
Sponsored Links
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ambiguous Name Detected. Help!!! adenwalker General 2 03-01-2005 01:44 AM
Logon Error (Ambiguous Name Detected) frankbutcher Forms 6 11-25-2004 05:09 AM
Ambiguous Name Detected Crampton Modules & VBA 3 05-30-2003 04:40 AM
Error Message: Ambiguous Name Detected penfold Macros 1 01-29-2001 04:42 PM
Ambiguous name Ria Forms 1 12-29-1999 02:13 PM


All times are GMT -8. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
(c) copyright 2009 Access World