Chr(34) complie error

[liuec]

I've been using this Chr(34) to replace quotations in my quotes and they've been working well in VBA for excel. Now i've migrated the same code to VBA in Access and it's giving me complie error with this message: Can't find object or library.

Do I have to add any additional reference when using Chr(34)? If so which reference?

thanks a lot!

 

[GinaWhipp]

It would help to see the section of code...

 

[liuec]

It would help to see the section of code...

Thanks I actually found a solution, not sure what caused it but I swapped out chr(34) with """" (4 quotation marks) and it worked.
thanks anyways!

 

[boblarson]

Thanks I actually found a solution, not sure what caused it but I swapped out chr(34) with """" (4 quotation marks) and it worked.
thanks anyways!

That may be the case but there is no good reason that I can think of why the Chr(34) didn't work. So, just going with the other is obscuring a possible problem which should be investigated and fixed. You may have just bypassed a more serious problem which may come back to haunt you.

 

[liuec]

That may be the case but there is no good reason that I can think of why the Chr(34) didn't work. So, just going with the other is obscuring a possible problem which should be investigated and fixed. You may have just bypassed a more serious problem which may come back to haunt you.

I agree, I have checked references in both vba in excel and in access and they carry the same references..... I'll be sure to look into it and report back when I get to the bottom of this.