Creating Form in Base and connect it to database

users
#1

Hi,

I have running PostgreSQL server on my laptop.

I have installed LibreOffice version 5.1.4.2 out there.

I created new Base file with connection to one of mine database.
Within Base I created a Form ( not with Form Wizard, because it is not
working ( Why? )).
On the Form I have labels and text boxes and a button.
The button should make changes in database when clicked. Mybe it is not
necessary this button at all?

I do not know what to do when editing this Form to get connected an
approppriate text box with approppriate field in database record?

Because right now there is nothing happen if I run this Form and fill out
text boxes.

#2

Hi csanyipal,

I have installed LibreOffice version 5.1.4.2 out there.

Which system do you use?

I created new Base file with connection to one of mine database.
Within Base I created a Form ( not with Form Wizard, because it is
not working ( Why? )).

Is Java working well on the system? See
Tools > Options > LibreOffice > Advanced > Java Options

On the Form I have labels and text boxes and a button. The button
should make changes in database when clicked. Mybe it is not
necessary this button at all?

You don't need a button there. There must be a navigationbar at the
bottom of the form-window. There you could save data by pressing the
save-button or by moving to another row.

I do not know what to do when editing this Form to get connected
an approppriate text box with approppriate field in database
record?

Is the form connected to a table of the database? Are the textboxes
connected to fields of the database?

Regards

Robert

#3

I am using Gentoo linux system.
I have installed Libreoffice without java support, so I am going now to
correct this.
After that I shall return to the Base Form and shall see what can I do out
there by following you advices. Thanks!

#4

Hi Pál,

I am using Gentoo linux system. I have installed Libreoffice
without java support, so I am going now to correct this.

After this the wizard should work. And this will be the better way to
get a working form for new users of Base.

When creating a form I have been used all the times the wizard and
changed things I wanted to change afterwords. There are many databases
and forms I have created this way and I won't miss the wizard for forms.

Regards

Robert