Re: Northwind Employee Form and PDFs
- From: "Ron Weiner" <weinNoSpam1@xxxxxxxxxxxxxx>
- Date: Wed, 4 Jan 2006 19:19:33 -0500
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!
--
Ron W
www.WorksRite.com
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
wrote in message news:e4DYcuYEGHA.1736@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
>
> "WayneS" <WayneS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D82679B1-6CA5-4A6D-A669-D8931BF56E93@xxxxxxxxxxxxxxxx
> > Thanks Ron,
> >
> > I would be happy to display the PDF outside MS Access. I will try this.
> >
> > Thanks again,
> >
> > Wayne
> >
> >
> > "Ron Weiner" wrote:
> >
> >> 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.
> >>
> >> --
> >> Ron W
> >> www.WorksRite.com
> >> "WayneS" <WayneS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:91E63779-6416-473F-8200-A4E6BF8126A5@xxxxxxxxxxxxxxxx
> >> > 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
> >> >
> >> >
> >>
> >>
> >>
>
>
.
- References:
- Re: Northwind Employee Form and PDFs
- From: Ron Weiner
- Re: Northwind Employee Form and PDFs
- From: Stephen Lebans
- Re: Northwind Employee Form and PDFs
- Prev by Date: Re: Northwind Employee Form and PDFs
- Next by Date: Re: Detail Form Scroll After Insert Record
- Previous by thread: Re: Northwind Employee Form and PDFs
- Next by thread: Adding Records by Code
- Index(es):
Relevant Pages
|
