right$ mid$ library ????

Hello just a simple question...
what library do i need to run these functions. it seems my visual basic doesn't have it..

asc(x) ascii(x)
chr$(x) char(x)
lcase$(x) lower(x)
len(x) datalength(x)
ltrim$( x) ltrim(x)
mid$(x,y,z) substring(x,y,z)
right$(x,y) right(x,y)
rtrim$(x) rtrim(x)
space$( x) space(x)
str$(x) str(x)
ucase$( x) upper(x) ....
...
......

Thanks....

It's VBA.Strings. The IDE automatically references it.

It's VBA.Strings. The IDE automatically references it.

Hey that's strange because my VB doesn't understand them.. When VB call that function VB says to me "Compilation Error...Can't find the project or the library"...... What can I do?... ??.....

Thanks....

So after the error are you redirected to the References Dialog Box? Do you see a reported "Missing" refernce over there? Cause then you really have a problem.
What VB version are you using?

So after the error are you redirected to the References Dialog Box? Do you see a reported "Missing" refernce over there? Cause then you really have a problem.
What VB version are you using?

I have 6.0.. with sp5...... it only gives me that error and take me to the line (in yellow)... where the function is.....

thanks....

Go to Project Properties -> References and see if you have any references there marked missing. That is usually the cause.

Go to Project Properties -> References and see if you have any references there marked missing. That is usually the cause.

Yep, there is one missing, Thanks!!!!..... i'll look for it in google...

Hey can't find it... the name is

"Microsoft Connection Designer Instance"...

WHERE COULD I FIND THIS ONE????

thanks....