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