Viewing PDF's

[Guest]

Does anyone know if it's possible to view PDF files within an Access 2000
environment? We run a bespoke database and wish to view linked PDF's that
are stored on our server within the database window. We keep finding
scanners that would suit our needs for collecting the images but nearly all
of them save PDF's only and currently we cannot then open them from the
application. It would be appreciated if anyone out there could try and point
us in the right direction please. We have a developer who will work with us
to integrate any software, patches etc to facilitate the above.

 

[Guest]

Try
Application.FollowHperLink "FileName and Path"

If you want to open it from a form, create a text box that display the file
name and path, and then using a button open the PDF file using

Application.FollowHyperlink Me.[Text Box Name]

 

[Guest]

Dear Ofer

Thank you for your reply. I spoke to our developer who said he can display
a PDF file in an Unbound Object box, but he needs to try and get it to
display in an Image Box Control so that we can manipulate the image. What we
do is display a chosen image and over-print data from within Access with
details of the account it relates to. He is trying different ways of coding
it to work, but has had no success as yet. When he tried using the Image Box
control there was an error message that said, "OLE Server not registered." I
don't know if this is a problem that anyone out there has experienced. Most
developers don't seem to try and get quite so much out of Access.

Try
Application.FollowHperLink "FileName and Path"

If you want to open it from a form, create a text box that display the file
name and path, and then using a button open the PDF file using

Application.FollowHyperlink Me.[Text Box Name]


--
Good Luck
BS"D

Does anyone know if it's possible to view PDF files within an Access 2000
environment? We run a bespoke database and wish to view linked PDF's that
are stored on our server within the database window. We keep finding
scanners that would suit our needs for collecting the images but nearly all
of them save PDF's only and currently we cannot then open them from the
application. It would be appreciated if anyone out there could try and point
us in the right direction please. We have a developer who will work with us
to integrate any software, patches etc to facilitate the above.

 

[Guest]

If you want to display pdf files, you can use the Acrobat reader ActiveX
control.
I've tried to build a form from a table with just two fileds: an ID field
and a text field named FilePath. Then I've coded two events: Form_Current()
and FilePath_AfterUpdate():

==================================
Private Sub Form_Current()
If Len(Form_Table1.FilePath.Value) > 0 Then
Form_Table1.AcroPDF8.LoadFile (Form_Table1.FilePath.Value)
Form_Table1.AcroPDF8.Visible = True
Else
Form_Table1.AcroPDF8.Visible = False
End If
End Sub

Private Sub FilePath_AfterUpdate()
If Len(Form_Table1.FilePath.Value) > 0 Then
Form_Table1.AcroPDF8.LoadFile (Form_Table1.FilePath.Value)
Form_Table1.AcroPDF8.Visible = True
Else
Form_Table1.AcroPDF8.Visible = False
End If
End Sub
=====================================

As you can see, code is the same and I don't check for the existence of the
file, but you can easily do it by yourself.

So when you change record or you change the filepath field , the pdf viewer
is updated, or hided if the filePath is empty.

If you want to manipulate the pdf, then you shuold search the web for
third-party pdf software.

In any case I'd suggest further investigation in the new XPS format, much
easer to deal with.

Hope this can help.
Nicolò Carandini