String Function Error

[SmokingCrater]

Forum,

Does anyone know why the String function will not work in Access 2000? (machine is running NT4 Service Pack 4 with Access 2000 no service packs) The code requires to build a string with the " mark in it. (unfortunately, single quotes are not an option here) I am using the String function to insert the necessary quotes in the string. (for more specific: String(1, 34) where 1 signifies one character long, and 34 signifies the ASCII for the quote mark so for this example it returns: &quot I am getting an error "Can't find project or library" whenever that function is used. I thought the String function was native to VBA so I'm not sure why it's exploding. According to Access help files, I should search for msowcf.dll. The machines have this file installed and I can only assume that it is registerd.

Any help would be great. Thanks.

Thanks.

 

[MichaelRed]

Well, I can't help you directly, but a workareound might be to use Chr(34) in place of String(1, 34).

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[SmokingCrater]

MichaelRed,

That's part of the problem. Other functions are missing as well. Including said Chr function. I tried Chr, Chr$, and char (which obviously didn't work). What I am currently using is """". A set of double quotes translates to a single quote. Found that in the help manual and it works ok. Still doesn't solve the problem of why the library is missing, but it's a solution for now.

crater