A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlink on forms



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 10:11 PM posted to microsoft.public.access.forms
hjgoldstein
external usenet poster
 
Posts: 4
Default Hyperlink on forms

I have a silly problem which is baffling me.

I have two forms - one single form view, one continuous forms view.

The single form has a tab control.

I have a hyperlink text box control on the continuous form and an identical
one on the tab control of the single form.

The hyperlink on the tab control only works if the sub-menu item "Hyperlink
Open Hyperlink" is used. If I click on the control, the system inserts a

"#" before and after the url and then does nothing else. If I put the text
box control in an area of the form outside of the tab control, it works fine.

Any ideas?
  #2  
Old May 28th, 2010, 02:29 AM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default Hyperlink on forms

Don’t know the answer to your problem but I don’t use hyperlinks and
if you cannot find a solution to it you can try this

I don’t use the hyperlink I only store the path in my database

Ie

C:\programfiles\mydocuments\document.doc

Or

http://www.google.co.nz

I then assign this to a control and use onclick to run this code

Application.FollowHyperlink mycontrol.Value

Hope this helps

Regards
Kelvan
  #3  
Old May 28th, 2010, 09:06 AM posted to microsoft.public.access.forms
hjgoldstein
external usenet poster
 
Posts: 4
Default Hyperlink on forms

Thanks for your reply Milord.

I tried your suggestion (clever) but exactly the same occurs. I just can't
understand why the Tab Control doesn't like it. The strangest thing is the
"#" characters appearing at either end of the url when you click on it.

I'd appreciate any other suggestions from any of you genii.

Thanks.

"Lord Kelvan" wrote:

Don’t know the answer to your problem but I don’t use hyperlinks and
if you cannot find a solution to it you can try this

I don’t use the hyperlink I only store the path in my database

Ie

C:\programfiles\mydocuments\document.doc

Or

http://www.google.co.nz

I then assign this to a control and use onclick to run this code

Application.FollowHyperlink mycontrol.Value

Hope this helps

Regards
Kelvan
.

  #4  
Old May 30th, 2010, 09:55 PM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default Hyperlink on forms

Sorry the datatype in the table needs to be text not hyperlink the #
around the hyperlink is ms accesses way of knowing it is a hyperlink.

To be honest the clicking of the hyperlink on a tab control works for
me but try this if you don’t want to modify your table

Application.FollowHyperlink Mid(mycontrol.Value, InStr(1,
mycontrol.Value, "#") + 1, Len(mycontrol.Value) - InStr(1,
mycontrol.Value, "#") - 1)

What this does is looks at the hyperlink and just grabs the text
between the # values

Regards
Kelvan
  #5  
Old June 1st, 2010, 08:56 AM posted to microsoft.public.access.forms
hjgoldstein
external usenet poster
 
Posts: 4
Default Hyperlink on forms

Bingo! Thanks mate.

"Lord Kelvan" wrote:

Sorry the datatype in the table needs to be text not hyperlink the #
around the hyperlink is ms accesses way of knowing it is a hyperlink.

To be honest the clicking of the hyperlink on a tab control works for
me but try this if you don’t want to modify your table

Application.FollowHyperlink Mid(mycontrol.Value, InStr(1,
mycontrol.Value, "#") + 1, Len(mycontrol.Value) - InStr(1,
mycontrol.Value, "#") - 1)

What this does is looks at the hyperlink and just grabs the text
between the # values

Regards
Kelvan
.

  #6  
Old June 1st, 2010, 08:57 AM posted to microsoft.public.access.forms
hjgoldstein
external usenet poster
 
Posts: 4
Default Hyperlink on forms

Bingo! Thanks Mate

"Lord Kelvan" wrote:

Sorry the datatype in the table needs to be text not hyperlink the #
around the hyperlink is ms accesses way of knowing it is a hyperlink.

To be honest the clicking of the hyperlink on a tab control works for
me but try this if you don’t want to modify your table

Application.FollowHyperlink Mid(mycontrol.Value, InStr(1,
mycontrol.Value, "#") + 1, Len(mycontrol.Value) - InStr(1,
mycontrol.Value, "#") - 1)

What this does is looks at the hyperlink and just grabs the text
between the # values

Regards
Kelvan
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.