Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Am 05.11.2014 um 02:51 schrieb Mark LaPierre:
Hey Tom,

It would be nice to post the solution here on the string that is
labelled "[Solved]" so that people searching for the solution can find
it.  Maybe Peter should do that since he seems to have a better grip on
the solution.


The clean solution without macros:

1) Open an embedded form document and save it as a regular Writer document.
2) Close the form and load the new document from the new location.
3) Turn on edit mode, get the form design toolbar and click its 5th
button for the form navigator.
4) Get the main form's properties dialog, second tab "Data".
5) Copy the "Source" string first.
6) Unlike the embedded form, this one has a "Data Source" property.
Choose the registered name of your data source or use the [...] button
to pick the database file. (registration has several advantages).
7) The "Source" property is wiped out when you change the data source
but you have it in the clipboard. Paste it back into the "Source" box.
8) Repeat 5) to 7) for all the forms and subforms on the same form document.
9) Save and close the form document and make the file read-only.

Now you can open the form document just like any other document without
loading the database document and you can add ordinary hyperlinks to
switch between form documents. Of course, you can use desktop hyperlinks
too.
In rare cases you may use another option that is not availlable with
embedded forms: Subforms can be bound to data sources other than the
main form. For instance your subform may show all the database records
related to the main form's selected record that is stored in a spreadsheet.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.