Access2Base
What is Access2Base?
Access2Base adalah suatu pustaka makro LibreOffice Basic untuk para pengembang aplikasi (bisnis atau pribadi) serta para pengguna tingkat lanjut. Ini adalah salah satu dari pustaka yang disimpan dalam "Makro dan dialog 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.
API yang disediakan oleh Access2Base dimaksudkan agar lebih padat, intuitif, dan mudah dipelajari daripada API UNO standar (API = Application Programming Interface).

The library is documented online on http://www.access2base.com.
Makro yang diimplementasi termasuk:
-
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,
-
dukungan notasi singkatan seperti Forms!myForm!myControl
in addition
-
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.
Compare Access2Base with Microsoft Access VBA
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