Help with Hyperlinks (1 Viewer)

[k14k21]

I have a table with 2 fields, briefing name and briefing location (hyperlink). I have created a form with a combo box for the briefing name. Once I select the briefing name, I want a command button to open up the file. I have created the command button but am lost after that. I just started learning access on my own and have not vba experience. Any assistance is appreciated.

 

[pbaldy]

Check out FollowHyperlink.

 

[arnelgp]

if Briefing Location is also included on your combo as 2nd Column,
on the click event of the button:

Application.FollowHyperlink Me.combo.Column(1)

if it is not included, you need to use Dlookup() to get the Hyperlink:

Application.FollowHyperlink Split(DLookup("[Briefing Location]", "table", "[briefing Name]='" & Me.combo & "'")(1)

 

[neuroman9999]

Check out FollowHyperlink.

I think the macro builder also has that method in it. no coding needed.

 

[pbaldy]

I think the macro builder also has that method in it. no coding needed.

Yes, searching on the term as recommended would reveal both methods.

 

[neuroman9999]

Yes, searching on the term as recommended would reveal both methods.

I'm young. what can I say. wisdom is not my forte. unless I'm instructing Richard.