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

2014-11-05 Thread Peter Goggin
but in many other areas I found LibreBase to be more intuitive and than MS Access. I was able to convert my data bases from Access to LibreBase with all of the functionality the original Access databases, including reports, and in some cases with improved functionality. Regards Peter Goggin

Re: [libreoffice-documentation] Date manipulation

2014-10-26 Thread Peter Goggin
have a problem between 15th Dec to 15th January, but since I will not need to generate the report in this time period the code will work. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-

[libreoffice-documentation] Date manipulation

2014-10-25 Thread Peter Goggin
I want to set a date range in a query to be between TODAY -10 Days and TODAY + 10 days. Is there a simple way to do this? Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-15 Thread Peter Goggin
I have reviewed and uploaded this chapter. I would be grateful if you could adjust the tasks page to reflect this. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks - Review

2014-10-14 Thread Peter Goggin
or each record in the View_Group. The query need to be modified to SELECT DISTINCT ''Surname“ , …... The modified query (page 12)can easily be either added to or substituted for the existing query. I have no idea how to deal with the form interactions on page 5. I have consid

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-11 Thread Peter Goggin
Regards Robert In the examples on page 5 it uses a push button linked to the Updateform function. I cannot find this function. I assume that it is a standard macro somewhere to which you add the name of the form to be updated. Where can I find it? Regards Peter Goggin -- To unsub

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-11 Thread Peter Goggin
On 12/10/14 08:35, Peter Goggin wrote: On 12/10/14 04:12, Robert Großkopf wrote: Hi Peter, Thanks. I will have a look at the sample data bases. It is possible that I can translate the field names to English equivalents. If I do should I add the table definitions as an appendix to the chapter

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-11 Thread Peter Goggin
relate to which parts of Chapter 8. Once I have done this I will test the code, and put in a reference to the exaple data base. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-11 Thread Peter Goggin
Regards Robert Thanks. I will have a look at the sample data bases. It is possible that I can translate the field names to English equivalents. If I do should I add the table definitions as an appendix to the chapter? Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr.

[libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-10 Thread Peter Goggin
I am working through this chapter. In many cases I am having to design tables to match the code samples. Are there any sample database tables for this chapter? If so where can I download them? Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr

[libreoffice-documentation] Base Handbook Chapter 8 -Database tasks

2014-10-06 Thread Peter Goggin
I have down loaded this chapter to work on. As I still cannot modify the status page would you please make the necessary adjustments to the web page. Thanks in advance Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http

[libreoffice-documentation] Base Hndboork Ch 5 Queries.

2014-10-06 Thread Peter Goggin
sort out my error. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@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

Re: [libreoffice-documentation] Base Handbook

2014-10-06 Thread Peter Goggin
On 07/10/14 13:15, Peter Goggin wrote: On 05/10/14 04:27, Tom Davies wrote: Hi :) Blimey! Does that mean you have signed the Queries chapter back in already?? or are you just thinking ahead? Either way congrats! Should i edit the wiki-page to show a change of status? Regards from Tom

Re: [libreoffice-documentation] Base Handbook - Reports

2014-10-06 Thread Peter Goggin
to add the new ones at the end. I still cannot update the status in the task page. I will work on the macros chapter next. Could yo please mage the necessary changes to the task status page. Thanks Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org

Re: [libreoffice-documentation] Base Handbook Chapter 5 Queries.

2014-10-04 Thread Peter Goggin
On 04/10/14 21:37, Peter Goggin wrote: On 04/10/14 21:13, Dan Lewis wrote: On 10/03/2014 11:24 PM, Peter Goggin wrote: While working through the documentation I appear to have found a problem. The following query works: SELECT "ID", "Title", "Pub_Year" FROM

Re: [libreoffice-documentation] Base Handbook Chapter 5 Queries.

2014-10-04 Thread Peter Goggin
On 04/10/14 21:13, Dan Lewis wrote: On 10/03/2014 11:24 PM, Peter Goggin wrote: While working through the documentation I appear to have found a problem. The following query works: SELECT "ID", "Title", "Pub_Year" FROM "Media" It returns 8 rows. The f

[libreoffice-documentation] Base Handbook - Reports

2014-10-03 Thread Peter Goggin
This is listed as Chapter 6 but does not exist in the page for downloading for review. Is there any indication when this chapter will be ready for review? Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org

[libreoffice-documentation] Base Handbook Chapter 5 Queries.

2014-10-03 Thread Peter Goggin
sion is the one from the ubuntu repository and claims to be version libreoffice-base 1:4.2.6.3-0ubuntu1. I presume this means it is 4.2.6.3 and therefore should not have the LIMIT limitation. If I need to load a later version of the data base where do I get it from? If this problem is

Re: [libreoffice-documentation] Base documentation - Forms

2014-10-03 Thread Peter Goggin
On Fri, Oct 3, 2014 at 4:16 PM, Jean Weber mailto:jeanwe...@gmail.com>> wrote: > On Friday, October 3, 2014, Peter Goggin mailto:petergog...@bigpond.com>> wrote: >> >> On 03/10/14 13:48, Jean Weber wrote: >>> >>> Peter, >&g

Re: [libreoffice-documentation] Base documentation - Forms

2014-10-03 Thread Peter Goggin
On 03/10/14 20:26, Jean Weber wrote: On Fri, Oct 3, 2014 at 4:16 PM, Jean Weber wrote: On Friday, October 3, 2014, Peter Goggin wrote: On 03/10/14 13:48, Jean Weber wrote: Peter, You were able to log in to ODFAuthors and upload the file, so your user name is clearly valid. I just checked

Fwd: Re: [libreoffice-documentation] Base documentation - Forms

2014-10-02 Thread Peter Goggin
Should be chapter 5 for Queries. Regards Peter Goggin Forwarded Message Subject:Re: [libreoffice-documentation] Base documentation - Forms Date: Fri, 03 Oct 2014 14:37:19 +1000 From: Peter Goggin To: documentation@global.libreoffice.org CC: Jean Weber

Re: [libreoffice-documentation] Base documentation - Forms

2014-10-02 Thread Peter Goggin
e page where I cannot edit or change the fields in the table. If I try to log on using my ODF login it says I am not a user. How can I change the status of files in this page? I have downloaded the Queries chapter (4.2 Chapter 6 Queries) and will work on this Regards Pet

Re: [libreoffice-documentation] Base documentation - Forms

2014-10-02 Thread Peter Goggin
On 02/10/14 04:03, Dave Barton wrote: Original Message From: Peter Goggin To:Documentation@Global.LibreOffice.Org Date: Wed, 01 Oct 2014 18:40:00 +1000 I have worked through chapter 4 - forms on the Base documentation. Apart from a minor concern relating to the

Re: [libreoffice-documentation] Base documentation - Forms

2014-10-01 Thread Peter Goggin
, until I have used them one or two times. Thanks in advance Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

[libreoffice-documentation] Base documentation - Forms

2014-10-01 Thread Peter Goggin
but it has been many years since I have been involve in a large team and I do not want to screw anything up. Thanks in advance Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to

Re: [libreoffice-documentation] Base Forms - and subforms

2014-09-29 Thread Peter Goggin
On 30/09/14 01:11, Mark Stanton wrote: Have you checked the contacts table directly? I wouldn't mind betting that you *have* been able to add contacts, but they don't have the people primary key. I think you'll need to do some extra work manually (ie programming, not literally by hand) to get th

Re: [libreoffice-users] [Solved] Re: [libreoffice-documentation] Re: Base Document - Forms

2014-09-29 Thread Peter Goggin
On 29/09/14 18:26, Tom wrote: Hi :) Many thanks to Walther Koehler-4 and Paul-6! :)) Peter Goggin has been able to do the transfer. So i have copied all the answers in below to try to help make this easier to solve next time. Many thanks and regards to all! :) Regards from Tom :) Peter

[libreoffice-documentation] Base Forms - and subforms

2014-09-29 Thread Peter Goggin
something in the way I set up the form and subform. Am I right in assuming that I should be able to add new contacts to a person via the sub form? Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-documentation] Re: Base Document - Forms

2014-09-28 Thread Peter Goggin
ng this in parallel with the proper sample data bases. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/

Re: [libreoffice-documentation] Re: Base Document - Forms

2014-09-27 Thread Peter Goggin
stop me from continuing to reviews the documentation but it would be good to know how to import data , retaining the formatting and data types. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/ma

Re: [libreoffice-documentation] Re: Base Document - Forms

2014-09-26 Thread Peter Goggin
2014 04:56, Peter Goggin a écrit : Peter, 2. Do I need all of the optional extras? Off-hand, check that you also have the following packages : libreoffice-base-drivers libreoffice-report-builder libreoffice-report-builder-bin Alex -- To unsubscribe e-mail to: documentatio

Re: [libreoffice-documentation] Base Document - Forms

2014-09-20 Thread Peter Goggin
as described. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@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

Re: [libreoffice-documentation] Fwd: Writer 4.2 Guide Chapter 12 for review

2014-09-20 Thread Peter Goggin
I have found where to download the Base chapter on forms. I cannot see where to mark that I have down loaded it to review and correct. I am sorry for being a bit slow but I will eventually get the hang of your system. Regards Peter Goggin -- To unsubscribe e-mail to: documentation

Re: [libreoffice-documentation] review

2014-09-20 Thread Peter Goggin
esign. Please advise me where you think I would be most useful. Regards Peter Goggin -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documen

Re: [libreoffice-documentation] Fwd: Writer 4.2 Guide Chapter 12 for review

2014-09-20 Thread Peter Goggin
/Documentation/Development/UserGuideTasks Kind regards Sophie Le 20/09/2014 09:09, Jean Weber a écrit : I am no longer coordinating this group. Messages to the list are more likely to get a reply. I hope. -- Forwarded message -- From: *Peter Goggin* Date: Saturday, September 20, 2014 Subject

[libreoffice-documentation] subscribe

2014-09-18 Thread Peter Goggin
Subscribe -- To unsubscribe e-mail to: documentation+unsubscr...@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