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: Zimbler0 in 6TH POPE | Recommend this post (0)
Mon, 21 Nov 22 6:49 AM | 32 view(s)
Boardmark this board | 6th Edition Pope Board 		Msg. 37632 of 60008
(This msg. is a reply to 37631 by Fiz)
Jump:
Jump to board:
Jump to msg. #

Naaah. A guru I never was.

I did write an inventory database program. In Access. Fairly simple. It kept track of all the shop spare parts, where they were, how many we had . . . Nothing gnarly in it.

A managers wife, once upon a time, had written the shop a 'Shop Log'. Where we would enter data on what repairs or maintenance we had done . . . Useful if everybody put the data in. Not everybody did.

Every time the company upgraded Microsoft Office I had to upgrade and test our databases. Sometimes it was easy, sometimes it wasn't. One of the bigger headaches was 'linked tables'.

I had a good time using Access to create forms with text boxes in them. I'd put numbers into the boxes then use Visual Basic to fish the numbers into the program, do some math on them then print the results back into the text boxes.

Then I got into Python programming.

And now that I'm retired that is slipping away from me.

As for BASE . . . I really don't have a need for it.

Zim.




Avatar

Mad Poet Strikes Again.


 - - - - -
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: Fiz in 6TH POPE
Mon, 21 Nov 22 5:12 AM 		Msg. 37631 of 60008

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


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