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



On 09/16/2014 05:05 AM, Tom Davies wrote:
Hi :)
The Base Handbook might be able to help with this
https://wiki.documentfoundation.org/Documentation/Publications

First it is worth quickly skimming through the "Getting Started" guide's chapter on Base.

There is also an Faq that might lead you through something very similar
https://wiki.documentfoundation.org/Faq

It is generally better to base such "reports" or "forms" off Queries rather directly off Tables. It makes the system more flexible for the future as it allows changes in the underlaying Table to be abstracted away so that the Form/Report can still get the same inputs that it expects.
Regards from
Tom :)



On 16 September 2014 08:42, L. D. James <ljames@apollo3.com <mailto:ljames@apollo3.com>> wrote:

    Can someone tell me how to link Libreoffice Writer to a
    LibreOffice Base
    Database so that opening the saved label file will automatically
    bring up
    any changes that has been made to the database without any prompts.

    At present I either see a way to bring up a saved mail merge file
    that will
    bring up the same data (old if the database has changed), or will
    bring up
    the pre-merged file that needs to have the sequence to use the
    mailmerge
    tool to update the information.

    These are the current steps I have to do to see or print the new data:

    Click on Merge file -> Answer the prompt to get the most recent
    data  (now I
    have one page of the first record) -> Click Tools -> Mail Merge
    Wizard ->
    Next -> Next -> Next -> Next -> Next -> Next -> (click) Save starting
    document -> Finish

    Now I have the updated data.

    I'm hoping to have a way to save a file where one click on the
    file will
    bring up the updated data without any prompts.

    Thanks in advance for any input on this.


Thanks for the links, TomD.

I had done a lot of research and reading the FAQ before posting my message. It might be possible that what I was trying to do can't be done (a one click to bring the fresh data to a labeling merge).

I put the objective in to words the best way I could. There is a chance I might not be describing it the best way. I was hoping someone in the community might understand the question well enough to maybe assist me in clarification as well as how to do it if it could be done, or some close workaround.

I really don't have any problems with the 6 to 10 clicks to print a new list. I was mainly trying to make it easy for office workers with little computer and data skills to perform a single click and have the new data and print a new labels.

As you suggested I'll study closer the features of LibreOffice Base for setting up the objective in forms. I already undestand that it can be done that way. But again, I was looking for a way to perform this in LibreOffice Word because I wanted to use the same feature for using linked fields in other databases such as mysql.


If I learn of a better way to clarify this task, I'll update the thread.

Thanks again for the input, as well as input from anyone else that might have some insight on this.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

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