Apache OpenOffice Community Forum

Posted: **Sun Feb 04, 2018 3:41 pm**

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

Posted: **Sun Feb 04, 2018 3:57 pm**

Last week's topic: viewtopic.php?f=13&t=92140

Posted: **Sun Feb 04, 2018 4:06 pm**

thank you will give it a try... Thanks for the help

Posted: **Mon Feb 05, 2018 9:37 pm**

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

Apache OpenOffice Community Forum

Join Question on Hyperlink field in table

Join Question on Hyperlink field in table

Re: join Question on Hyperlink field in table

Re: join Question on Hyperlink field in table

Re: Join Question on Hyperlink field in table