Access2Base, the API for Base users

×

Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs

Provider:
Jean-Pierre Ledure
Maintainer:
JPLED
Rating:
3

Average: 3 (2 votes)

Application:
Base
Tags:
basic, Base, scripting, macros, Programming, IDE, Comment, API, MSAccess, Access2Base
Post date:
Friday, 9 March, 2012 - 04:42
Statistics
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Yes
User feedback:
Compatible with OpenOffice 4.x?

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

Access2Base, the API for Base users

Version Operating system Compatibility Release date
1.9.0 System Independent 3.3, 3.4, 4.0, 4.1 12/08/2018 - 06:47 More information Download
1.8.0 System Independent 3.3, 3.4, 4.0, 4.1 07/02/2018 - 10:41 More information Download
1.6.0 System Independent 3.3, 3.4, 4.0, 4.1 18/02/2017 - 09:05 More information Download
1.5.0 System Independent 3.3, 3.4, 4.0, 4.1 04/08/2016 - 10:52 More information Download
1.4.0 System Independent 3.3, 3.4, 4.0, 4.1 17/01/2016 - 10:28 More information Download
1.3.0 System Independent 3.3, 3.4, 4.0, 4.1 26/07/2015 - 12:07 More information Download
1.2.0 System Independent 3.3, 3.4, 4.0, 4.1 08/02/2015 - 10:23 More information Download
1.1.0 System Independent 3.3, 3.4, 4.0, 4.1 01/08/2014 - 11:57 More information Download
1.0.0 System Independent 3.3, 3.4, 4.0 14/12/2013 - 08:35 More information Download
0.9.5 System Independent 3.3, 3.4, 4.0 30/08/2013 - 10:43 More information Download
0.9.1 System Independent 3.3, 3.4, 4.0 01/05/2013 - 09:17 More information Download
0.9.0 System Independent 3.3, 3.4 05/01/2013 - 06:34 More information Download
0.8.9 System Independent 3.2, 3.3, 3.4 05/10/2012 - 11:08 More information Download
0.8.6 System Independent 3.2, 3.3, 3.4 03/09/2012 - 14:59 More information Download
0.8.2 System Independent 3.2, 3.3, 3.4 15/08/2012 - 08:52 More information Download
0.8.1 System Independent 3.2, 3.3, 3.4 09/08/2012 - 15:43 More information Download
0.8.0 System Independent 3.2, 3.3, 3.4 20/07/2012 - 09:36 More information Download
0.7.5 System Independent 3.2, 3.3, 3.4 27/05/2012 - 14:51 More information Download
0.7.1 System Independent 3.2, 3.3, 3.4 28/04/2012 - 03:24 More information Download
0.7.0 System Independent 3.2, 3.3, 3.4 21/04/2012 - 10:59 More information Download
0.6.0 System Independent 3.2, 3.3, 3.4 07/04/2012 - 10:10 More information Download
0.5.1 System Independent 3.2, 3.3, 3.4 30/03/2012 - 05:03 More information Download
0.5.0 System Independent 3.2, 3.3, 3.4 09/03/2012 - 07:07 More information Download