Hyperlinking to Picture

[ZOMB13]

Hi all,

I have a question that I feel may be a simple one, but I just can't remember just how to do it. I currently have database with a table that has a field in which I input a name of an external picture. This field is linked to a form where it displays said picture. In the table I only have to input the name of the picture, not the entire path to the picture. For example I only have to put in the name bob.jpg (not C:\users\bob\databases\pictures\bob.jpg) into the field and it displays it in the form as I have specified elsewhere the folder to locate said picture. How do I do this? I've forgotten how, I would also appreciate if you could explain how to do this without the need to also type the file type extension (as all files will be .jpg).



As a bonus challenge, can I do this so it's a hyperlink on the table so I'm able to click the text "bob" in the picture field on the table and it opens with windows photo viewer?

Thank you so very much in advance.

[apr pillai]

Need to know about Hyperlinks in MS-Access then the following links may be useful to you:

http://www.msaccesstips.com/2009/02/...in-hyperlinks/
http://www.msaccesstips.com/2015/06/...ress-manually/