VBA & Trim function

[chrisjrice]

I have 2 PC's one that has Access and VB6.0 installed on it and the other which just has Access.

I can use the trim function on the PC with VB6 installed, but on the PC with just Access when using VBA, Trim is not recognised. I have looked at the references added for both versions and everything looks the same.

Anyone help?

 

[CALV]

This has happened to me before, when a reference is missing, did you try vba.trim instead of just trim

 

[pdx_man]

Take a look again at the References on the computer that does not have VB installed. I am almost positive that you will see one with a MISSING reference.

 

[chrisjrice]

Thanks to everyone for there help. It was a missing reference. Even though the .dll existed on my PC and the reference was pointing to it, it still did not recognise it. I copied the .dll from another PC and it worked fine.

Many Thanks

Chris