Left function error

[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

 

[Ron Weiner]

Sounds like you have a broken reference. Take a look at
http://www.mvps.org/access/bugs/bugs0001.htm for some help in rectifying
this condition. While the above reference refers to Access 97, it applies
equally to all versions.

Ron W

 

[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

 

[Douglas J. Steele]

Before recommending decompiling, I think it's important to point out that
decompiling CAN lead to problems.

The best reference I know on this topic is what MichKa has at
http://www.trigeminal.com/usenet/usenet004.asp