What is the EASY-SIMPLE way to create simple text with unchanging hyperlink on a FORM?

[StGermain]

What is the EASY-SIMPLE way to create fixed text with an unchanging (always the same URL) hyperlink on an Access FORM?



Nothing fancy, no tricky code, no modules (blah, blah). Just a simple "CLICK HERE" text . . . with hyperlink that when clicked will open browser and goes to the SAME specific web page (does NOT change).

I just want to have an easy way to go to this specific web page on my form by manually clicking on it.

Thanks.

[orange]

Application.Followhyperlink


Dim myURL as string
myUrl ="http://therequiredConsistentUrl"

On button Click Event

Application.Followhyperlink myURL

[StGermain]

Thanks for your reply.

However, I am a beginner with Access.

Your instructions are 100% cryptic to me . . . I don't understand them at all.

I am not an expert like you.

[orange]

What exactly do you know about a Form?

Do you understand:
You have an Access form within an Access database.
Open the form in design view.
Put a button on the form

[StGermain]

Yes, those 3 items I understand.

Everything else you've written is above my head. You are the expert level, I am at the other end of the spectrum.

Suggestion:

If you have time, would you please just paste the correct code or whatever here . . . and tell me where to put it?

If not, I understand you are surely busy as the moderator.

If that's the situation, I'll just wait until someone "less busy" has the time to reply.

Sorry to take your time.

[Micron]

I know of no way to have alt text and a url without code as you have requested. Format the table field to hyperlink and be content with seeing HTTPS:... in your form textbox or accept that you will need some code. In the latter case, you can show whatever text you want and use a control event (double click on textbox, click button, etc) to run the code. That code will have to be "told" what the url is because it's obviously not going to be "click here". Without some knowledge of what's on your form it's hard to be specific. You could also read up on FollowHyperlink method.
https://docs.microsoft.com/en-us/off...ollowhyperlink

[StGermain]

Thanks for your reply.

But I need to ask you to please clarify the steps:

(a) Format the table field - QUESTION - what TYPE of field should I create? (label, text box, etc. etc). Be specfic.

(b) Format to hyperlink -- QUESTION - How do I do that? Be specific.

(c) be content with seeing HTTPS -- ANSWER - completely fine with me.

(d) use a control event (double click on textbox, click button, etc) to run the code - QUESTION - How do I do that?

(e) You could also read up on FollowHyperlink method. - ANSWER - I read it 3 times. Still do not understand what to do.

[Micron]

You need to do some of your own research - use keywords and phrases to google and read the tons of results, or get a book. These are basic topics and if you don't know that a label isn't a field then you're not at the point of requiring assistance, you're at the point of basic learning or having someone do it all for you. That's not what this forum is designed for IMO. If you need someone to build something for you, that is possible but you need to be prepared to pay for that help. We all "assist" in one way or another but we don't get paid for it so there is a limit. That being said, it would not surprise me if someone will come along and walk you through this if you're prepared to wait and see what happens.

[StGermain]

"read tons of results" . . . or "get a book"?

Micron, do me a favor . . . don't reply to any of my posts.

Your attitude is (lack of a better word) . . . juvenile and repulsive.

Seriously.

I've received GREAT help from several other members thus far . . . . to them I repeat my thanks.

From YOU, Micron, quite the opposite.

So just don't reply to me.

Sound like a wise strategy to avoid more of this?

[orange]

StGermain,

With all respect, Micron is experienced with database and Access and has responded to many posters. He has suggested that you do some research on your own to help gain knowledge to assist you with the issue you have. I think you may have misunderstood his response and/or the intent o this forum. We are all volunteers helping others when/where possible with suggestions/advice/sample code or logic.
There are excellent youtube videos and written articles available on the internet.

You have given readers little to go on with respect to your environment, your skills, your requirement, a sample to put your issue into context..

You mentioned a form (and I provided a link to a youtube video on creating a Form). I also provided a link to info on Application.FollowHyperlink. I don't know if you reviewed the materials or not.
You also mention a table, but what table??

Describe in plain English what it is that you are trying to solve with Access and a form and a constant hyperlink address so we have some context to help with a focused response.

[StGermain]

Thanks for your cordial and patient reply Orange

I appreciate your time.

I will close my accessforums.net account.

Best wishes and good luck to you.

[Micron]

Micron, do me a favor . . . don't reply to any of my posts.

Your attitude is (lack of a better word) . . . juvenile and repulsive.

Seriously.

I try to help, not do everything for everybody. That is in spite of the fact that I try to stay occupied while my brother lies struggling in a Covid ward on a ventilator. I just got word that he won't last this day. So you will be on my ignore list 20 seconds after I post this.
EDITED - No point in 2 of us being a jerk, but I'm sure OP got my real drift thanks to email.

[accesstos]

Oh, Micron,
I wish all the best for your brother!...