Hi,
I have a double click event that open a pdf file, stored in a field
name "NOMEDOC". The routine work fine but if the data of the name of
the file contain space doesn't work. Does anyone can help.
ex. if the NOMEDOC is "30305gb.pdf" the command run ok
but if the NOMEDOC is "5-50-0-01 dry heating.pdf"
mention that there is space between the characters.
Thanks,
Sotiris
sample code.
Private Sub NOMEDOC_DblClick(Cancel As Integer)
Dim RetVal
Dim Filename As String
Filename = "G:\Booklet\KM-cds\Electrolux\2010\ELECTROLUX\PDF\All\" & Me![NOMEDOC]
RetVal = Shell("C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe " & Filename, 1)
End Sub
I have a double click event that open a pdf file, stored in a field
name "NOMEDOC". The routine work fine but if the data of the name of
the file contain space doesn't work. Does anyone can help.
ex. if the NOMEDOC is "30305gb.pdf" the command run ok
but if the NOMEDOC is "5-50-0-01 dry heating.pdf"
mention that there is space between the characters.
Thanks,
Sotiris
sample code.
Private Sub NOMEDOC_DblClick(Cancel As Integer)
Dim RetVal
Dim Filename As String
Filename = "G:\Booklet\KM-cds\Electrolux\2010\ELECTROLUX\PDF\All\" & Me![NOMEDOC]
RetVal = Shell("C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe " & Filename, 1)
End Sub