[Solved] Hidden Form

Creating and using forms
Post Reply
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

[Solved] Hidden Form

Post 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
Last edited by capemayal1 on Thu Jan 28, 2021 1:12 am, edited 1 time in total.
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Hidden Form

Post by Villeroy »

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
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

Re: Hidden Form

Post by capemayal1 »

Sorry - I knew I forgot something.

OS = Ubuntu 16.04
Libreoffice 5
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Hidden Form

Post 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.
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
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Hidden Form

Post 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"
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
capemayal1
Posts: 90
Joined: Fri Dec 31, 2010 5:16 pm

Re: Hidden Form

Post by capemayal1 »

Thank you.
I'm going to go to the standalone forms.
Al
Post Reply