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