Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-07-2019, 10:05 AM   #1
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Ms Access 2003 Hyperlinks

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

access2010 is offline   Reply With Quote
Old 06-07-2019, 10:09 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,793
Thanks: 50
Thanked 1,093 Times in 1,074 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Ms Access 2003 Hyperlinks

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...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
access2010 (06-13-2019)
Old 06-13-2019, 04:15 PM   #3
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Ms Access 2003 Hyperlinks

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
Attached Files
File Type: mdb Hyperlink_Field.mdb (428.0 KB, 9 views)

access2010 is offline   Reply With Quote
Old 06-13-2019, 06:13 PM   #4
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,291
Thanks: 0
Thanked 534 Times in 530 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Ms Access 2003 Hyperlinks

Code:
Private Sub WebLink_Click()
If Not Me.NewRecord And Not IsNull(Me.WebLink) Then
    Application.FollowHyperlink Me.WebLink
End If
End Sub
Review http://allenbrowne.com/func-GoHyperlink.html
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following 2 Users Say Thank You to June7 For This Useful Post:
access2010 (06-13-2019), theDBguy (06-13-2019)
Old 06-13-2019, 06:58 PM   #5
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Ms Access 2003 Hyperlinks

June7

110%, thank you your code does what we want

Nicole
access2010 is offline   Reply With Quote
Old 06-13-2019, 07:37 PM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,793
Thanks: 50
Thanked 1,093 Times in 1,074 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Ms Access 2003 Hyperlinks

Quote:
Originally Posted by access2010 View Post
June7

110%, thank you your code does what we want

Nicole
Hi Nicole. Glad to hear you're all sorted out now. Good luck with your project.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
access2010 (06-13-2019)
Old 06-13-2019, 09:00 PM   #7
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Ms Access 2003 Hyperlinks

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
Attached Files
File Type: mdb Hyperlink_Field_Error.mdb (620.0 KB, 7 views)

access2010 is offline   Reply With Quote
Old 06-13-2019, 09:11 PM   #8
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,291
Thanks: 0
Thanked 534 Times in 530 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Ms Access 2003 Hyperlinks

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.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by June7; 06-13-2019 at 09:32 PM.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
access2010 (06-14-2019)
Old 06-14-2019, 09:29 PM   #9
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 484
Thanks: 287
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Ms Access 2003 Hyperlinks

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.

access2010 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked SQL 2008 Tables + Acess 2003 Really Slow, Access 2003 wbatten General 0 08-29-2013 05:50 AM
Hyperlinks in access Lifeseeker Tables 3 04-04-2011 10:30 AM
export a report from access 2003 to excel 2003 using the outputto method DJBummy General 0 03-08-2006 07:23 AM
[SOLVED] Hyperlinks and Access beans General 2 06-24-2005 07:36 AM
[SOLVED] hyperlinks and access mission2java_78 General 1 09-05-2002 06:44 PM




All times are GMT -8. The time now is 09:50 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World