"Shell"ing to Adobe update question

Hi,

With thanx to the group and suggestions to review other news sites,
I've got some code that allows me to open Adobe from Access. As I am
new at this, I still need some help though. The code to get Abobe to
open is working really well, however the referenced file I need is not
being opened. I've tried the path that I've got in the text box via
the cmd prompt and copying the path in Windows Exp and the path does
work. Any suggestions as to why the actual file is not being opened
would be appreciated.

The code I've got to work so far is ....

Private Sub Full_pdf_form_Click()

Dim strFilePath As String
Dim strAcrobatPath As String

'set the file path for acrobat (please double check this)
strAcrobatPath = "C:\Program Files\Adobe\Acrobat
7.0\Reader\AcroRd32.exe" & strFilePath
'set the file path for the pdf file (as shown in the textbox name)
strFilePath = "Me.[NCF form pdf].Value" <== this bit's not
working though ;-)

'open the pdf file
Shell (strAcrobatPath & " " & strFilePath)

End Sub

Thanx in advance,
Stinky Pete ;-)

.

Relevant Pages

  • Re: "Shell"ing to Adobe update question
    ... The value in strFilePath has not been set yet. ... Dim strAcrobatPath As String ... 'set the file path for the pdf file ...
    (comp.databases.ms-access)
  • Re: Open a file - Mac
    ... > program registered to open PDF file). ... > MRJUtils.jar, I can register new file to programs, though I didn't test ... If the string you have to open is a regular URL (be it http, ... use the Java File class call toURIto create a "file:" URI from it. ...
    (comp.lang.java.programmer)
  • Re: PDF button
    ... If you cannot currently create a pdf file manually, you need to go to this ... Dim PSFileName As String, PDFFileName As String ... Dim wb As Workbook, iprinter As String, ws As Worksheet ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Set path/reportname when outputing
    ... Adobe Distiller has no exposed method to allow you to output a PDF file to a ... > output is to my desktop when the "Acrobat Distiller" is ... > Dim strFile_ps As String, strFile_pdf As String, Path As ... > Dim objPrinter As String ...
    (microsoft.public.access.reports)
  • RE: Relative Value Macros
    ... names already put in a column in one workbook, ... Dim strFilePath As String ... Public Function FileNameFromPath(ByVal strPath As String) As String ...
    (microsoft.public.excel.programming)
Loading