<div>
Tested in Access 2007 on Windows 7<br />
OM Gang<br />
<br />
Public Function TestShell()<br />
On Error GoTo Err_TestShell<br />
<br />
&nbsp; &nbsp; Dim varReturn<br />
<br />
&nbsp; &nbsp; varReturn = Shell(&quot;c:\Windows\system32<wbr />\mspaint.e<wbr />xe f:\temp\outlookfind1.jpg&quot;,<wbr /> vbNormalFocus)<br />
<br />
Exit_TestShell:<br />
&nbsp; &nbsp; Exit Function<br />
<br />
Err_TestShell:<br />
&nbsp; &nbsp; MsgBox Err.Number &amp;&nbsp;&quot; (&quot; &amp;&nbsp;Err.Description &amp;&nbsp;&quot;) in procedure TestShell of Module Module3&quot;<br />
&nbsp; &nbsp; Resume Exit_TestShell<br />
&nbsp; &nbsp; <br />
End Function
</div>


Tested in Access 2007 on Windows 7
OM Gang

Public Function TestShell()
On Error GoTo Err_TestShell

    Dim varReturn

    varReturn = Shell("c:\Windows\system32\mspaint.exe f:\temp\outlookfind1.jpg", vbNormalFocus)

Exit_TestShell:
    Exit Function

Err_TestShell:
    MsgBox Err.Number & " (" & Err.Description & ") in procedure TestShell of Module Module3"
    Resume Exit_TestShell
   
End Function

<div>
Does anything need to change in the hyperlink?
</div>


Does anything need to change in the hyperlink?

<div>
It may help to post the current code/macro/event procedure for how the hyperlinks are being opened now.<br />
OM Gang
</div>


It may help to post the current code/macro/event procedure for how the hyperlinks are being opened now.
OM Gang

<div>
The App currently uses the functionality available when a field type of Hyperlink is used.
</div>


The App currently uses the functionality available when a field type of Hyperlink is used.

<div>
So what value is stored in the field? &nbsp;Just the file name or a UNC path as in my example?<br />
OM Gang
</div>


So what value is stored in the field?  Just the file name or a UNC path as in my example?
OM Gang

<div>
It is the UNC path, so I will try the above Function.
</div>


It is the UNC path, so I will try the above Function.

<div>
<div class="content wysiwyg-content">
We have an Access Application where we are saving hyperlinks to documents. &nbsp;For tif, jpg, etc documents, the hyperlinks are opening up to a viewer. &nbsp;We would like to have these files open up in MS Paint.<br />
<br />
Is there a way to code this into the application?
</div>
</div>


We have an Access Application where we are saving hyperlinks to documents.  For tif, jpg, etc documents, the hyperlinks are opening up to a viewer.  We would like to have these files open up in MS Paint.

Is there a way to code this into the application?

Launching Hyperlinks from Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.