Openoffice base list form to detail form9/12/2023 It can create a database with File → New → Database → Create a new database. It is a tool to access an external database from OpenOffice components like Writer, Calc, etc. New people often do not understand what Base is. I suggest that you work through some of the examples in the Base Guide so you can experiment a bit first. Base also has something called a form, but it is for data entry, not for display. Position (struct) position of control element ( .Martin Smith wrote:I used it in two ways - (a) With 'Lists' - where information was listed across the page - one below the other, and (b) in 'Form' View, where you could see the same information of each individual 'line' now displayed downwards on a single page.The Base Guide in the documentation link above will describe how to create a table (your 'List'), and a report (your 'Form'). Size (struct) size of control element ( .Size data structure) The control element shape, like all other shape objects, provides the Size and Position properties for this purpose: ![]() If this is true, the function ends the search.ĭetermining the Size and Position of Control ElementsĪs already mentioned, the size and position of control elements can be determined using the associated shape object. If this is the case, the Control.Name property then checks whether the name of the control element is MyListBox. The example checks all drawing elements to determine whether they support the .XControlShape interface needed for control element forms. Name = "MyListBox" Then Exit Function End If End If Next DrawPage (i ) If HasUnoInterfaces (Shape, ".XControlShape" ) Then If Shape. To determine a special control element, all drawing elements of the drawing level must be searched through.ĭim Doc As Object Dim Shape as Object Dim I as integerĭoc = ThisComponent For i = 0 to Doc. The method for accessing the shape objects of a control element also uses the corresponding drawing level of the document. With the help of this controller object and the model of the control element, it then uses the GetControl method to determine the view ( CtlView variable) of the control element form.Īccessing the Shape Object of Control Element Forms It uses not only the Doc document object but also the DocCrl document controller object which makes reference to the current document window. The code listed in the example is very similar to the code listed in the previous example for determining a control element model. ![]() GetControl (Ctl ) Exit Function End If Next I HasByName ( "MyListBox" ) ThenĬtlView = DocCrl. The models of the control elements of a form are available through the GetByName method of the Object form:ĭim Doc As Object Dim DocCrl As Object Dim Forms As Object Dim Form As Object Dim Ctl As Object Dim CtlView As Object Dim I as Integerįorms = Doc.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |