compile error: on CHR (34)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Thanks; that fixed this one.

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