Open pdf file

sotiris

Registered User.
Local time
Today, 11:32
Joined
Nov 9, 2006
Messages
22
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
 
Filename= chr(34) & filename & chr(34)
 
OK, it works!!
 

Users who are viewing this thread

Back
Top Bottom