Advanced Database – Assign/attach a macro to a control

Another way to directly run a macro is to create a button in the form. In the main Base window, right click the form and click Edit to open it in design view. Select the ‘Push button’ icon from the controls toolbar. Click and drag in the form to draw a button. Right click on…

Read More

Advanced Database – Assign/attach a macro to a command button

Open the form and select Tools->Customize Select the ‘Standard’ Toolbar from the drop-down list. Click Add Command. At the bottom of the Category section, select LibreOffice Macros. Navigate to the ‘Newrecord’ macro we created. Click Add. Notice that there is now a button on the Standard form toolbar that says Newrecord. If you click on…

Read More

Advanced Database – Create a simple macro

First, make sure that macro recording is enabled. Open a Libreoffice Base database file. From the main window taskbar select Tools->Options then select LibreOffice->Advanced. Check the optional feature: Enable macro recording. Please note that macro recording is limited in LibreOffice Base due to program stability issues. In the current version of Base, macros can only…

Read More