Questions tagged [libreoffice-base]
Database front end and management tool of the LibreOffice suite
38
questions
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
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
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 ...
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
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 ...
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
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 ...
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 ...
0
votes
1
answer
679
views
Sync sheets in Libreoffice
Hopefully someone can help.
I have an eccommerce dropship website on Woocommerce which I update via CSV using WPAllImport. I currently download a CSV Spreadsheet from my supplier which contains ...
1
vote
1
answer
628
views
Cannot edit imported data in Libreoffice Base
I am using Libreoffice Base for my International GCSE ICT exam. I am practicing with past papers, but I can't get it to work. The files provided come as separate csv files, which have to be imported.
...
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
1
answer
2k
views
How to add a datasheet-style (grid) form/field in LibreOffice Base design view?
When creating a LibreOffice Base form via the Wizard, it is possible to choose a 'datasheet' style for the selected fields. The fields become part of a Mainform_Grid and/or Subform_Grid item if you ...
3
votes
2
answers
1k
views
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 ...
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 ...
4
votes
1
answer
5k
views
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 ...
0
votes
1
answer
299
views
modify a view that other views depend on
I use LibreOffice Base to create weekly reports. I have one table (named time_spent) that contains a lot of normalized data, and I am using views to do the processing required to produce the reports I ...
1
vote
0
answers
399
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
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, ...
0
votes
1
answer
44
views
OpenOffice showing syntax eror
Here's what I have so far:
SELECT DISTINCT Min("gpa"."current_gpa"),
"students"."lastname",
"students"."firstname"
FROM "students",
"gpa"
WHERE "students"."...
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 ...
1
vote
1
answer
678
views
How to use data contained in several related database tables for a form letter?
I want to create a form letter with LibreOffice Writer. The data is contained in a LibreOffice Base database, in several tables.
I followed the guide Creating a Form Letter. It seems that I can only ...
1
vote
2
answers
2k
views
Can LibreOffice Base directly use MySQL syntax?
From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
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
880
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 ...
3
votes
1
answer
13k
views
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 ...
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
658
views
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 ...
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 ...
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 ...
0
votes
1
answer
3k
views
Libreoffice Base: combobox keeps replacing value to 0
I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table (...
1
vote
1
answer
5k
views
Can LibreOffice Base odb databases migrate to SQL server?
If I make a LibreOffice Base database in its native ODB format, is it possible to later migrate the database to a SQL server such as PostgreSQL??? If so, how?
Thanks!
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
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 ...
0
votes
2
answers
3k
views
Dynamic Filtering on LibreOffice Base Reports
Is it possible to do a Dynamic Filtering on LibreOffice Base Reports?
8
votes
2
answers
3k
views
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 ...