Forum Home | Log in | Signup | My Page | Rules | FAQ | Boards | Members | Search
« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Free Download of New Edition of Designing with Libre Office

By: Fiz in 6TH POPE | Recommend this post (0)
Mon, 21 Nov 22 5:12 AM | 27 view(s)
Boardmark this board | 6th Edition Pope Board 		Msg. 37631 of 60008
(This msg. is a reply to 37630 by Zimbler0)
Jump:
Jump to board:
Jump to msg. #

It sounds to me like you are a guru!

If you get a chance to play with BASE, I would appreciate hearing about your experience.

http://help.libreoffice.org/6.2/en-US/text/sbasic/guide/access2base.html?DbPAR=BASIC#bm_idA2B001

What is Access2Base?

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".

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.

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).
Warning Icon

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


- - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Re: Free Download of New Edition of Designing with Libre Office
By: Zimbler0 in 6TH POPE
Mon, 21 Nov 22 4:11 AM 		Msg. 37630 of 60008

Yeah,
I downloaded 'BASE' . . .

Having used Access for years (possibly decades) both as an 'end user' and in developing applications for my job use . . .

And Access also makes use of 'Visual BASIC' . . meaning any application code that can be done in BASIC could be 'rear-ended' into an Access form or report.

Access was (and I assume still is) VERY Powerful.

Access could also be used as a 'front end application' to a Sequel Server DataBase.

But, being retired now. I really only have one application in Access I 'need' to run. And I have an old XP machine to run an old Office Suite and it gets that job done.

Having downloaded BASE . . . And installing it . . . And never doing anything with it since . . .

Anyway.
Good Night Sir.

Zim.

« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next