Chr(ascii_number) function not working in Access 2010.

[jsbotts]

The following code worked in Access 2007 but in recent install of 2010 there is a compile error which highlights the Chr(34) function.

Dim path As String
Dim dir As String
Dim wdpath As String
dir = MFunctions.ReadFile("CL_FileDir.txt")


path = "C:\" & dir & "\" & fn & ".docx"

wdpath = "WinWord.exe" & " " & Chr(34) & path & Chr(34)
Shell wdpath, vbNormalFocus

I have not been able to find a solution.

[rzw0wr]

I had this problem.
You need a LF and CR.

I was told to use vbCRLF and it worked great.

It is a Chr(13) and a Chr(10).

Found under Miscellaneous Constants in VBA help.

Dale

[jsbotts]

I had this problem.
You need a LF and CR.

I was told to use vbCRLF and it worked great.

It is a Chr(13) and a Chr(10).

Found under Miscellaneous Constants in VBA help.

Dale

Instead of Chr(34) I used quotation marks and no longer get the compile error.

[rzw0wr]

Glad you got it working.

Dale

[pbaldy]

FYI, Chr(34) works fine in 2010, just tested. You might check references, as that can cause this type of issue:

Access Reference Problems

vbCrLf (or Chr(13) & Chr(10)) would do something completely different, so not appropriate here.

[rzw0wr]

Thanks again Paul.
You are doing a great job of keeping things straight.
I did not read the post correctly or completely.

Dale