Context English Arabic
access2base.xhp
bm_idA2B001
help.text
<bookmark_value>Access2Base</bookmark_value><bookmark_value>Microsoft Access; Access2Base</bookmark_value><bookmark_value>Access databases; run in Base</bookmark_value>
access2base.xhp
par_idA2B004
help.text
Access2Base is a LibreOffice Basic library of macros for (business or personal) application developers and advanced users. It is one of the libraries stored in "LibreOffice macros and dialogs".
access2base.xhp
par_idA2B005
help.text
The functionalities provided by the implemented macros are all directly inspired by Microsoft Access. The macros are callable mainly from a LibreOffice <emph>Base</emph> application, but also from <emph>any</emph> LibreOffice document (Writer, Calc, ...) where access to data stored in a database makes sense.
access2base.xhp
par_idA2B007
help.text
<emph>The library is documented online on </emph><link href="http://www.access2base.com" name="http://www.access2base.com"><emph>http://www.access2base.com</emph></link>.
access2base.xhp
hd_idA2B008
help.text
The implemented macros include:
access2base.xhp
par_idA2B009
help.text
a simplified and extensible API for <emph>forms</emph>, <emph>dialogs</emph> and <emph>controls</emph> manipulations similar with the Microsoft Access object model,
access2base.xhp
par_idA2B010
help.text
an API for database access with the <emph>table</emph>, <emph>query</emph>, <emph>recordset</emph> and <emph>field</emph> objects,
access2base.xhp
par_idA2B011
help.text
a number of <emph>actions</emph> with a syntax identical to their corresponding Microsoft Access macros/actions,
access2base.xhp
par_idA2B012
help.text
the <emph>DLookup</emph>, <emph>DSum</emph>, ... database functions,
access2base.xhp
par_idA2B013
help.text
the support of the shortcut notations like <item type="literal">Forms!myForm!myControl</item>
access2base.xhp
par_idA2B014
help.text
in addition
access2base.xhp
par_idA2B015
help.text
a consistent errors and exceptions handler,
access2base.xhp
par_idA2B016
help.text
facilities for programming form, dialog and control <emph>events</emph> and
access2base.xhp
par_idA2B017
help.text
the support of both embedded forms and standalone (Writer) forms.
basic_2_python.xhp
N0430
help.text
<bookmark_value>Basic;Calling Python</bookmark_value> <bookmark_value>API;SimpleFileAccess</bookmark_value> <bookmark_value>API;PathSettings</bookmark_value> <bookmark_value>API;XScript</bookmark_value>
basic_2_python.xhp
hd_id811571848401485
help.text
<variable id="basic2python"><link href="text/sbasic/guide/basic_2_python.xhp" name="Basic Programming Examples">Calling Python Scripts from Basic</link></variable>
basic_2_python.xhp
N0432
help.text
Calling Python scripts from %PRODUCTNAME Basic macros is possible, and valuable features can be obtained such as:
basic_2_python.xhp
N0433
help.text
<literal>ComputerName</literal> identification or <literal>OSName</literal> detection are possible,
basic_2_python.xhp
N0434
help.text
Basic <literal>FileLen()</literal> function and <link href="https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1ucb_1_1SimpleFileAccess.html" name="ucb.SimpleFileAccess">com.sun.star.ucb.SimpleFileAccess.</link><literal>getSize()</literal> API function exhibit a 2 Gigabytes file size upper limit that Python helps to overcome,
basic_2_python.xhp
N0435
help.text
<link href="https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1util_1_1PathSettings.html" name="util.PathSettings">com.sun.star.util.PathSettings</link> can be normalized,