From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/guide/access2base.xhp | 98 ++++++++++++++++++++++ 1 file changed, 98 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/guide/access2base.xhp (limited to 'helpcontent2/source/text/sbasic/guide/access2base.xhp') diff --git a/helpcontent2/source/text/sbasic/guide/access2base.xhp b/helpcontent2/source/text/sbasic/guide/access2base.xhp new file mode 100644 index 000000000..507a63c9d --- /dev/null +++ b/helpcontent2/source/text/sbasic/guide/access2base.xhp @@ -0,0 +1,98 @@ + + + + + + + + + + + Access2Base + /text/sbasic/guide/access2base.xhp + + + Access2Base topic first insertion, by Jean-Pierre Ledure + + + + +Access2Base +Microsoft Access; Access2Base +Access databases; run in Base + + Access2Base + What is Access2Base? + Access2Base is a %PRODUCTNAME BASIC library of macros for (business or personal) application developers and advanced users. It is one of the libraries stored in "Application macros and dialogs". + The functionalities provided by the implemented macros are all directly inspired by Microsoft Access. The macros are callable mainly from a %PRODUCTNAME Base application, but also from any %PRODUCTNAME document (Writer, Calc, ...) where access to data stored in a database makes sense. + The API provided by Access2Base is intended to be more concise, intuitive and easy to learn than the standard UNO API (API = Application Programming Interface). + The library is documented online on http://www.access2base.com. + The implemented macros include: + + + 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, + + + the support of the shortcut notations like 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 + + + -- cgit v1.2.3