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
Join Question on Hyperlink field in table
Join Question on Hyperlink field in table
openoffice 4.1.1 windows 10
Re: join Question on Hyperlink field in table
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: join Question on Hyperlink field in table
thank you will give it a try... Thanks for the help
openoffice 4.1.1 windows 10
Re: Join Question on Hyperlink field in table
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.
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