compile error: on CHR (34)

G

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
 
S

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.
 
B

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
 
S

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top