Join Question on Hyperlink field in table

Discuss the database features
Post Reply
Sailor45
Posts: 2
Joined: Sun Feb 04, 2018 3:33 pm

Join Question on Hyperlink field in table

Post by Sailor45 »

I am trying to create a table with one field as a hyperlink to a suppliers website... there will also be a table of products with a link to product page. But am not sure how to set up the field as what value. No matter what I set the field up as the hyperlink button on tool bar is always grayed out?

I am sure I am doing something wrong. would love to have it set so is a button to click but a clickable link is ok also.

Very sorry if this is covered in another post after searching i could not find it.. Am pretty new to openoffice database but use to do alot of work in Alpha 5.

Thanks any help in right direction woud be great..

thank you All
openoffice 4.1.1 windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: join Question on Hyperlink field in table

Post by Villeroy »

Last week's topic: viewtopic.php?f=13&t=92140
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Sailor45
Posts: 2
Joined: Sun Feb 04, 2018 3:33 pm

Re: join Question on Hyperlink field in table

Post by Sailor45 »

thank you will give it a try... Thanks for the help
openoffice 4.1.1 windows 10
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Join Question on Hyperlink field in table

Post by Nocton »

Would this help?
Put your url in a control called txtWebSite which should your hyperlink field as its data source.
Then make a command button with the function below as the 'Approve action' event.
and the 'Action 'Open document/web page'
When you click on the button it will open the web page for what ever is in txtWebSite.

Code: Select all

Function openurl(oEv as object)
' to open URL in browser
Dim oForm,oTextBox
oForm=oEv.source.model.parent
oTextBox=oForm.getbyname("txtWebSite")
oEv.source.model.targeturl=oTextBox.text
openurl=true
End Function
OpenOffice 4.1.12 on Windows 10
Post Reply