[Base Database] How to open a particular form at startup ?

users
#1

Hi,

i have a database created with Base from LibreOffice.
i have a form stored in the same ODB file called "FMain".

Now how can i do to open automatically the form when i open the ODB file ?

thx.

A.

#2

Hi :slight_smile:
Is this something to do with somehow saving the Form outside of the
database so that people can just double-click on the Form itself without
opening the database or am i barking up the wrong tree?
Regards from
Tom :slight_smile:

#3

Hi,

i have a database created with Base from LibreOffice.
i have a form stored in the same ODB file called "FMain".

Now how can i do to open automatically the form when i open the ODB file ?

https://forum.openoffice.org/en/forum/viewtopic.php?f=39&t=34147

read the thread all the way through to the end.

Alex

#4

Hi,

I have a macro similar to neptuneuk's that Alex pointed to, but I go one
step further.

I run Windows 7 64 bit. I right click on my project's .odb file, click on
'Send to' and then on 'Desktop (create shortcut)'. Then I can simply
double click on the shortcut to go directly into my Main Menu form.

Sometimes, usually if I have just started my PC, it's a bit slow and
LibreOffice's initial menu appears for a few seconds before the Menu form
is displayed. But once the machine has warmed up, double clicking on the
shortcut displays the Menu almost immediately. I have found this is
simpler for my users. It also keeps them away from the underlying LO menu
and prevents them being confused by a screen that they don't need to be
concerned about!

I have several such shortcuts on my desktop and find the them faster than
opening LibreOffice and going through several steps to select the .odb file
I want to open.

Don't know how well this would work on other operating systems, but it
works well for me.

Noel

#5

What Noel has done also works with Linux by creating a soft link to the database on the Desktop. Then double clicking the link causes the database to open. Similarly, creating a soft link to a folder containing the databases that are often used can be used. Then double clicking the link and then double clicking the name of the desired database will accomplish the same thing.
      But I do not think this is what the OP was wanting. When the database opens, he wants the form named, FMain, to open as well as the main database window. Obviously, he would want the window containing the FMain form to be on top.

Dan

#6

Hi Dan,

Its good to know that Linux users can also use this technique.

Regarding opening FMain, neptuneuk shows at the bottom of his post that
this is achieved, (when the database initially opens), by clicking on Tools

Customise | Events and setting Open Document to call the macro that

opens FMain. After that, when the database opens, it automatically
displays FMain.

Noel