Ask Your Question

Writer list box from base table

asked 2016-09-22 19:10:56 +0200

Dennis@realEstate gravatar image

Trying to create a list box in Writer and pull data from Base table. Can not find any documentation on how to do it

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-09-22 22:50:50 +0200

Ratslinger gravatar image

First make sure you database is registered. You cannot access databases that are not registered. This list is from menu Tools->Options->LibreOffice Base->Databases. If not listed, you can add it using New and point to the .odb location.

If not on already, turn on the Form Design toolbar (menu View->Toolbars) and then turn on Form Controls toolbar (floating toolbar). Select the List Box tool from the Form Control toolbar and on the document hold down left mouse button and drag to size the object.

If Wizards are ON you can follow that or do it yourself as follows.

Now you need to add information to the object. From the Form Design toolbar, click on the Form Navigator icon. You should now see this:

image description

Right click on Form and select Properties. image description

In the Data tab, Data Source select the database where the table is located. Content Type should be Table and in Content select the table which contains the data for your list. The form is now set so close properties.

From the Form Navigator right click on the List Box 1 (unless you renamed it) and select Properties.

image description

Again from the Data tab, set Data Field to the column where you values are, Type of list contents to Sql, use the ellipsis to the right of List content to set the column for the data list, and finally set Bound field to 0 (signifying the first field).

If all went right, click on Toggle Design Mode on the Form Design toolbar and your list box should be filled.

edit flag offensive delete link more

answered 2016-09-22 20:42:09 +0200

ratrace gravatar image

updated 2016-09-22 21:26:46 +0200

If you can't see toolbars Form Controls and Form Design choose View->Toolbars->Form controls and View->Toolbars->Form design, so that you will have the right toolbars, for what you want to do.

  1. In the Form design toolbar choose Toggle design view icon.
  2. From the Form design toolbar choose Form navigator icon and right click in word "Forms".
  3. Choose New->Form.
  4. Right click on the new form you inserted in the previous step, choose properties and select your Data source.
  5. From toolbar Form controls insert the object you like (list box).
  6. Again in Form Navigator, below the new form you inserted, you can see the object list box, right click on it and insert the properties you want.
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-22 19:10:56 +0200

Seen: 373 times

Last updated: Sep 22 '16