Access 2000 Error when opening database

[Cindy]

I have an access database that I get the error "Undefined function 'Trim in expresssion" when I try to open on some machines in my office, but not on others. I installed office updates, ran a repair on access installation, uninstalled/reinstalled office, but still get the error.

 

[Tom Wickerath]

Hi Cindy,

Check the affected PC's for any references marked as "MISSING". To do this, open the
Visual Basic editor (ALT F11), and select Tools > References. If you find a missing
reference, make a note of its description. Then deselect it, and click on OK to dismiss
this dialog box. Attempt to compile your database first without this reference (it may
not even be required). If your code will not compile, then go back in and select the same
reference from the list and repeat the attempt to compile.

VBA can be pretty finicky if any references are missing. More information is available
here:

http://members.iinet.net.au/~allenbrowne/ser-38.html and

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html


Tom

_______________________________________


I have an access database that I get the error "Undefined function 'Trim in expresssion"
when I try to open on some machines in my office, but not on others. I installed office
updates, ran a repair on access installation, uninstalled/reinstalled office, but still
get the error.