Page 1 of 1

[Solved] Hidden Form

Posted: Wed Jan 27, 2021 3:50 am
by capemayal1
I have an input query which works as I expect it too.

I have a form that opens and runs the query. That works fine.

My problem is that when the form opens it is hidden by the main database window.

I must minimize the main database window to see the form.

How can I make the form open on top of, or bring it to the front of the database window.

Thanks in advance
AL

Re: Hidden Form

Posted: Wed Jan 27, 2021 12:34 pm
by Villeroy

Re: Hidden Form

Posted: Wed Jan 27, 2021 2:44 pm
by capemayal1
Sorry - I knew I forgot something.

OS = Ubuntu 16.04
Libreoffice 5

Re: Hidden Form

Posted: Wed Jan 27, 2021 7:26 pm
by Villeroy
I used Ubuntu 16.4 with LO5 until 2019 and can not remember if I stumbled upon this problem at any time. Today's window managing systems behave somewhat erratic. When you install 18.4 you will notice another set of annoyances that need to be turned off. I think it has something to do with the Ubuntu/X11/Gnome/Unity/whatever setup.

Re: Hidden Form

Posted: Wed Jan 27, 2021 7:36 pm
by Villeroy
How to get a stand-alone form that can be opened without database window:
1) Open the form and save it as a stand-alone Writer document.
2) Close the database and form. Open the form from its new location.
3) The logical form lost its connection. Turn on edit mode, right-click>Form... and restore the connection type and name of table/query adding either the name of the data source or the path of the database document. Do the same for any subform(s).
4) If the form works flawlessly, call menu:File>Properties, tab "Security" and turn on read-only mode so the document opens in the same read-only mode as any embedded form document. You can do this on file system level as well. Nautilus:Right-click>Properties... change "read and write" to "read only"

Re: Hidden Form

Posted: Thu Jan 28, 2021 1:12 am
by capemayal1
Thank you.
I'm going to go to the standalone forms.
Al