Access2Base 是一個 LibreOffice Basic 語言巨集程式庫，適用於（商業或個人）應用程式開發者與進階使用者。儲存於「LibreOffice 巨集與對話框」。
The functionalities provided by the implemented macros are all directly inspired by Microsoft Access. The macros are callable mainly from a LibreOffice Base application, but also from any LibreOffice document (Writer, Calc, ...) where access to data stored in a database makes sense.
Access2Base 意在提供比標準 UNO API (Application Programming Interface) 更簡潔、直覺與易學的 API。
The library is documented online on http://www.access2base.com.
a simplified and extensible API for forms, dialogs and controls manipulations similar with the Microsoft Access object model,
an API for database access with the table, query, recordset and field objects,
a number of actions with a syntax identical to their corresponding Microsoft Access macros/actions,
the DLookup, DSum, ... database functions,
支援 Forms!myForm!myControl 之類的縮寫表示法
a consistent errors and exceptions handler,
facilities for programming form, dialog and control events and
the support of both embedded forms and standalone (Writer) forms.
REM Open a form ... OpenForm("myForm") REM Move a form to new left-top coordinates ... Dim ofForm As Object ' In VBA => Dim ofForm As Form Set ofForm = Forms("myForm") ofForm.Move(100, 200) REM Get the value of a control ... Dim ocControl As Object ocControl = ofForm.Controls("myControl") MsgBox ocControl.Value REM Hide a control ... ocControl.Visible = False REM ... or alternatively ... setValue("Forms!myForm!myControl.Visible", False) ' Shortcut notation ' In VBA => Forms!myForm!myControl.Visible = False