Creating Hyperlinks/URL on forms and reports

[Ursie]

I tried to find this answer on the web but couldn't find a satisfying answer.

I want to create a clickable URL on a Form or Report. This URL must be generated from info extracted from a table.

Is this possible and if so how ?

Thnx for the help in advance

[Dököll]

I tried to find this answer on the web but couldn't find a satisfying answer.

I want to create a clickable URL on a Form or Report. This URL must be generated from info extracted from a table.

Is this possible and if so how ?

Thnx for the help in advance

Could you go a little more into it, Ursie?

Are you hoping to load a Web browser on a report? If so an example was previously posted here quite recently. Fetch a little in the pages.

If not can you tell us what you mean by URL, you can hyperlink to a webpage from your form or report that be the case.

In a bit!

[Ursie]

What i mean is. If a field in my table which lists a number.

This number should be inserted into a URL.

For example I have a value in my table like 53278.

And my url should be something like http://my.website.cool/questionform?q=53278

So this needs to be on a Form or on a report which is clickable so that a "Internet Browser" is opened.

I have already understood that the clickable portion is not possible on a report but is the above action possible on a form ?

[NeoPa]

I suspect this should be fairly straightforward, but when I create a hyperlinked TextBox it doesn't seem to hyperlink :S
A TextBox certainly has an "Is Hyperlink" property.
Creating a correctly formatted hyperlink in the TextBox is also easy enough.
In my database (Access 2000) though, clicking on the nice blue underlined link doesn't open up the web browser at all :S

[Ursie]

Thats what I mean. What i have doen now is in the "On Click" event of the text box I wrot a little code with the FollowHyperlink method. But this is not a nice thing to do for such a normal request of functionality.

Will search further though there must be a solution for this.

[NeoPa]

Indeed.
I'll try to channel some more experts' interest this way and see if any of them have any comments on this. I think it might prove interesting.

[puppydogbuddy]

Indeed.
I'll try to channel some more experts' interest this way and see if any of them have any comments on this. I think it might prove interesting.

Adrian,
I don't have time to test right now, but here is the ms reference source:

http://msdn.microsoft.com/archive/de...plications.asp

[NeoPa]

Thanks pDog :)
It seems to be saying that TextBoxes can only have BOUND links (to hypertext fields), but a link CAN be used in a Label control.
I tested the Label and that certainly works.

[Ursie]

Okay superb that was yhe info I was searching for. Blah I am grumpy that I didn't find that but on the other hand you halped me with it and thats cool on the other side :-D

Thnx you will implement it asap

[NeoPa]

That's certainly the MAIN reason we're here ;) To help.
Glad that got you going Ursie :)