Hyperlink

[Gmoz]

Hello all,
Just woundering how to take information in a field combine it with a common hyperlink.

Example: the field could be ID# and I want it to hyperlink to WWW.whatever.com/ID#. All that is stored in the field is is the number.

Thanks for any help

 

[Rich1968]

I had the same problem. I store the hyperlink path in my table but I had to run an expression to get there.

Before Update

If (Not IsNull([Debtor ID])) Then Me![Hyperlink] = "\\DbServer\Documents\" + [Debtor ID] + ".tif"

This added it to the hyperlink field, now all I have to do is figure out the best way to access the document

Rich

 

[Gmoz]

Still need help

I have tried several things to make this work but no joy. I am not sure if it is possible but I really need it or at least a work around. I have a database with over 700,00 records. The database has a table with a unique field Registration Number. There is a webpage that displays more information on the number if you go to it. I would like to make the firld a hyperlink to go to the webpage when clicked. The link would be www.Weblink.com/RegNum=XXX. Is there a way to do this? Thanks again for your help.


GMoz

 

[Kevin_S]

GMoz -

What your trying to do is simple enough with the Followyperlink method. Here is an example based on the information you provided:

Put this in the "On_Click" event:

Dim strHyperlink as String

If isNull(RegIDNum) then
msgbox "You must enter a Reg ID first!", vbCritical + vbOkOnly,"No ID Found Error"
Exit Sub
Else
strHyperlink = "www.Weblink.com/RegNum=" & forms!YourFormName!RegIDNum
Application.FollowHyperlink strhyperlink, , True, True
end if

This will do what you want... Also - make sure you change the fields to the names of the fields you use on your form!

HTH,
Kev

 

[Len Boorman]

Follow Hyperlink works fine

An Alternative is to use Hyperlink field and just put in the Hyperlink itself

But But But BEWARE

If doing this with any sort of automation e'g query then add # to each end of the hyperlink.

Why

Cos without it it will not work as a simple click hyperlink. Found it buried in the help somewhere a while ago when I was having a problem. Interestingly when you look at the hyperlink you will not see the #'s either.

Len B

 

[Gmoz]

Thanks guys it works like a charm now.

 

[Kevin_S]

Thanks guys it works like a charm now.

No Prob! Glad to help...

Kev