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: 474
Thanks: 275
Thanked 1 Time in 1 Post
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: 3,024
Thanks: 35
Thanked 720 Times in 703 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
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 online now   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: 474
Thanks: 275
Thanked 1 Time in 1 Post
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, 8 views)

access2010 is offline   Reply With Quote
Old 06-13-2019, 06:13 PM   #4
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,950
Thanks: 0
Thanked 462 Times in 458 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: 474
Thanks: 275
Thanked 1 Time in 1 Post
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: 3,024
Thanks: 35
Thanked 720 Times in 703 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
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 online now   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: 474
Thanks: 275
Thanked 1 Time in 1 Post
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
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,950
Thanks: 0
Thanked 462 Times in 458 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: 474
Thanks: 275
Thanked 1 Time in 1 Post
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
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 08:23 AM.


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