Questions tagged [libreoffice-base]

Database front end and management tool of the LibreOffice suite

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
6k views

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 ...
Saren Tasciyan's user avatar
3 votes
0 answers
1k views

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 "...
rumtscho's user avatar
  • 3,994
2 votes
1 answer
2k views

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 ...
user avatar
2 votes
0 answers
312 views

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 ...
Tanktalus's user avatar
  • 166
1 vote
0 answers
28 views

LibreOfficeDev5.3 on Ubuntu 16.04 does not save modified forms

I've installed LO dev 5.3, because I need direct SQL to work, which I read was fixed in this version, but now I'm facing the issue that I can't edit any forms anymore. I can create new forms using the ...
oneindelijk's user avatar
1 vote
0 answers
390 views

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 ...
Andrew's user avatar
  • 11
1 vote
0 answers
184 views

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, ...
Josh's user avatar
  • 443
1 vote
2 answers
1k views

No option to print LibreOffice Base document

My husband is trying to print out a document he has produced in LibreOffice Base. Unfortunately there is no option to print and we have tried everything we can think of. Bit of a Luddite so please ...
F Kerry's user avatar
  • 11
1 vote
1 answer
5k views

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 ...
Shlomi Loubaton's user avatar
0 votes
0 answers
22 views

writeDate Macro not working in version 7.6.4 rev2 after years of using it

I have been using this macro for years to assign todays date as the default date to a field when no date is selected. I downloaded version 7.6.4 rev2 and it stopped working. REM This macro writes the ...
Luis Fern's user avatar
0 votes
2 answers
2k views

Error "Unrecognized database format" when opening a .mdb file

I have a .mdb file which I do not know which version of ms access was used to create it. When I try to open it, I get "Unrecognized database format" error. I tried using MS ACCESS 2003 and ...
Eslam's user avatar
  • 191
0 votes
3 answers
2k views

LibreOffice Base Primary Key of several columns?

I have created a database with one table like this: How to create a primary key like: (Patient, Date, Test, Parameter) ? The database will be holding data for numerous patients examined multiple ...
Pawel Debski's user avatar
0 votes
1 answer
922 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
bob.sacamento's user avatar
0 votes
1 answer
28 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...
bob.sacamento's user avatar
0 votes
2 answers
2k views

Is it possible to put a wildcard search into a parameter query in LibreOffice Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like: SELECT * FROM "...
user2088009's user avatar
0 votes
1 answer
878 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
user2088009's user avatar