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
109
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
945
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
676
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
627
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 ...