UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> 2nd Hyperlink Issue...    
 
   
sredworb
post May 29 2009, 03:00 AM
Post #1

UtterAccess Guru
Posts: 918
From: Chicago Suburb
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
Go to the top of the page
 
+
dannyseager
post May 29 2009, 03:08 AM
Post #2

UtterAccess VIP
Posts: 13,031
From: Leicester, UK
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.
Go to the top of the page
 
+
sredworb
post May 29 2009, 03:40 AM
Post #3

UtterAccess Guru
Posts: 918
From: Chicago Suburb
Hi Danny,

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

Thanks..

Jerry
Go to the top of the page
 
+
sredworb
post May 29 2009, 03:43 AM
Post #4

UtterAccess Guru
Posts: 918
From: Chicago Suburb
Any chance I can get you to add it to this sample db...

I can't get it...

Jerry
Attached File(s)
Attached File  HyperlinkIssue.zip ( 13.78K ) Number of downloads: 14
 
Go to the top of the page
 
+
dannyseager
post May 30 2009, 06:33 PM
Post #5

UtterAccess VIP
Posts: 13,031
From: Leicester, UK
Well I am now hoping I have understood the question

See attached
Attached File(s)
Attached File  HyperlinkIssue.zip ( 34.94K ) Number of downloads: 8
 
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 03:43 AM