Compile issue

[Dan @BCBS]

When I try to Compile I get the "Compile Error - Cannot find project or
library"
The error highlighted is at "TRIM" in this string:
If Len(Trim(Nz(stReviewerList, ""))) > 0 Then....

I thought it may be a reference issue but the references are the same on
another PC where this application runs/compiles fine?

Suggestions???

 

[Stefan Hoffmann]

hi Dan,

When I try to Compile I get the "Compile Error - Cannot find project or
library"
The error highlighted is at "TRIM" in this string:
If Len(Trim(Nz(stReviewerList, ""))) > 0 Then....

I thought it may be a reference issue but the references are the same on
another PC where this application runs/compiles fine?

Suggestions???

Have you checked the references? Try a decompile.



mfG
--> stefan <--

 

[Dan @BCBS]

Yes, as I mentioned my first thought was the references, but they are the
same as another PC that runs this application fine. I even picked a few new
references to try and wake up the references but it had no effect.

Never ran a "De-Compile" before how is that performed and what should that
result in for this issue???

Thanks

 

[Stefan Hoffmann]

hi Dan,

Never ran a "De-Compile" before how is that performed and what should that
result in for this issue???

Maybe your byte-code is corrupted. Run the following on the command line:

"C:\Path\To\MSACCESS.EXE" "X:\Path\To\Database.mdb" /decompile


mfG
--> stefan <--

 

[Marshall Barton]

When I try to Compile I get the "Compile Error - Cannot find project or
library"
The error highlighted is at "TRIM" in this string:
If Len(Trim(Nz(stReviewerList, ""))) > 0 Then....

I thought it may be a reference issue but the references are the same on
another PC where this application runs/compiles fine?

The references you set in your app will always be the same
regardless of where you install it. The things that are
different are the files, their versions and their paths on
the other machines. This is referred to as "DLL Hell" and
can drive you nuts trying to synchronize the libraries on
all machines, especially when installing some other,
unrelated product might replace/update one of your
libraries. Some things you can do are, first, never
reference a library if there is any way to avoid it. Other
things are to make sure all of your users have the same
version of Access and, if you can not guarantee they all
have the same service packs, by recompiling your code on
each machine. For essential, non Access libraries, use late
binding.