Hyperlink or Attachment

[Wayne]

I read a reply to a thread by Doc Man about this. I set up a subform to enter the file path for stored documents relating to a job on the main form (as opposed to an attachments field). Should the field be set up as a hyperlink, and what code would you use to open the file to view it? The files are pdf documents. Any help would be appreciated.

The thread was:

https://access-programmers.co.uk/forums/showthread.php?t=292777&highlight=attachments

 

[arnelgp]

if he field is hyperlink, no code needed to navigate to the link.
if plain text, you use:


FollowHyperLink [fieldname]


it would be better to use it on DoubleClick Event of the control.

 

[Pat Hartman]

The Hyperlink datatype is valid for ACE (.accdb) but it is not upsizable to SQL Server so the FollowHyperlink method suggested by arnelgp is preferable.

 

[Wayne]

Any thoughts on the best place to put that code to follow the hyperlink?

 

[Pat Hartman]

arnelgp already suggested the double click event of the control

 

[Wayne]

Thanks. Worked perfectly.

Wayne