Left function error

F

FRED

I'm using the left function in a VBA module of Access 2000 build 9.0.4402
SR-1 and it work on a certain workstation and don't work on another
workstation that has the same version and the same VBA reference so I'm
wondering what could cause the problem. I reinstalled MSAccess full and
doesn't work much more so if somebody know which reference is required in
order to have the left, mid,string function work please let me know.

thanks,

FRED
 
R

Robert Morley

You may want to try decompiling & recompiling your code. Decompiling is
undocumented for Access, if I remember correctly, but it's basically just a
matter of launching Access.exe /decompile "My File.mdb" if I remember
correctly. The /decompile might have to come at the end of the line, I
don't remember exactly...try both.



Rob
 
Top