Trim function - "Cannot find project or Library" error

[ramaswamynanda]

Hello All,

I have developed an application using Ms Access 2000. My client has Access 2003. I shipped him the code yesterday and he got an error hile running the application via the mdb file itself. The line of code is

If Trim(EmployeeName) <> "" And Trim(EmployerName) <> "" Then

The "trim" function is highlighted and the msgbox says

Compile error - cant find project or library.

This is the issue I have

1. I cant reproduce this error - so i need to provide a solution that I am sure will work at his side
2. I have sent him a screenshot of the references selected in my VB project references.
3. Is this some issue with the support for trim function in different versions of
Access. I dont want to write some other check condition in place of trim and then get another mail saying that that doesnt work too.

Please help, and thanks in advance
Nanda

[FishVal]

Hello All,

I have developed an application using Ms Access 2000. My client has Access 2003. I shipped him the code yesterday and he got an error hile running the application via the mdb file itself. The line of code is

If Trim(EmployeeName) <> "" And Trim(EmployerName) <> "" Then

The "trim" function is highlighted and the msgbox says

Compile error - cant find project or library.

This is the issue I have

1. I cant reproduce this error - so i need to provide a solution that I am sure will work at his side
2. I have sent him a screenshot of the references selected in my VB project references.
3. Is this some issue with the support for trim function in different versions of
Access. I dont want to write some other check condition in place of trim and then get another mail saying that that doesnt work too.

Please help, and thanks in advance
Nanda

Hi, Nanda.

Check whether there are missing link(s) on customer station. From some reasons string functions fails with this error if there are missing link(s), no matter to what library(ies).

[ramaswamynanda]

Hello Fishval,

Thanks for replying so fast. I understood what u were saying. I must not be thinking straight :) Like i said before, I have sent him a list of references that I have for comparison, and told him where to find any missing DLL's. we are in seperate time zones, and I ill wait for his reply. This is a clipping of what I found when I was searching on the net

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.


Regards
Nanda

[FishVal]

Hello Fishval,

Thanks for replying so fast. I'm sorry I did not understand what you said. Where do I check for missing links? Please bear with me and shed some more light on this issue

Regards
Nanda

On the computer where the db fails. I've experienced the same problems when moving db to computer where some libraries were absent.

[ramaswamynanda]

hi,

we sorted the issue out, i removed each reference one by one, tested the project and then shiiped him the mdb, its running properly now.

thx a lot for your help

nanda