"Shell"ing to Adobe update question

[Stinky Pete]

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 ;-)

[Vayse]

Two things that I see:
strAcrobatPath = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe" &
strFilePath
The value in strFilePath has not been set yet. Though in your shell command
you are adding strFilePath again, so I guess this line should be:
strAcrobatPath = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe"

strFilePath = "Me.[NCF form pdf].Value"
There should not be quotes here. Assuming NCF Form pdf if the name of your
text box, it should be
strFilePath = Me.[NCF form pdf].Value

Hope this helps
Vayse
"Stinky Pete" <Pe**********@symbionhealth.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

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 ;-)