Northwind Employee Form and PDFs

[Guest]

MS Access 2003

Can I display a set of PDF files instead of bitmap files in the Northwind
Employee form?

Here is what I have so far.

I modified the getFileName routine to add pdf files to the list that is
displayed. I added this line to getFileName: .Filters.Add "PDFs", "*.pdf"
This appears to work as the names of the pdf files are displayed in my
‘Select Report’ window.

The Control Source of the Text Box named ‘ImagePath’ is ‘PDFImage’.
PDFImage is a field in my table that corresponds to the ‘Photo’ field in
Northwind. The field contains the path and name of the pdf file I want to
display.

I referenced the Microsoft Office 11.0 Object Library.

No errors are thrown but the PDF file is not displayed in my image object
named ‘ImageFrame’.

Thanks,
Wayne

 

[TC]

I doubt that you can natively display a PDF file, in an Image control.

Try Stephen Lebans' site http://www.lebans.com I remember that he
recently added something to do with PDF files.

HTH,
TC

 

[Ron Weiner]

PDF files internally are not anything like most bitmap files, and so
therefore you will not be able to use an Access image control to display
them. In a previous project I was able to display a PDF inside Access
directly on a form, BUT my solution required that a FULL version of Adobe
PDF (not just the free reader) be installed on the machine. If this hurdle
is not to high I would be happy to share the technique and the code I used.

Most people are happy to be able to display the PDF OUTSIDE of the Access
application. This is usually accomplished using either the ShellExecute API
or Access FollowHyperlink.

 

[Guest]

Thanks Ron,

I would be happy to display the PDF outside MS Access. I will try this.

Thanks again,

Wayne

 

[Stephen Lebans]

I think you could insert the MS Browser control and display the PDF's within
the control providing you can currently view PDF docs within Internet
Explorer.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Ron Weiner]

Geeze leave it to you to come up with a 5 minute solution that probably took
me more than 6 hours of research and Acrobat automation programming /
debuging to get working.

The nice thing with this solution is that the user need only have the
Acrobat Reader and Internet Explorer installed. A full copy of Acrobat is
not required!