Weird problem: Can't find Project or Library

[zhead]

The problem (compile error: can't find project or library), occures when using the Mid or Chr$ functions only -and that's what is weird about it - it doesn't happen when using InStr, for example.

What's even more weird - it may happen on one Windows system and not happen on another, and they both have exactly the same version of vba332.dll (I concluded that this functions are supposed to be called from this DLL).

Any clues will be highly regarded - it drives me crazy for more than a week.

If nothing else, I would be happy to know how can I manipulate a String (like I do it in C for example), so that I can write the Mid function by hand.
Thanx

p.s.
I am using Access97, the vba332.dll was created on 22/04/97

[This message has been edited by zhead (edited 11-06-2000).]

 

[simongallop]

Fully understand the problem as I have worse version of problem in Word (yet to be resolved!) where one file works, the other doesn't (second is copy of first!).

Try using left and right (more cumbersome than Mid) to extract the data that you want

 

[zhead]

Thanks Simon - I'll try that,

Did you look into the vba related dlls? (msvbvm60.dll, vba332.dll...) - There's something strange in the Strings module that might have connection to my problem:
InStr is declared like this: [RetType] _stdcall InStr([parameters types...)
But all of other functions (including Mid and Chr$) are declared like this: [RetType] _stdcall _B_str_Chr$(para...)
followed by
[RetType] _stdcall _B_var_Chr$(para...)

Do you understand this? (I was trying to explicitly declare them in a global module, to prevent misunderstadings but couldn't, then I explored the inside of the DLL and saw this...)

Thanx again

 

[Former]

I have incountered a similiar problem, where a dll I was referencing was working fine, and then suddenly stopped.

The solution I found was to create a brand new database and import all the tables, queries, forms... etc.

I hope this helps.

 

[chrismcbride]

I don't know if this will help you but I had a somewhat similar problem with simple VBA functions not working on one machine, but not others. Turned out that the one maching has a reference to a missing library. At first I ignored it because it was a reference to a type library that I had only used temporarily as a test. Once I removed the reference to the missing type library, all was well.
Chris

 

[lucyszynk]

The most common reason for these problems is the references.

Open a module window or the Visual Basic Editor, select tools, references, if there is anything in there that says MISSING, uncheck it and try again.