By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Creating Hyperlinks/URL on forms and reports

P: 4
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
Dec 12 '07 #1
Share this Question
Share on Google+
9 Replies


Dököll
Expert 100+
P: 2,364
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!
Dec 13 '07 #2

P: 4
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 ?
Dec 13 '07 #3

NeoPa
Expert Mod 15k+
P: 31,656
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
Dec 13 '07 #4

P: 4
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.
Dec 13 '07 #5

NeoPa
Expert Mod 15k+
P: 31,656
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.
Dec 13 '07 #6

puppydogbuddy
Expert 100+
P: 1,923
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
Dec 13 '07 #7

NeoPa
Expert Mod 15k+
P: 31,656
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.
Dec 13 '07 #8

P: 4
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
Dec 13 '07 #9

NeoPa
Expert Mod 15k+
P: 31,656
That's certainly the MAIN reason we're here ;) To help.
Glad that got you going Ursie :)
Dec 14 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.