Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I have successfully used the macro in Doug's answer on this post.. With minor mods, have this working from the documents macros. Base briefly appears, then becomes hidden with the established form then appearing.

As an aside, macros (for My Macros as example) can easily be distributed via extension (.otx) files and are very easy to install by the user.

If so desired, you can also password protect your macros.

Everything depends upon your needs and how much effort you are willing to expend.

I have successfully used the macro in Doug's answer on this post.. With minor mods, have this working from the documents macros. Base briefly appears, then becomes hidden with the established form then appearing.

As an aside, macros (for My Macros as example) can easily be distributed via extension (.otx) files and are very easy to install by the user.

If so desired, you can also password protect your macros.

Everything depends upon your needs and how much effort you are willing to expend.

Edit 7/5/2017:

As stated above, the macro from Dougs' post needs mods. Here are two examples both using the sample on the DocFoundation link you provided.

Sample 1: FR.FAQ.BASE_137_OuvrirForm.odb

This is exactly as from the link. When you open the .odb the main Base screen opens and then the form Instruments opens. Both the main screen and original form remain visible.

Sample 2: FR.FAQ.BASE_137_OuvrirForm_2.odb

This is a modified version of Sample 1. Please note the instructions I present here. VERY IMPORTANT!

When you open Sample 2, the main Base form appears briefly, the form Instruments opens and the main Base form disappears (actually hidden from sight). IMPORTANT! If you just close the form, the .odb is still active in memory! To Exit properly, use Ctrl & Q keys OR from Instruments menu select File->Exit LibreOffice.

Have no reason to believe either of these won't work on Mac.