You should see in the Label Text box, and the insertion point should be just after that.Ĭhange "Database Field" to "LastName", and click the right pointing arrow to the left of that listbox again.Ĭhange "Database Field" to "Addr1", and click the right pointing arrow to the left of that listbox again.Ĭhange "Database Field" to "Addr2", and click the right pointing arrow to the left of that listbox again.Ĭhange "Database Field" to "City", and click the right pointing arrow to the left of that listbox again. In a later step, you even get to give the "registered" database a name of your choosing.įor "Database Field" select "RestOfName" (Or some other field, if you too are not working with FDB004), and click the right pointing arrow to the left of that listbox. odb file, "by hand", after it's initial creation.Ĭure: In Libre Office (any module!) Tools/ Options/ LibreOffice Base/ database, I deleted the old "FDB004", and then used the "New" button.Īll "new" needed was for me to browse to the. That would be a first suspect.) Just use a different table, if you too, are having problems with FDB004 as a source.ĭigression: I subsequently figured out the problem over my "FW004" "registered" database. But I found another database that DID have suitable material! (The FDB004 did seem to be "registered". At 27 Oct 20, when I tried this with a database that "should" have "worked", no tables were admitted to. When you've done that, if you click on the "Table" drop down, you should see the tables in that database. (In Libre Office terms, the database is (quite rightly) all of the tables, forms, reports, etc, associated with the data you are using.) Over in the "Database" listbox, select FDB004, if that is not already selected, and NameAddr for the "table". that's for filling the box with your return address, as stored within Libre Office. If so, get rid of them.ĭo not tick the "Address" box. The labels tab may have scraps of things you've tried already in the "Label Text" box. Get Libre Office Writer running, but with no documents open. So let's make mailing labels from FDB004 ("Free Data Base". Pretty fancy ones, perhaps, but Writer documents, none-the-less. which is a delight, when you've mastered it: Base's reports are actually Libre Office Writer documents. You should also see FDB004: C:\My Documents\FreeDB\FDB004\FDB004.odb These things arrived along with Base, when you installed it. You'll probably see some strange things there in places I wouldn't have put them, e.g. The list of what's registered (and the name it is registered under) can be found via Tools | Options | LibreOffice Base | Databases. For now, if you're carrying on from the "First Table" tutorial, your copy of Base should "know" about the database it needs. You'll want to learn more about this another time. it is better than what I'm used to, in some ways, but if you've used databases before, beware assumptions you may make!įirst "oddity": Libre Office maintains a list of "registered" databases. Libre Office takes an approach to database work which was not intuitive for me. But it doesn't cover sorting or filtering. If you want a more concise exposition, you might prefer my other page about printing address labels. It also shows you how to apply filters to the records on display in a table, and how to sort them. Complete that first, if you want to try the things described below. This page describes how Libre Office can be used to produce sheets of address labels from the database set up during the course of my "First Table" tutorial. ( Do switch to Firebird, when and as you can!) Not every graphic was updated. Overhauled 25 Oct 20 to make it right for LibreOffice Base using embedded Firebird. Page contents © TK Boyd, Sheepdog Software, 2/06-10/20. (Enlarge, reduce, restore to default, respectively.) (This is fully explained, and there are more tips, at my Power Browsing page.) With most browsers, pressing plus, minus or zero while the control key (ctrl) is held down will change the texts size. Make your browser window as wide as you want it. There's more about Base in the main index to this material. And making things easy for users on different platforms. and saving million$, but still Getting The Job Done. Big organizations, governmental and civilian, have adopted it as their standard office suite. Remember that Libre Office, including its database app, "Base", is free. You may find that the database included in LibreOffice / OpenOffice delights you as much as it has me. Sorting, Filtering Page URL: fdb1addrlab.htm Also valid for Open Office Base Printing Address Labels TABLE OF CONTENTS for version 2 Libre Office / Open Office database "Base" tutorials.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |