[AccessD] Open PDF File from Access Application atSpecificPercentage

Rocky Smolin rockysmolin at bchacc.com
Wed Aug 8 16:20:29 CDT 2012


If you don't mind cribbing a little code:

http://www.myengineeringworld.net/2012/07/vba-macro-to-open-pdf-file.html 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, August 08, 2012 2:13 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Open PDF File from Access Application
atSpecificPercentage

I use  Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL " & Me.txtPicture,
vbMaximizedFocus

Where me.txtPicture contains a file that is opened with the application with
which the extension is associated. If .pdf it opens in Reader.  

I use:

    DoCmd.SelectObject acReport, stDocName
    Reports(stDocName).ZoomControl = gintPreviewZoomPerCent

to open a report to a preselected magnification but don't think that would
work with Shell.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, August 08, 2012 1:53 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Open PDF File from Access Application at
SpecificPercentage

All,

Is there a way to open a PDF file (Adobe Acrobat) from Access VBA code and
specify what percentage the PDF file will be opened at?

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list