LIBREOFFICE BASE - CREATE A SWITCH BOARD TO OPEN FORMS USING A PUSH BUTTON
Shane Piper Shane Piper
1.58K subscribers
45,589 views
269

 Published On Sep 16, 2012

If you liked this video donate: https://www.paypal.com/cgi-bin/webscr...

PLEASE READ SINCE DOING THIS VIDEO LIBREOFFICE 4.1 now only likes UPPERCASE and LOWERCASE to be exact as they programmed it. See Below.

Your code:
oNewFormDocument = ThisDatabaseDocument.FormDocum­ents.getbyname(sNewDocumentNam­e).open

Change to:
oNewFormDocument = ThisDataBaseDocument.FormDocum­ents.getbyname(sNewDocumentNam­e).open

Notice 'ThisDataBaseDocument' The B in base has to be UPPERCASE for the switch board to work in LibreOffice Base 4.1

As you may or may not know creating a push button to open a form in Libreoffice Base is non existent. Unlike in Access where there is a little wizard to do all the work for you. This Video shows you how to use Libreoffice Basic/Macros to force a button to open a form.

This video demonstrates a basic switch board with 3 forms.

show more

Share/Embed