UtterAccess Discussion Forums > 2nd Hyperlink Issue...

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

sredworb

May 29 2009, 03:00 AM

Hello,

What I am trying to figure out is a way to say Paste (copy and paste), a web address into a control box and when it is displayed it displays a single word that basically is the hyperlink.

eg...

copy and paste; http://www.utteraccess.com
displayed as Utter Access

I have alot of hyperlinks to add and I am trying to find a faster way than adding #Text then Hyperlink...

Is there a way I can put the Utter Access as the default display and then add the hyperlink?

Another example is this...email address..

copy and paste..jerry@jerry.com / Displayed as E-Mail

Any suggestions.

Jerry

dannyseager

May 29 2009, 03:08 AM

Well I think you first need 2 fields... one for the hyperlink and one for the descriptive name.

To get the descriptive field should be relativly easy to get it basic.... you can use the replace function to change what is pasted.

Something like

CODE

If instr(HyperlinkField,"@")>0 then
    Descriptivefield="E-Mail"
else
    Descriptivefield=ConvertHyperlink(StrHyperlink)
end if

Public Function ConvertHyperlink(StrHyperlink as string) as string

ConvertHyperlink=StrHyperlink

Dim StrStripOut as string
StrStripOut="http://,.com,.co.uk,.net,.org"

for i = 0 to len(StrStripOut)-len(replace(StrStripOut,",",""))-1
    ConvertHyperlink=replace(ConvertHyperlink,split(StrStripOut,",")(i)
Next i
end function

Please note this is completly untested but should get you started.

sredworb

May 29 2009, 03:40 AM

Hi Danny,

Can't seem to get it to work...

Thanks..

Jerry

sredworb

May 29 2009, 03:43 AM

Any chance I can get you to add it to this sample db...

I can't get it...

Jerry

dannyseager

May 30 2009, 06:33 PM

Well I am now hoping I have understood the question

See attached

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.