Ms Access 2003 Hyperlinks (1 Viewer)

access2010

Registered User.
Local time
Today, 04:05
Joined
Dec 26, 2009
Messages
1,019
Our Hyperlinks in Ms Access 2003 sometimes work but are inconsistent.

How can I use Office 2003 (which is a 32 bit version) for hyperlinks functionality?

Thank you.
Nicole
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:05
Joined
Oct 29, 2018
Messages
21,357
Most people tend not to use Hyperlink data type and simply use text in conjunction with code. For example, in the Click event of the textbox, you could try something like:
Code:
Application.FollowHyperlink Me.TextboxName
Hope it helps...
 

access2010

Registered User.
Local time
Today, 04:05
Joined
Dec 26, 2009
Messages
1,019
theDBguy


Thank you for your suggestion, which sometimes works and other times does not work.
Could you please suggest how to click the "Binocular" on the form which would copy the hyperlink and then open the chosen hyperlink page in the browser?
Could you also suggest how to keep error messages from crashing the form if a blank record is clicked?


Thank you,
Nicole
 

Attachments

  • Hyperlink_Field.mdb
    428 KB · Views: 63

access2010

Registered User.
Local time
Today, 04:05
Joined
Dec 26, 2009
Messages
1,019
June7

110%, thank you your code does what we want

Nicole
 

access2010

Registered User.
Local time
Today, 04:05
Joined
Dec 26, 2009
Messages
1,019
June7 and theDBguy

Thank you both for your assistance.
Your code worked in one form, but does not work in an other.
We receive an error message= Hyperlinks can be harmful.

Your assistance will be appreciated.
Crystal
 

Attachments

  • Hyperlink_Field_Error.mdb
    620 KB · Views: 64

June7

AWF VIP
Local time
Today, 03:05
Joined
Mar 9, 2014
Messages
5,423
The first db uses text field for URL strings. This db used Hyperlink type field. To use FollowHyperlink, have to remove the # characters that separate the hyperlink parts. Did you look at the Allen Browne link? Here is another http://allenbrowne.com/casu-09.html

If there is no text in the 1st and 3rd parts, try:

Application.FollowHyperlink Replace(Me.WebSite_01,"#","")

If there is text in the 1st and 3rd parts, gets more complicated. So just to handle either:

Application.FollowHyperlink Mid(Left(Me.WebSite_01, InStrRev(Me.WebSite_01, "#") - 1), InStr(Me.WebSite_01, "#")+1)

Why bother with the button if you use Hyperlink field? Just click the field.

CocaCola site doesn't want to open at all, the others are slow.
 
Last edited:

access2010

Registered User.
Local time
Today, 04:05
Joined
Dec 26, 2009
Messages
1,019
June7
We had used the wrong field type for our Hyper Links, now that the field has been changed to text our Hyper Link Binocular Button works

Thank you,
Nicole


===

? = Why bother with the button if you use Hyperlink field? Just click the field.
We tried the above and it worked about 40% of the time, but now that we have changed to field to Text our Hyperlink Binocular button always works.
 

Users who are viewing this thread

Top Bottom