compile error: on CHR (34)

[G]

I get an error messge:
compile error: can't find project or library
whenever it hits CHR(34)
Any ideas what references it is looking for?

For references I have the following:
Visual Basic for applications
Microsoft Access 11.0 object library
Microsoft Scripting runtine
Microsoft Office 11.0 object Library
Microsoft Visual Basic for applications extensibility 5.3
Microsoft DAO 3.6 Object Library

 

[BeWyched]

Hi G

When what hits CHR(34)?

What is the line of coding that throws the error?

BW

 

[Simon T-L]

I expect G has the same problem as me... VBA that run happily under (in my
case, Access 2000) that won't under 2007.

It says "Compile error: Can't find project or Library" - at the point it is
calling chr(10). I have tried to follow the new **** Help system but it makes
no sense in trying to work out via the Object Browser which file needs adding
to the References.

 

[BeWyched]

Hi Simon

If it is a 2007 issue I can't help as I haven't used it yet.

I can't remember if Chr(10) is Carriage Return or Line Feed. Whichever it
is, have you tried replacing it with either vbCr of vbLf (or vbCrLf if you
don't know)?

Similary, G could replace Chr(34) with """" (that's 4 " in a row)

Cheers.

BW

 

[Simon T-L]

Thanks; that fixed this one.

Rather than hijack this thread I'll have to start others for other two
gotchas I have found.