Attaching all logical forms to stand-alone office documents can give you quite a lot of advantages. You may also use the tabbed interface of Calc or Draw for your input forms.
1) You get form documents that can be opend by means of simple desktop links so you never see the database document. 2) The form documents or pages (sheets) in the same form documents can be connected by means of hyperlinks (switch boards without coding macros). 3) You can protect the form documents from modification by means of document protection (on file system level or document level). 4) In the tabbed Calc interface you can elegantly mix input forms with report sheets (enter invoice, print latest invoice, search invoice, also without any coding). The layout and print capabilities of Calc are good enough and it can easily do all sorts of calculation which are sometimes more difficult to do in a database. 5) All Base features always refer to a single data source. In stand-alone forms documents you can connect a form to a row set from database A and build a relation through a subform connected to a row set from database B. 6) The bug which leads to the thread does not occur Now for the only draw-back I'm aware of: The Writer documents embedded in the Base document store their own settings for window size, menu bars and view settings. When using stand-alone documents for input forms, the initial window sizes and view settings are the same as with any other documents of the same document type. Step-by-step instructions on how to save an embedded Writer form as a stand-alone Writer form: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=40493 It is possible to copy and paste forms into Calc or Draw and reconnect them as described in the tutorial linked above. -- View this message in context: http://nabble.documentfoundation.org/Defective-layout-in-Base-with-libreoffice-3-4-x-tp3303898p3310642.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
