Hi Jamie,
I understand that part--but do you want to always open the same file every time? I'm assuming from your last post that this is the case--but if not the answer might be different.
If you are going to open the same file each time, simply do what Isadore said in the post on Feb 4--copy and paste the code provided and apply that to the OnClick event of your button. Then simply substitute you application path and name and the target file's path and name in place of those Isadore used. This would not be what I'd call a hyperlink, per se--but would accomplish the same thing in an efficient manner.
If you need to choose a file before clicking the button, let me know and I can provide that code--again, I don't want to go to the trouble of pulling together all that info for you if you don't need it (you won't if you want to open the same file each time--again, use Isadore's method in your OnClick event for the button).
Your original post regarding the hyperlink is what caught my attention: it is worded in such a way that I read it as though you wanted to be able to choose a file from a dialog and convert the chosen path/file into a hyperlink via VBA, writing it to the record. I have a good way of doing this--but it doesn't sound like that's what you are looking to do.
I'm not trying to be vague or elusive with a response--I was just not 100% sure about what you are looking for--and am still not since you have not been able to apply Isadore's method as I cannot imagine why that would not work.
Please let me know if this has helped.
Keith