License Problem or Syntax error

[Cameron Sutherland]

The computers that are getting the messages are missing a
non-standard DLL that you have referenced on your PC. The
code stops on 'Left' only because when they open the
Access file the missing DLL stopped the rest of the
references from loadng including the one that let Access
understand the function word 'Left'. You might have placed
an ActiveX object that they don't have installed or your
development PC might have included the reference from some
long forgotton add-in you installed.

If you go to one of the computers that is having the
problems and open the file (you'll have to do this with
the MDB not MDE) while holding down the Shift key (bypass
startup options you might have) then go into any code.
From the menu go to Tools-->References... and this will
show all the references that you have. That computer will
have one (or multiple) that are prefixed
with "Missing...". If it is something you don't need then
remove the check mark. If it is for something you added
like an Open Dialog box ActiveX then you will have to find
the EXACT (!) version of the DLL that your PC uses (this
is called DLL Hell is many technical articles) and
register it on the users PC.

-Cameron Sutherland