Can I create a form in base with more than one page?

[Panchopar]

I want to create a 2 page form for libreoffice base. Is that possible and how

[Ratslinger]

Hello,

Forms do not have a fixed size and therefore cannot be compared to a page. Please explain what your intention is. Have seen this mean many things to may posters including the continuation of entry started on one form and finished on another.

Although probably not relevant, it is always best to include your OS, the specific LO version used and for Base the database used (and connector when applicable).

Please use add a comment or Edit question to respond and not an Answer as this is to actually answer the question.

[Panchopar]

I am using Mysql on a Ubuntu server. Using windows 10 with libreoffice 6.3 base connecting direct to the server on same lan. I want my form to have 2 pages for data entry but only one to print page one for customer. Page 2 will have info that only our store needs to see. Thanks for all your help.

[Ratslinger]

Hello,

Based on your information, there will be much to adjust to. It may even be an incorrect design. Splitting data onto two forms requires the second form to contain non-required information. That is because once you leave the first form, that record is written to the table. Also in dealing with this you will need to write macros to open the second form at the same place as the first form left off. Here are some links for this:

Base Macro - Click on Table Row to Open Record

I’m working on a home screen (aka switchboard) for my Base document that has button links to all the various forms of my database. In addition, there are search boxes with table control search results. My hope is to be able to write a macro to launch a record edit form when clicking on a row in the search results I can figure out everything except I don’t know how to access the active row (the one with the green triangle to the left). If I can detect which row is clicked, I can get the row’s ID …

Trying to create a button to open a form

Hi I am trying to create a button so that it will open up another form. I have tried various macro codes found on here but none of them will work. Any help would be appreciated. An example of what I have used. The form I am trying to open is called ‘Bonsai Database’. REM Open a form … OpenForm(“myForm”) Regards Richard

Base macro that opens a new/clean record in another form using python

Based on this I created a BASIC macro that opens a form and moves to insert record. The macro also “pokes” a value based on the “caller”. I tried to move this macro to python but is not working. It looks like the moveToInsertRow has totally different implementation in python than in BASIC (or the forms have different implementation…). I include an example (testpython.odb) where in form “Companies” there are two buttons. One working using BASIC and a second using python update: Is this a non …

Now to eliminate all this hassle, it is better to enter all information on one form. Then call up a second form (read only) and use that to print. Or, use Report Builder to create a report specifically for this.

Now if you are actually wanting a customer to enter data on the second form, well that is a whole bunch of more problems I would completely avoid.

[Ratslinger]

As with all questions, if this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.

[Panchopar]

I don’t want to use 2 Forms just a second page on the one and only form. Can I format the form page to use more space . and when printing have it not print the second page(space)?

[Ratslinger]

@Panchopar,

The easiest way to get more space, in editing form, use the zoom slider in lower right on status bar and lower the zoom level. Add a control in the lower right (any control - even a label). Now place the zoom level back at 100%. Area is larger. There is a open bug report dealing with tabbing to controls which are not initially visible. See tdf#93287

As for printing, when printing a form there is no selection. Same response as in answer -

Then call up a second form (read only) and use that to print. Or, use Report Builder to create a report specifically for this.

[Ratslinger]

Another method, if just height is needed, select the form background. Then press Enter until the desired height is reached.

[Panchopar]

thanks I changed the page format to 8.5 by 14 and all seems to work as I wanted it to. Thank to all.

[Ratslinger]

Glad you have something which works. Avoided that solution as it does not work under Ubuntu 20.04 with LO v6.4.5.2