Sub AbrirFormularioYLimpiar Dim oFormulario As Object Dim oFrame As Object Dim oDoc As Object oDoc = ThisDatabaseDocument oFrame = oDoc.CurrentController.Frame

Sub AbrirFormulario ' This macro opens a specific form in LibreOffice Base Dim oFormulario As Object Dim oFrame As Object Dim oDoc As Object ' Get the current database document context oDoc = ThisDatabaseDocument oFrame = oDoc.CurrentController.Frame

' Open the form oFormulario = oDoc.FormDocuments.getByName("Clientes") ' Change form name oFormulario.open(oFrame)

If you’ve built a database in LibreOffice Base, you know that the default navigation can feel a bit clunky. You open the file, and you’re greeted by the main database window—tables, queries, forms, reports. It’s powerful, but not very "user-friendly," especially if you want non-technical users to just enter data.

The solution? In the Spanish-speaking developer community, this is often searched as "macro para abrir formulario LibreOffice Base" .

' Replace "NombreDeTuFormulario" with the exact name of your form oFormulario = oDoc.FormDocuments.getByName("NombreDeTuFormulario")

Create a macro, assign it to the "Open Document" event, and watch your database become instantly more professional. Do you have a favorite LibreOffice Base trick? Let me know in the comments below. ¿Te gustaría un tutorial sobre cómo crear formularios con subformularios?