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

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 <villeroy@t-online.de> 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: 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

-- 
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