The Trim method (Trim, LTrim and RTrim)

I am having problems determining what reference controls
the Trim, LTrim and RTrim methods. The invironment that I
am designing this VBA application will not except the use
of Trim method. The error message comes from Visual basic
and reads "Compile error: Can't find project or library.
I am using it to save files from a database name value
but the string value of the database name field creates a
blank space which I need to remove.

Thanks in advance,

Andrew

Andrew
Tue Aug 10 10:33:04 CDT 2004

Hi,

When I remove the trim statement the application runs
fine. For example, the trim statement is Trim
(strVariable), when I change it to strVariable the
application works fine. The problem is that I need to
remove the dead space at the end of the string so that it
doesn't show up in the final result. To help you
understand, the variable is being used to create a file
name. With the Trim statement the file name should look
like "strVariable.doc" Without the Trim statement the
file name looks like "strVariable .doc" It is the
space that I am trying to remove. The Trim statement is
being rejected.

Thanks in advance,
>-----Original Message-----
>Andrew
>
>When I get this I find it's that it's something else
that has gone wrong,
>usually another reference to an object or a template
which can't be
>resolved.
>
>Sometimes I find it's the Left$() function which
is 'missing' when the
>problem is actually elsewhere.
>
>I find it's actually a bogus message in that it's not
the Trim stuff which
>is missing but something else. What does the Reference
list suggest?
>
>- Malc
>.
>

JB
Wed Aug 11 06:30:02 CDT 2004

Andrew wrote:
> Hi,
>
> When I remove the trim statement the application runs
> fine. For example, the trim statement is Trim
> (strVariable), when I change it to strVariable the
> application works fine. The problem is that I need to
> remove the dead space at the end of the string so that it
> doesn't show up in the final result. To help you
> understand, the variable is being used to create a file
> name. With the Trim statement the file name should look
> like "strVariable.doc" Without the Trim statement the
> file name looks like "strVariable .doc" It is the
> space that I am trying to remove. The Trim statement is
> being rejected.
>
> Thanks in advance,
>
>>-----Original Message-----
>>Andrew
>>
>>When I get this I find it's that it's something else
>
> that has gone wrong,
>
>>usually another reference to an object or a template
>
> which can't be
>
>>resolved.
>>
>>Sometimes I find it's the Left$() function which
>
> is 'missing' when the
>
>>problem is actually elsewhere.
>>
>>I find it's actually a bogus message in that it's not
>
> the Trim stuff which
>
>>is missing but something else. What does the Reference
>
> list suggest?
>
>>- Malc
>>.
>>
Hi Andrew,
I think what Malc is trying to get you to do is look in the VBE under
Tools > References and this should show you a list of expected
references. If any of them say "Missing" then your problem is there.
Malc is right I think, as this has been my experience in the past also.

HTH

J