Linked files in forms

[YL]

Hello all,

What is the best way to link files to a form? These would be files that sit
on a network server so all users using the database would have access to
them, be they Word docs, Adobe PDFs, Outlook email texts, XLS, etc.

Is it best to create a hyperlink? Or script with:
Private Sub File_Click()
Application.FollowHyperlink Me.Doc
End Sub

Can you recommend resources on where to read up on creating the latter
solution, the script?

Thanks so much!!

 

[Arvin Meyer]

You can use a hyperlink, but it requires more bytes than using the
Application.FollowHyperlink method. The code you have is basically all you
need. You can also use ShellExecute:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access