Adam & John
One caveat with using FollowHyperlink is the user is apt to get a warning asking if it is okay to open the file. ShellExecute will not trigger that warning.
Bill
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Adam-
>
> I often use:
>
> Application.FollowHyperLink "H:\JarDrawings\" & stFolder & "\" & Me.BaseJar
> & ".pdf"
>
> That will call whatever program is registered for the file extension.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> ----------------------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of AdamF
> Sent: Thursday, April 12, 2012 11:00 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] When referenced programs are updated
>
>
> I open pdf files by first referencing the Acrobat program. However, when that
> program is upgraded, I have to change to code.
>
> stApp = "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe"
> stFile = "H:\JarDrawings\" & stFolder & "\" & Me.BaseJar & ".pdf"
> Call Shell(stApp & " " & stFile, 4)
>
> Is there a better way to do this to automatically account for upgrades (in this
> case Reder 9.0 to 10.0), of when different users have different versions?
>
> Adam
> Denver, CO
>
Tidak ada komentar:
Posting Komentar