Creating hyperlinks

Discuss the database features

Creating hyperlinks

Postby jjsmith2 » Tue Feb 06, 2018 2:51 am

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
jjsmith2
 
Posts: 5
Joined: Tue Feb 06, 2018 2:41 am

Re: Creating hyperlinks

Postby UnklDonald418 » Tue Feb 06, 2018 6:52 pm

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.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 930
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests