Questions tagged [libreoffice-base]
Database front end and management tool of the LibreOffice suite
38
questions
2
votes
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 ...
6
votes
4
answers
9k
views
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 ...
0
votes
0
answers
26
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 ...
1
vote
0
answers
185
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
1
answer
112
views
Can't change Libreoffice Base from dark mode
I am running Libreoffice 7.5.4.2 in a Mac Mini with an M1 chip. I used to run LibreOffice 7.3.1.3 on the same computer. When I opened my databases on 7.3.1.3, they opened all with a gray background, ...
0
votes
2
answers
5k
views
How to dynamically update a LibreOffice spreadsheet from file?
I have a CSV file with data I want in a spreadsheet - mostly to display a chart based on it. I also want the chart to be updated every time the file is rewritten by a console application. What I tried ...
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 ...
20
votes
3
answers
45k
views
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=<...
2
votes
1
answer
3k
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 ...
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
1k
views
Importing big bunch of files to LibreOffice Base table in one shot
I have table like this:
and a bunch of CSV files like this:
in per-patient directories.
Please note that I need to take a Patient field from path name and Date from file name (as you see).
What is ...
1
vote
1
answer
2k
views
Set background color in LibreOffice base form
The title pretty much says it all. I am trying to create a form in design view in LibreOffice and I can't see any control that allows me to set the background color. I've seen some old answers to ...
0
votes
1
answer
948
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
33
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 ...
1
vote
1
answer
150
views
Libre Office form -- need data sheet layout with a lookup field
I am trying to develop a timecard form. The fields are ID, task, date, start time, and stop time. I want to create the form as a datasheet. I don't know the specific name for this, but I want it to ...