Access2Base, the API for Base users

This extension implements a AOO/LibO Basic library for Base applications.
The API is entirely inspired by VBA for MSAccess and its object model.

It helps people either to migrate their Access applications to Base OR to write macros as if it was MSAccess/VBA OR to write their first macros.
It is documented (online) in detail.
It is much more intuitive and easy to learn than the standard UNO API.

Access2Base is a standard feature of LibreOffice.
Access2Base 1.9.0 (= current and last version) is integrated within LibreOffice 6.1.
The version 1.9.0 is the last version that will be made available for OpenOffice. Further versions will be made available only for LibreOffice.

The implemented macros include (among a huge list of functionalities):

1. forms, dialogs and controls manipulations derived from the MSAccess object model
2. an API for database access with the table, query, recordset and field objects
3. actions with a syntax identical to their corresponding MSAccess macros/actions
4. the DLookup, DSum, ... database functions
5. the support of the shortcut notations like Forms!myForm!myControl
6. a consistent errors and exceptions handler
7. facilities for management of form and control events

The macros using the API may be stored both in Database documents (".odb" files) and in standalone (Writer/Calc/...) forms. It is even possible to access data from Calc formulas.

ONLINE DOCUMENTATION HERE ...
DOWNLOADABLE EXAMPLES HERE ...

Compare Access2Base with MSAccess VBA

OpenOffice/LibreOffice Base with Access2Base


REM Open a form ...

Docmd.OpenForm("myForm")

REM Move a form to new left-top coordinates ...

Dim ofForm As Object
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