how to build data base for form openoffice base

Use the Form Navigator to get to the form/sub form events. Now for the event, on the form (or sub form) where entering the record, use: OObj1 = oForms.getByName('YOUR_INTERNAL_FORM') Most often this situation uses a list box.Īs for the code, you can simply obtain the control and refresh it: oDrawPage = ThisComponent.getDrawPage() I think it would be best to leave questions like this open so it can be extended and answers voted on, to make it an even better resource for students.)Īs for the actual question, not certain why you are using a combo box. But even they are not complete, nor that useful. This might seem like an obvious question that needs no answer here. How is the best way to quickly and comprehensively learn to use LibreOffice Base? There are more examples in the module called Sandbox in the extension library-these are the tests I run during development.To learn LibreOffice Base are there introductions or tutorials? English If parameter is not passed, it tries to get a the top data form of the active form document (if the ThisComponent refers to a form document).ġ) get model of form control: Model=MeModel.getByName('txtFirstName')Ģ) set form filter: RunCmd.ApplyFilter 'FirstName='Charles''ģ) run sql command and get result: Result=RunCmd.RunSQL ('SELECT *FROM Employees')

There are two functions MeModel(optional event param) and MeController(optional event param) which give you a reference to the active form model/controller. However, note that this variable can be changed easily if any other process, or your macro, activates a different OOo component/document.

Generally, the access starts from a form document-the form document being the global variable ThisComponent. To initialize the database variables used throughout the extension, there are 3 optionsġ: Databases.InitFromDocument(document_name_or_url)Ģ: Databases.InitFromDocument(db_doc_object) -example: Databases.InitFromDocument(ThisDatabaseDocument)ģ) Databases.InitFromEvent(Event_Object) -where event object is event parameter in macro bound to form/form control In case you still need help: The extension is best suited for use by macros that are event handlers for a db/db object element (such as data forms and controls in a data form). I am sorry I had not responded-it seems the message did not get forward to my email.

How to build data base for form openoffice base