K
Karen
I used Albert D. Kallal's simple word merge modules and directions to set up
several word merge documents in Access 2003. As I have no programming
skills, I'm thankful that they've worked beautifully in Access 2003 &
continue to do so.
Several persons in my company have received Access 2007. There is an error
that arises when they attempt to use the merges w/ this software. Seemingly,
the error is in the Word Code module. This line is highlighted in the
following section of the coding: If InStr(vText, Chr(34)) > 0 Then
Function qu(vText As Variant) As String
' takes a string and surrounds it with double quotes
' All " (double quotes) are converted to ' (single quotes) before
' this is done
If IsNull(vText) = False Then
If InStr(vText, Chr(34)) > 0 Then
vText = strDReplace(CStr(vText), Chr(34), "'")
End If
End If
qu = Chr$(34) & vText & Chr$(34)
End Function
Keep in mind -- I still have MS2003 on my computer and am able to merge in
the same database. Can anyone advise as to why this is happening in 2007 &
how I can fix it?
several word merge documents in Access 2003. As I have no programming
skills, I'm thankful that they've worked beautifully in Access 2003 &
continue to do so.
Several persons in my company have received Access 2007. There is an error
that arises when they attempt to use the merges w/ this software. Seemingly,
the error is in the Word Code module. This line is highlighted in the
following section of the coding: If InStr(vText, Chr(34)) > 0 Then
Function qu(vText As Variant) As String
' takes a string and surrounds it with double quotes
' All " (double quotes) are converted to ' (single quotes) before
' this is done
If IsNull(vText) = False Then
If InStr(vText, Chr(34)) > 0 Then
vText = strDReplace(CStr(vText), Chr(34), "'")
End If
End If
qu = Chr$(34) & vText & Chr$(34)
End Function
Keep in mind -- I still have MS2003 on my computer and am able to merge in
the same database. Can anyone advise as to why this is happening in 2007 &
how I can fix it?