different referene in Access 2000 and Access 2003?

  • Thread starter Thread starter Barmaley
  • Start date Start date
B

Barmaley

My code works fine in Access 2000, but when I tried to run it under Access
2003 got "function not defined" errors on something simple as LEFT(),
RIGHT() which I thought pretty basic commands.
In references nothing marked as missing.

If you need more info let me know, as right now I don't know what else to
tell you.

Thanks

Artem
 
A reference that has not been set will not show as missing. Missing means a
reference has been set, but the file referenced can not be found. You need
to find the references you need and set them.
 
My code works fine in Access 2000, but when I tried to run it under Access
2003 got "function not defined" errors on something simple as LEFT(),
RIGHT() which I thought pretty basic commands.
In references nothing marked as missing.
Click to expand...

Try opening the References dialog (Ctrl-G to open VBA, Tools...
References on the menu).

Check *some* reference that is currently unchecked (it doesn't matter
which). Select Debug... Compile; close and open Access; uncheck the
reference; compile again.

This will force Access to update its reference links, and should
either fix the problem or "wake up" Access to the fact that some
reference is in fact MISSING.

John W. Vinson[MVP]
 
That's a thing - it is Access 2000 MDB file, and so far if I opened that
file on other systems with different set up it was telling me that reference
is missing, but not in this case.

~~
~~

Never mind, I found the problem
Under Access 2003 for some reason I had to specify parent
Strings.Left
Strings.Right

Thanks for looking

Artem
 
Thank you John,

I missed your post when I was typing my previous reply.
I had to add "Strings." to my strings functions and now it's working.
I guess Access 2003 wants me to be more specific, but itself not giving me
more specific error LOL

Thanks again John for looking into it.
 
I missed your post when I was typing my previous reply.
I had to add "Strings." to my strings functions and now it's working.
I guess Access 2003 wants me to be more specific, but itself not giving me
more specific error LOL
Click to expand...

I wonder if you have a user-defined function named Left() and it's
tripping over the name ambiguity!

John W. Vinson[MVP]
 
I know that I didn't do user-defined function
Even if I would do it - it wouldn't be all of them.
It seems that it affected all the "Strings." functions under Office 2003
 
Back
Top