Trim Function

J

Jake

Off the top of my head, that looks like a custom trim
function, either from a custom library or MDB file named
VBA...does the function work any differently the the
standard Trim()?

Jake
 
A

Allen Browne

Here's a copy of the answer given previously:

Unless the database has a library marked "MISSING", it appears to believe
there is something else named "Trim". It could be an object, module, public
variable or even the project itself.

If you can't find any such object after a good search, you may be able to
straighten it out by declaring a public function named Trim in a new module.
Compile, and save. Delete the module. Compact the database. Compile again.
If you're in luck, Acces/VBA will have reassigned its Trim() to the new
function, and then freed it up when you deleted the module.
 
K

Keith

Check the reference list to see if ANY library reference
is marked as "MISSING". This will cause a compilation
error as the VBA interpreter tries to resolve references
when actioning lines of code.

This could happen because you have changed a version of a
program. For instance, if you have included a reference
to an older version of Outlook and not corrected it in
the upgraded program, or if you move the database to a
different PC where a program is not installed.
 
Top