Tagged Questions

Database front end and management tool of the LibreOffice suite

learn more… | top users | synonyms

0
votes
0answers
22 views

libreoffice base highlight the content of a textfield

I setFocus the textfield but the cursor is set at the end of the text and I want all the text in the textfield selected and highlighted. I am using libreoffice basic and access2base
0
votes
0answers
45 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...
1
vote
0answers
24 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
0answers
13 views

Add rating user control to Form

Is it possible to add a rating control onto a Form within LibreOffice Base? Such as the following (from iTunes); I've had a look through the LibreOffice documentation and couldn't find anything ...
0
votes
0answers
71 views

LibreOffice Base Custom Record Navigation

I've created a form in LibreOffice Base that allows me to view and edit records in a table without any problems. The current record can be selected using the navigation toolbar but this kinda sucks ...
0
votes
1answer
21 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 ...
0
votes
0answers
84 views

What kind of software would I use for tracking/managing dues payments?

I'm a member of a small-but-not-too-small organization, in which members pay monthly dues. At the moment, our treasurer uses a simple Excel spreadsheet with no automation for tracking dues, with some ...
0
votes
0answers
49 views

Display rows of table control differently

I have a LibreOffice-Base form with a table control displaying contents of a database view. Is it possible to display the rows of this control in e.g. different colors or fonts depending on the ...
1
vote
0answers
961 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
1answer
258 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 ...
0
votes
1answer
355 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
0answers
86 views

openoffice base report

I'm using open office Base to create a stand alone database for my service record. the problem is when i try to create a specific report, i cannot get the output that i want. lets says, I want to open ...
0
votes
2answers
557 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
1answer
298 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 ...
1
vote
1answer
3k 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
0answers
455 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 ...
1
vote
1answer
317 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
2answers
324 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
1answer
1k 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
1answer
1k 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 ...
0
votes
1answer
1k 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!
13
votes
2answers
16k 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 ...
2
votes
0answers
197 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
2answers
2k views

Dynamic Filtering on LibreOffice Base Reports

Is it possible to do a Dynamic Filtering on LibreOffice Base Reports?
5
votes
2answers
1k 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 ...