Hi anyone,
I created a simple database in Open Office. One column in my table contains web addresses of possible clients web sites. My tool bar shows an icon for hyperlinks but it is grayed out. How do I activate it. I believe the fields in my table contain the correct syntax.
What am I missing here?
Thanks in advance
Jim
Creating hyperlinks
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Creating hyperlinks
Wow, hyperlinks seem to be a hot topic the past few days.
Base is a front end for an underlying HSQLDB database engine which does not have a hyperlink data type so web addresses must be stored in text fields.
However by using macro code, data stored in a database text field can be used to link to a web address.
A solution using a basic macro can be found at
Re: Join Question on Hyperlink field in table
or a solution using a python macro
Re: hyperlink datatype
The Hyperlink button on the menu starts a dialog allowing a hyperlink to be inserted onto a Writer page or a Calc Spreadsheet, but it has no use in a database field.My tool bar shows an icon for hyperlinks but it is grayed out
Base is a front end for an underlying HSQLDB database engine which does not have a hyperlink data type so web addresses must be stored in text fields.
However by using macro code, data stored in a database text field can be used to link to a web address.
A solution using a basic macro can be found at
Re: Join Question on Hyperlink field in table
or a solution using a python macro
Edit: It appears you have already found this link. |
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11