Hi :) Thanks Andreas and Peter for saving my bacon there! Now we have 2 good ways to do it :)) Thanks and regards from Tom :)
On 5 November 2014 18:36, Andreas Säger <[email protected]> wrote: > 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: [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 > > -- To unsubscribe 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
