Need help with PDF active X control

[JBurlison]

I have multiple attachments in PDF format and id like to view them on the form itself.

how do i get the attachments to show up on the active x control?

 

[HiTechCoach]

I will assume that you have already added the Adobe Acrobat viewer OCX control to your form.

If you have named the object ctlAcrobat, then to set the path to a PDF fiel use:

Me.ctlAcrobat.src = "path to PDF"

 

[JBurlison]

But the PDF is an attachment to a table, i dont think that can be pathed?

 

[HiTechCoach]

But the PDF is an attachment to a table, i dont think that can be pathed?

Are you using a new 2007 attachment data type field?

 

[JBurlison]

yes, it seems to only display pictures

 

[jsbarroso]

I am running Access 2007 - On a form I have a text field which contains the path "strFilePath" to where my associated PDF file is located (stored in a shared network drive). I have added Adobe PDF Reader Activex controls “AcroPDF6” to my form. I would like the PDF controller to link and display the file located in the "strFilePath" on each record. I have tried

Private Sub Form_Load()
Me.AcroPDF6.Object.src = [strFilePath]
End Sub

And even entering:

Private Sub Form_Load()
Me.AcroPDF6.Object.src = “\\mo7400svr01\cw_database\PILOT\” &[strFileName]&”ASD”&”.PDF”
End Sub

Both methods generated “Expression Onload errors.

Any recommendations how I can solve this and achieve my procedure?

Much appreciated.:banghead: