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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|