HI,
I've been trolling through the archives of this list in order to better
understand how to get Access to open Adobe Acrobat and a specific pdf
file. Having never done this before, I've got a tad confused and am
not sure if this code is for A97 or will work with A02. Anyway, I'm
trying to use this code for a command button to open up a specific pdf
file on our intranet. It keeps on getting hung on the Shell line.
Another time it got hung on the fact the path to Adobe was wrong.
Any advice and suggestions are welcome.
Stinky Pete ;-)
Private Sub Full_pdf_form_Click()
Me.axcAcrobat.src = Me![Full pdf form]
Dim strFilePath As String
Dim strAcrobatPath As String
'set the file path for acrobat
strAcrobatPath = "C:\Program
Files\Adobe\Acrobat_7.0\Reader\AcroRd32.exe"
'set the file path for the pdf file (as shown in the textbox name)
strFilePath = "Me.[NCF form pdf].Value"
'open the pdf file
Shell (strAcrobatPath & " " & strFilePath)
End Sub