Stuart McLachlan
stuart at lexacorp.com.pg
Wed Aug 8 16:48:47 CDT 2012
First time I've seen that one, but google tells me it it quite common. It is bascially equivalent to: ShellExecute(ShellExecute(Shellexecute())) If you declare ShellExecute somewhere in your application, you can reduce that to a single call with much more contrtol over the actual invocation: Public Declare Function ShellExecute _ Lib "shell32.dll" _ Alias "ShellExecuteA" ( _ ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal lpParameters As String, _ ByVal lpDirectory As String, _ ByVal nShowCmd As Long) _ As Long Then as a minimum: ShellExecute(0, "", Me.txtPicture, "", "",0) -- Stuart On 8 Aug 2012 at 14:13, Rocky Smolin wrote: > 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 >