469,902 Members | 1,815 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

Trim function - "Cannot find project or Library" error

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
Aug 21 '07 #1
4 9495
FishVal
2,653 Expert 2GB
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).
Aug 21 '07 #2
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
Aug 21 '07 #3
FishVal
2,653 Expert 2GB
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.
Aug 21 '07 #4
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
Aug 21 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by John J. Hughes II | last post: by
1 post views Thread by jingkun Hu via .NET 247 | last post: by
3 posts views Thread by David T. Ashley | last post: by
2 posts views Thread by mirandacascade | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.