Re: Need help referening PDF object from MS Access

Article View: adobe.reader

Article #10598

#10598

From: chicks
Date: Wed, 20 Dec 2006 20:08

18 lines
1314 bytes

Again, look at the VBA example in the Comments section of the site I referenced. You can't just insert the object, you need to instantiate it manually. Something like this:

Private ctlPDF As acroPDF

Set ctlPDF = Controls.Add("AcroPDF.PDF.1")
    With ctlPDF

.Move 20, 10, UserForm1.Width - 40, UserForm1.Height - 100
        .src = "e:\temp\IACReference.pdf"
        .gotoFirstPage
        .setPageMode "none"
        .setShowScrollbars False
        .setShowToolbar False
        .setView "fitH"

End With

IIRC, you may need to set a reference to the acroPDF object first.

Technical Details

Message-ID: <3bc2a108.2@webcrossing.la2eafNXanI>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeed.freenet.de!news.buerger.net!open-news-network.org!news.isoc.lu!webcrossing

References: <3bc2a108.-1@webcrossing.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10273d,f791eaef3ede2b60
X-Google-Attributes: gid10273d,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: chicks@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeed.freenet.de!news.buerger.net!open-news-network.org!news.isoc.lu!webcrossing
Newsgroups: adobe.reader
Subject: Re: Need help referening PDF object from MS Access
Message-ID: <3bc2a108.2@webcrossing.la2eafNXanI>
Date: Wed, 20 Dec 2006 12:08:08 -0800
References: <3bc2a108.-1@webcrossing.la2eafNXanI>
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message