Ambiguous name detected: IsLoad

[agates]

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?

 

[WayneRyan]

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

 

[ghudson]

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)].