Questions tagged [libreoffice-base]
Database front end and management tool of the LibreOffice suite
16
questions with no upvoted or accepted answers
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 ...
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 "...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 "...
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 ...