| Chat with a LIVE Microsoft
Access Expert! |
||||
|
||||
|
#1
|
|||
|
|||
|
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? |
| Sponsored Links |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
||||
|
||||
|
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. ![]() .................................................. ......
|
| Sponsored Links |
![]() |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Ambiguous Name Detected. Help!!! | adenwalker | General | 2 | 03-01-2005 02:44 AM |
| Logon Error (Ambiguous Name Detected) | frankbutcher | Forms | 6 | 11-25-2004 06:09 AM |
| Ambiguous Name Detected | Crampton | Modules & VBA | 3 | 05-30-2003 05:40 AM |
| Error Message: Ambiguous Name Detected | penfold | Macros | 1 | 01-29-2001 05:42 PM |
| Ambiguous name | Ria | Forms | 1 | 12-29-1999 03:13 PM |