LibreOffice 7.1 Help
Access2Base๋ (๊ธฐ์ ๋๋ ๊ฐ์ธ) ๊ฐ๋ฐ์ ๋ฐ ๊ณ ๊ธ ์ฌ์ฉ์๋ฅผ ์ํ ๋งคํฌ๋ก์ฉ ๋ฆฌ๋ธ๋ ์คํผ์ค ๊ธฐ๋ณธ ๋ผ์ด๋ธ๋ฌ๋ฆฌ์ ๋๋ค. ์ด๋ "๋ฆฌ๋ธ๋ ์คํผ์ค ๋งคํฌ๋ก ๋ฐ ๋ํ ์์"์ ์ ์ฅ๋์ด ์๋ ๋ผ์ด๋ธ๋ฌ๋ฆฌ ์ค ํ๋์ ๋๋ค.
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.
Access2Base๊ฐ ์ ๊ณตํ๋ API๋ ํ์ค UNO API(Application Programming Interface)๋ณด๋ค ๋ ๊ฐ๊ฒฐํ๊ณ , ์ง๊ด์ ์ด๋ฉฐ, ๋ฐฐ์ฐ๊ธฐ ์ฝ๋๋ก ๊ณ ์๋์์ต๋๋ค.
The library is documented online on http://www.access2base.com.
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.
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