Creating hyperlinks

Discuss the database features
Post Reply
jjsmith2
Posts: 5
Joined: Tue Feb 06, 2018 2:41 am

Creating hyperlinks

Post by jjsmith2 »

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
Apache OpenOffice 4.1.5
UnklDonald418
Volunteer
Posts: 1549
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Creating hyperlinks

Post by UnklDonald418 »

Wow, hyperlinks seem to be a hot topic the past few days.
My tool bar shows an icon for hyperlinks but it is grayed out
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.
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. 
Re: hyperlink datatype
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
Post Reply