[Embedded HSQL] Simple Vocabulary Trainer

Some examples to be used directly
Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

[Embedded HSQL] Simple Vocabulary Trainer

Post by Villeroy »

Simple vocabulary trainer with documentation form and no macros.
Inclding a documentation form, a form to search, filter, edit your vocabulary and 2 forms where you get not yet answered questions to be answered from language A to B and vice versa.
There is a small set of English-Croatian vocabulary from topic https://ask.libreoffice.org/t/macro-to- ... ears/86406 (ask.libreoffice.org)

In order to clear my test data from the database:
menu:Tools>SQL...

Code: Select all

DELETE FROM VOCAB
This will delete the whole vocabulary including any related answers in tables AB and BA.

In order to use this database with any pair of languages:
-- You are free to rename all the forms and reports.
-- You are free to relabel all visible elements in forms and reports as long as you do not touch any names related to the underlying queries and tables (these are names on the "Data" tab of the control properties).
It is possible to import 2 columns of vocabulary from Calc by means of copy&paste. See documentation form.

Feel free to ask any questions in the Base forum.

How to rename a form document or report:
1) Right-click the form's or report's icon in the document's forms container and choose Rename ...
2) Replace the old name with a new one and confirm the dialog.

How to relabel form controls:
1) Right-click the form's icon in the document's forms container and choose Edit...
2) Ctrl+Click selects a single label associated to a form control or a check box or a column header in a table grid.
3) Right-click the selected label and choose "Control Properties..."
4) Edit the "Label" property on the "General" tab of the properties dialog. Do not touch any "Data" tab.
5) Ctrl+Click the next label, check box or column header.

The procedure is very similar with a report.

Finally, save and close the form document and the containing database document.
Attachments
vocab.odb
Simple vocabulary trainer
(58.07 KiB) Downloaded 288 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply