I need to view pdf files in an access form image or activex control

[trevor40]

Hi,
I'm trying to create a form that has a list box with locations to files to view.
so far i have created the form and it all works ok if i only try to view JPG viles.


they show up and change as required depending on the list selection.
What I need to do is view PDF type files as well.
Can this be done?
[form code below]

Private Sub Form_Current()
Forms![consignment note tracking - incoming history]!Text24.Requery
End Sub
Private Sub Text24_Click()
Forms![consignment note tracking - incoming history]!Image27.Picture = Me.Text24
End Sub

this changes the list for each record and displays in an image frame.

how do i associate a PDF type to this, i have added the acrobat access 3.0 type library but i'm not sure how to access it properly.
please help.

[June7]

Not sure Access 2003 can show pdf files. The fact code is working for jpg but not for pdf does indicate that. This is easy in Access 2007 - don't even need VBA.

[ItsMe]

I believe I have got an OLE object to preview PDF files before in Access 2003 but never tried to have it show both JPG and PDF dynamically. Have you tried getting an OLE object dedicated to PDF files to work?

[trevor40]

thanks for the advice, i have decided to just provide a link to the original program and load that,
works for pdf but not picture files, it opens vueprint without the file eg - jpg, bmp. i'll try a different viewer ans see if that works.
vueprint has command line options and i've tried them all.

[code now]
If Right(Me.Text24, 3) = "pdf" Then
stAppName = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " & Me.Text24
Call Shell(stAppName, 1)
Else
stAppName = "C:\Program Files\VuePrint\vueprint.exe -" & Me.Text24
Call Shell(stAppName, 1)
End If

[amrut]

Try with web browser control -

Sub ShowFileOnForm(strPath as String)
Me.WebBrowser1.Navigate strPath
End Sub

[ItsMe]

thanks for the advice....

That seems as though it should work. I guess another app like picture viewer or something should open the picture files.