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

Post by G
compile error: can't find project or library
whenever it hits CHR(34)
Any ideas what references it is looking for?
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
--
Thank you in advance for your assistance. It is greatly appreciated.

[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

Post by 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.

[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. ;)