Form where I can enter up to 8 values, Sum the values and put the result in a table field. The values will not be put into a table and would be discarded. Calculating Sums in a database is relatively simple using Queries but this statement makes the assumption that there will never be an entry erro...

Open the Form document in the Edit/Design Mode <Ctrl>Click on a problematic control then Right Click and select Control to open the Properties dialog If the dialog shows Properties: Currency Field Right click again and select Replace with > Numerical Field On the General tab of the Properties: Numer...

Actually, Base Form documents are Writer pages. That allows one to create stand alone forms where the user can display and edit database records without directly opening the Base file.
[Tutorial] Standalone Forms / Switchboard

they open to the correct size,

OO is working properly

but then expand to a larger different size: maybe a default size?

Your OS is overriding OO

Perhaps this will help
https://www.google.com/search?client=fi ... ize+on+mac

To a query of your table add: (CASE WHEN "NetScore" = 1 THEN 1 WHEN "NetScore" = 0 THEN 2 WHEN "NetScore" = -1 THEN 4 WHEN "NetScore" = -2 THEN 6 ELSE 0 END) as "Points" to display the Points according to the plan you described. According to the rule...

With HSQL you need to enclose all but the simplest field and table names in double quotes. Also verify that the both the fields are the same type, i.e. Integer, Decimal, Numeric or Float. Unlike spreadsheets databases use strong type checking which might explain why the calculation works in Excel bu...

What type of database do you have? Look along the bottom of the main Base window. Might be something like Embedded database HSQL database engine.

Try "Hole 1 Actual" - "Hole 1 Par"
Including spaces in field and table names will cause all sorts of grief, either eliminate them (Hole1Actual) or replace them with an underscore (Hole_1_Actual)

There are numerous good books on database design but I can't say I have a favorite to recommend. Use whatever is easily available to you. If you want to implement your database in Base with the built in HSQL back end then a bit of advice. If you choose to use the Embedded HSQL be sure to adhere to a...

Embedded Base databases where everything is stored in a single zip archive are susceptible to data corruption. 2.7 MB is probably larger than many but I have several larger including one that is 38 MB that loads without a hitch. The larger the table data the longer it takes to complete the zip proce...

Link to Oracle x86 download https://www.oracle.com/java/technologies/downloads/#java8-windows Or I installed the JRE .msi version of this on Windows 11 and so far is working. https://adoptium.net/temurin/releases/?version=11 Another option is Libre Office https://www.libreoffice.org/download/downloa...

On Windows 11 The folder C:\Program Files holds the installed 64 bit software The folder C:\Program Files (x86) holds the installed 32 bit software Open Office is a 32 bit application and is stored in Program Files (x86) . You will need the (x86) version of Java for Open Office. In Calc navigate to ...

I just want to change the path to the new path but impossible to understand where to change that ? I suspect that the installer stores path somewhere in the Windows Registry making it difficult to modify. If the JRE was installed with the Windows installer it should be listed at Tools>Options>OpenO...

I’ve tried right clicking on your query, selecting Edit to open in the Query Design GUI and when I press F5 it displays the results without any error messages. I get the same results
Windows 10
OO 4.1.14
LO 7.4.5.1 (x64)

Linux Mint
LO 6.4.7.2

Perhaps a platform issue?

to cover multiple items with the same purchase date ORDER BY "Story"."date of purchase", "Products"."brand" ASC or maybe ORDER BY "Story"."date of purchase", "Products"."unit price" ASC or list most expensive items first...

Similar question with a solution reported
https://ask.libreoffice.org/t/create-tr ... -base/9502

A relatively simple coded Macro can eliminate the push button, if that's the issue.. See form document Selection3 in the attached demonstration. The problem with coded macros is that they can be difficult to write and once working, easy to break. A seemingly minor change to the form document can som...

Another approach based on the example uploaded by Nick N,
Form document Selection2 allows up to 3 selections.

Nick G Two more suggestions. The ListBox query returns multiple identical choices which can be confusing for the user and make long lists even longer! Instead of a simple SELECT use SELECT DISTINCT to list each choice only once. Filter tables should not hold more that one row of data. But in the Fil...

Database design can be tricky. When get to a design, build some Forms to test it. You wouldn't be the first to scrap the original design and start over with newly learned lessons. Often multiple times. The table Mitgliedshaften appears to designed to reflect a Many to Many relationship between the o...

Be aware some compatibility issues (usually minor) have been reported when using Base with HSQL versions 2.5.0 and above. I currently have two Base databases using HSQL 2.7.0 and haven't run into any problems ... so far. If you think you want to try a more recent version of HSQL than 2.4.3 Be sure y...

When Base first loads a long data set like yours it initially only loads a small subset of the data, usually about 40 or 50 rows of data. As you scroll down it gradually adds rows. If you scroll down 100 rows or so and then scroll up, OO Base gets confused and displays all the rows with the same dat...

It appears that both Form documents that begin with "All Orders" have 2 Forms named MainForm. Open either one of the Form Documents in the Design/Edit mode and on the Form Design Toolbar select the Form Navigator. One MainForm has all the controls attached to it while the other has no cont...

Based on the format of the query in your question I'm assuming you are using an Embedded HSQL database. On a few occasions when I've encountered weird behavior I've used Windows Copy & Paste to made a copy of the .odb file and the copy has worked correctly. If that fails to help then upload a sa...

I doubt there is a problem with your installation but I need correct my earlier statement about SCHEMA queries and Embedded databases. The following query should list all the constraints SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS For your "unique" issue, look for tables in t...

Embedded HSQL doesn't support SHEMA queries, so trouble shooting your Index issue will be difficult. My suggestion would be to create a new table without any added Indexes then copy your data into the new table. A Unique constraint can be added to a table using SQL commands at Tools>SQL The basic fo...

The question is whether it is possible to do this without Subquery ...

No.
Base is not a MSAcess clone.
Using non-standard (ISO) syntax like that locks you into MSAccess, which I am sure is part of the Microsoft marketing strategy.

To use an alias like C in more than one term of the query usually requires it to be defined in a sub-query. The sub-query will probably need at least one more term to insure that it returns a single value. I haven't tested it but it might be something like select M.C, (M.C + A) D from A, B, (select ...

Dates are be confusing. Dates are stored in the database as a Double Value. The whole number part is the days since (or before if negative) Dec 30, 1899 When the Base front end displays the results of a query involving a field of Date type, it converts that number into a more readable format. When y...

Isn't there some construct like "currenntDB"? Not built in but this function reportedly will do much the same. Function ThisConnection2() As Object REM GET ACTIVE CONNECTION OF THE FIRST FORM - Similar to MS Access CurrentDB() REM usage Conn = ThisConnection2() On Error Goto HandleErr Dim...