Super User
Super User

Questions tagged [libreoffice-base]

Database front end and management tool of the LibreOffice suite

39 questions
20
votes
3 answers

How do I connect to a PostgreSQL server using LibreOffice Base?

I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5 (this applies to LibreOffice 4 as well): The following syntax (localhost:5432=; database name worktime) doesn't…
bwDraco
  • 46,683
8
votes
2 answers

Insert a field at a specific position

In a LibreOffice Base document, the sequence of fields in a table definition is important[0]. But when I ask the “Table Design” dialogue to insert a field, or to paste a row from the clipboard, it insists on placing the new field at the end. I'm…
bignose
  • 3,325
6
votes
4 answers

Need today's date as default value in a form field in Libre Office

New to Libre Office Base. I've found how to set the default value in a table to the current date. Now I need to have the current date show up in the corresponding field in a form. I have tried inserting into "default value" TODAY() and CURRENT_DATE.…
bob.sacamento
  • 741
4
votes
1 answer

Populate foreign key using combo/dropdown on form

I'd like to populate a foreign key field in one table using a combobox/dropdown where the values the user sees are not the IDs but a description field from the foreign table. Consider the following setup: create table people ( id int identity…
LondonRob
  • 455
3
votes
0 answers

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and platform independent. I really like Libreoffice and…
Saren Tasciyan
  • 255
3
votes
1 answer

How to set up the jdbc driver to connect to hsqldb from libreoffice?

I am trying to "split" a LibreOffice .odb file into a HSQL database and an OpenOffice document containing forms and macros. I am trying to follow the instructions from this thread: Within a few minutes you can convert your embedded HSQLDB to a…
rumtscho
  • 4,084
3
votes
0 answers

How to represent m:n relationships in a form in Libre Office base?

I have an embedded database in Libre Office. I am building a form in it, and got into a problem. I have a table called "Author" and another table called "Publication", connected by a third table "AuthorsAndPublications" (it is an m:n relationship).…
rumtscho
  • 4,084
3
votes
2 answers

LibreOffice 5.2.2.2 won't run without Java

I am trying to get LibreOffice to work with my Mac. We are trying to use the database application, but keep getting asked to install Java so it can connect to the tables. I have installed Java and can see that the installed java instance is located…
John Smith
  • 157
2
votes
1 answer

Postgresql is not avaible in Libreoffice Base

I want to edit a postgresql base using libreoffice-base. When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones available are: jdbc oracle…
Stephane Rolland
  • 460
  • 7
  • 23
2
votes
1 answer

How to use CREATE TABLE queries in LibreOffice Base?

I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it…
Shlomi Loubaton
  • 181
2
votes
0 answers

Querying DB2 view from Libreoffice Base

I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get a bunch of information, but if I try to view it…
Tanktalus
  • 166
2
votes
1 answer

Why am I having trouble opening databases with LibreOffice on Ubuntu 24.2.2?

I am running LibreOffice on Ubuntu 24.2.2. I am trying to open my four databases, one at a time, which are located in /home//. When I attempt to open a new database in LibreOffice Base, two of them appear in the drop down box…
Chuck Hanson
  • 21
  • 1
2
votes
1 answer

Open an Access database in LibreOffice Base

I try to open a access database in LibreOffice Base First, I installed LibreOffice sudo apt-get install libreoffice Then I downloaded UCanAccess (http://ucanaccess.sourceforge.net/site.html) and unzipped it into the…
Zekura
1
vote
0 answers

LibreOffice Base sub form with multiple rows displayed

How do I show multiple lines in my sub-form? For example, my main form is a prospect, with the sub-form recording and displaying one or more activity. After creating the sub-form, only one line is displayed at a time.
Andrew
  • 11
1
vote
0 answers

How to print a LibreOffice Base Relation Design?

I've gone to the trouble of creating a graphic representation of my database design using Relation Design tool in LibreOffice Base. How can I print that out/export it to a PDF to share with others, other than with one (or many) screenshot? Ctrl+P…
Josh
  • 443
1
2 3