left and right functions not found on specific computer

[Marty]

we have a shared database which uses left() and right() functions in a macro.
this database works flawlessly on all computers except one. MINE. we typed
?Left([Forms]![Maint].[ActiveControl].[Tag],1) in the immediate window in VBA
window and we get this error: run time error 40036 application defined or
object defined error! since it works on all other computers we thought it
was a reference problem. we have no "Missing" references and they are all
the same as other computers. r we missing something? thanks for your help

 

[Dorian]

Maybe there is no 'active control'?
If you have LEFT or RIGHT function in a code module, will your code compile?
If not, its a reference, if it compiles, its something else.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[John W. Vinson]

we have a shared database which uses left() and right() functions in a macro.
this database works flawlessly on all computers except one. MINE. we typed
?Left([Forms]![Maint].[ActiveControl].[Tag],1) in the immediate window in VBA
window and we get this error: run time error 40036 application defined or
object defined error! since it works on all other computers we thought it
was a reference problem. we have no "Missing" references and they are all
the same as other computers. r we missing something? thanks for your help

Someone on the groups had a similar problem a few days back; it turned out
that he'd dim'd a variable named Left.

Try bringing up the immediate window and typing

?Left("abc", 1)

to see if it returns "a" or gives an error.

 

[Marty]

we have a shared database which uses left() and right() functions in a macro.
this database works flawlessly on all computers except one. MINE. we typed
?Left([Forms]![Maint].[ActiveControl].[Tag],1) in the immediate window in VBA
window and we get this error: run time error 40036 application defined or
object defined error! since it works on all other computers we thought it
was a reference problem. we have no "Missing" references and they are all
the same as other computers. r we missing something? thanks for your help

the left(abc,1) returned a so it wasn't the left function. it ended up that
i made a new form and copied all the controls from the old form and pasted it
to the newone and all the code and macros worked....i think it was kinda
corrupted....doesn't make sense because it worked on other computers. maybe
my computer is female...lol