Running a Hyperlink On a Form Button Click

[Hothmire]

Good afternoon I am new to being a programmer and i am trying to make a button on an MS Access form that will navagate to a table that has a hyperlink in one of its records. I want to navagate to that record and then run the hyperlink. Is this possible? thank you in advance for your time.

[NeoPa]

It's sort of possible, depending on what you actually mean. As a new developer your use of the terminology is understandable, but it's still difficult to work with unless you make that extra effort towards clarity.

Certainly I have a form that allows both of :

1. Clicking on a hyperlink value and linking to the address.
2. Creating a hyperlink from selected text and then linking to that address.

These are different operations, as one is inbuilt into Access while the other involves some programming.

If you can be clearer about what you're asking, we can try to be more specific in our help.

[Hothmire]

Good afternoon NeoPa,

Sorry about that. I have a form button made that navagates to a table. In that table is my hyperlink that is already connected to a PDF Document. No big deal correct? Instead of clicking the button then selecting the hyperlink. I want to create a code that searches for the hyperlink in the record and the runs the hyperlink to bring up the PDF Documnet. I understand a little about ME.CONTROL = RS ![VALUE]. Hopefully, using this I want the button to select that hyperlink value then run it. Does that make more sense?

[NeoPa]

Not much I'm afraid. Too many steps in the explanation are air-ware. I'm left guessing what it is you're assuming I know (even though they've never been exlained).

What do you mean by navigating to a table? If there is a form involved then trying to explain without this critical information is not going to work. If there is not then I have little idea what you mean at all.

Searching for a hyperlink in a table is so unclear as to be all but meaningless. Are you searching for a record? A field? Some text within a field? As I say, you need to remember that I don't know anything about your situation unless you tell me. I can make guesses, but I'm already making loads of those from a distance as I know nothing of your database or Access environment. Having to make more guesses as to the information you should be sharing becomes so lacking in any reliable information that even were it possible it would be so unreliable as to be worthless.

Please try to explain what you're after more clearly. This doesn't mean repeating your last tries with a couple of words moved around, but considering what I need to know from a position ??? miles away from you and your computer and only what you post to work with. Then, and only then, explaining it in such a way that makes sense.