[libreoffice-users] Re: [Solved] Re: Setting Base to open with a slected form

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