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

2014-11-05 Thread Peter Goggin
The solution to getting LibreBase to open with a particular form 
involves several steps:

1. Create a macro
/Sub Menu_Main( )
Dim ObjTypeWhat
Dim ObjName As String
ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.FORM
ObjName = MainMenuForm 'The name of the form you want to open at Base 
start-up, this needs to exist.
If ThisDatabaseDocument.FormDocuments.hasbyname(ObjName) Then 'Check the 
form exists
ThisDataBaseDocument.CurrentController.Connect() 'If the form exists 
connect to the database
ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, 
ObjName, FALSE) 'Open the form

Else
MsgBox This is embarrassing, sorry, can't find the requested form to 
open!+chr(10)+Form Name =   ObjName + chr(10)+Check the details. , 
48, DS4A SBM encountered a problem!

End if
End Sub/
2. Call the macro when the data base is opened:
From the top tool bar  select: Toolscustomiseopendocument
Add macro Main_menu to this selection.

When the data base is opened there is a delay of about 1 second before 
the form named in the macro opens.
This isn't quite as fast as Access, 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



On 05/11/14 12:51, Mark LaPierre wrote:

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.

On 11/04/14 04:33, Tom Davies wrote:

Hi :)
Peter has let me know, off-list, that he solved the problem.  Details are
sketchy (ie i didn't understand) but he's working on the Base Handbook at
the moment so this is a distraction.


Anyone who fancies their chances of being able to proof-read a chapter or 2
would be a huge help in getting the Base Handbook published more quickly.

Most chapters have been reviewed (tested for technical accuracy) already
and been kinda proof-read once but a final round of proof-reading would
help reassure those who have been involved with getting the guide/handbook
this far.

There are still a few chapters that need reviewing but it's tough work so
just proof-reading those already done would be great and could be done by
almost anyone.

Regards from
Tom :)



On 3 November 2014 21:40, Tom Davies tomc...@gmail.com wrote:


Hi :)
Has anyone had any luck trying to find the thread Noel was referring to?
Is it possible to give a link to specific threads?

Has anyone here been able to convert a database from Access?

Has anyone been able to set-up a database file so that when it opens it
goes straight to a main form instead of into a design view?  Is this
something that might be better done using a form that is made in Writer?

Regards from
Tom :)





On 27 October 2014 09:26, Marion  Noel Lodge lodg...@gmail.com wrote:


Hi Peter,

This question was asked recently.  If you go to -
  http://www.libreoffice.org/get-help/nabble/
and search for How to open a particular form at startup you will find
the
thread.

Noel
--
Noel Lodge
lodg...@gmail.com

On 27 October 2014 19:08, Peter Goggin petergog...@bigpond.com wrote:


I have completed the conversion of my Access contacts data base to
LibreBase. The only problem I have not solved is to get the database to
open with my main menu form. This could easlly be set in MS Access ut so
far I cannot find the mechanism for doing this in Base.  Is rhere a way

of

doing this? Or do I have to open the data base and manully select the

for i

want to start with?

Regards

Peter Goggin

--
To unsubscribe e-mail to: users+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/users/
All messages sent to this list will be publicly archived and cannot be
deleted


--
To unsubscribe e-mail to: users+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/users/
All messages sent to this list will be publicly archived and cannot be
deleted








--
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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-documentation] Date manipulation

2014-10-26 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-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-10-14 Thread Peter Goggin

I have completed the review of this chapter. I have a couple of problems:

Page 5

The description of the two forms and their interaction with the views, 
tables etc is not clear. I was able to follow it up to the creation of 
the forms. However the document uses *Update form*function. I was unable 
to find this in the Actions part of the menu. I could only find *Refresh 
Form.*


The description in this section really does not make it clear what the 
object of the exercise is.


I have been working with databases for about 30 years, and have never 
needed to use filtering of this type and have so far not been able to 
understand what the purpose is.


Page12

The only other problem I had was with the final query on page 12;

SELECT Surname,

( SELECT Firstname FROM View_Group WHERE Surname = a.Surname 
AND GroupNr = 1 ) ||
IFNULL( ( SELECT ', ' || Firstname FROM View_Group WHERE Surname = 
a.Surname AND GroupNr = 2 ), '' ) ||
IFNULL( ( SELECT ', ' || Firstname FROM View_Group WHERE Surname = 
a.Surname AND GroupNr = 3 ), '' ) ||
IFNULL( ( SELECT ', ' || Firstname FROM View_Group WHERE Surname = 
a.Surname AND GroupNr = 4 ), '' ) ||
IFNULL( ( SELECT ', ' || Firstname FROM View_Group WHERE Surname = 
a.Surname AND GroupNr = 5 ), '' )AS Firstnames

FROM View_Group AS a

This returns a row for 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 considered making the change to the query on Page 12 and adding a 
reviewers comments at the end of the document. Any advice on dealing 
with this will be gratefully received.


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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-10-11 Thread Peter Goggin

On 11/10/14 18:49, Robert Großkopf wrote:

Hi Peter,


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?

There are many example-databases for the German Handbuch. Please have a
look here:
https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base
It is called Beispieldatenbanken ohne Beschreibung (example-databases
without description).
For the Handbuch 4.3 are some databases described in details:
Beispieldatenbanken mit Beschreibung.

Problem: All the databases are in German language, except the databases
media without macros and media with macros, which were added to the
English handbook.

I will try to translate the databases - but not yet. Could be for the
handbook 4.4.

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...@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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-10-11 Thread Peter Goggin

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?

Wouldn't it be better to add the databases as it has been done for the
German Handbuch? So you could create little examples and link to this
example with see exampledatabase_birthday.odb ore something like this.

Regards

Robert

What I am trying to do is to confirm that someone following the examples 
will get the correct results. There are no results given in the chapter 
and it is difficult to confirm the code snippets really work. I have no 
doubt they do, but in more than 30 years working with data bases I 
cannot recall ever having to resort to data filtering with filter tables 
etc. I assumed that this SQL had been tested against a data base and so 
what I was looking for was a sample database containing the 
Filterexamples, MediaExample tables etc so that I could check the 
contents of these tables.  I have down loaded the data bases as you 
suggested and so I am now trying to identify which ones 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-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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?

Wouldn't it be better to add the databases as it has been done for the
German Handbuch? So you could create little examples and link to this
example with see exampledatabase_birthday.odb ore something like this.

Regards

Robert

What I am trying to do is to confirm that someone following the 
examples will get the correct results. There are no results given in 
the chapter and it is difficult to confirm the code snippets really 
work. I have no doubt they do, but in more than 30 years working with 
data bases I cannot recall ever having to resort to data filtering 
with filter tables etc. I assumed that this SQL had been tested 
against a data base and so what I was looking for was a sample 
database containing the Filterexamples, MediaExample tables etc so 
that I could check the contents of these tables.  I have down loaded 
the data bases as you suggested and so I am now trying to identify 
which ones 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

Having looked at the large number of test data bases it would take me 
much too long to identify the correct ones. I will continue with 
constructing a simple data base to test the SQL code. I am happy to send 
you this data base if it will help.


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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-10-11 Thread Peter Goggin

On 11/10/14 18:49, Robert Großkopf wrote:

Hi Peter,


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?

There are many example-databases for the German Handbuch. Please have a
look here:
https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base
It is called Beispieldatenbanken ohne Beschreibung (example-databases
without description).
For the Handbuch 4.3 are some databases described in details:
Beispieldatenbanken mit Beschreibung.

Problem: All the databases are in German language, except the databases
media without macros and media with macros, which were added to the
English handbook.

I will try to translate the databases - but not yet. Could be for the
handbook 4.4.

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 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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[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...@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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] Base Handbook - Reports

2014-10-06 Thread Peter Goggin

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

I have uploaded the revised version or the Queries chapter.   I have 
included English screen shots aqt the end of the document, three for 
page 17 and two for page 18. I have not replaced the originals.  For two 
of the shots (P18) the originals have an arrow pointing  a field on the 
screen shot. I was not able to do this so I decided 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
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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

I have uploaded the revised version or the Queries chapter.   I have 
included English screen shots aqt the end of the document, three for 
page 17 and two for page 18. I have not replaced the originals.  For 
two of the shots (P18) the originals have an arrow pointing  a field 
on the screen shot. I was not able to do this so I decided 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
I have have made a mistake. I accidently uploaded the queries form and 
called Ch 4 forms.  Can any one help me sort this out?



What should I do now?

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[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://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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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 following query fails
SELECT ID, Title, Pub_Year FROM Media LIMIT 5
The error complains about 5 being an unexpected token.

I created the query in both design and sql view and get the same 
result. I repeated with several tables  and got the same result and 
problem.


I found that if I used sort on a field then no matter where I created 
the query (design or sql mode it worked)


The documentation implies that this is a problem from earlier 
versions of the data base, prior to 4.1. and also the limit could 
only be set in direct SQL mode.  I can set the limit in both modes 
but as stated an order field condition is rquired.My version 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 a bug where do I report it?

Regards

Peter Goggin

 I ran the same query without any problem using 4.2.6.3 that I 
downloaded from the LibreOffice web site. I also use Ubuntu as my OS 
(12.04) so yours should have worked.

 A couple of possible problems though:
1)  Did you download Media_with_Macros.odb or Media_without_Media.odb 
and run create the query in one of these, or did you use the database
 you created? (If the latter, there might be a problem with your 
database.)
2) The LibreOffice distributed by Ubuntu has been modified from the 
version distributed on the LibreOffice web site. This error could be 
caused
 by a bug introduced by the modification process. This has been 
known to happen down through the years and has happened in a variety 
of distributions of Linux.


For #1, you should download the English version of the database 
file mentioned in the Query chapter. (It probably does not matter 
which one.) Create and run the query. If you still get the error, the 
problem is with the Ubuntu version of LibreOffice.
 For #2, I always remove the Ubuntu version of LibreOfficeusing 
Synaptic first when I install a newer version of Ubuntu. Then I 
download and install the versions including the help packs that I want 
from the LibreOffice web site. The menu will only show the Ubuntu 
version unless you do it in this order. Once the Ubuntu version is 
deleted, all version installed from the LibreOffice web site appear in 
the menu.
 Right now I have LibreOffice 4.2.6.3 and 4.3.2.2 installed, and I 
use both versions for a variety of purposes including testing them for 
how Base works in both of them. Specifically, I can check the problem 
you have had with both versions or even 4.2.7.1.


Dan

I down loaded the sample data base Media_with_Macros.odb or 
Media_without_Media.odb. I was using the without version.  As I am 
checking the documentation I am using the sample data bases rather than 
my own since the samples in the documentation come from the ample 
databases. It appears the ubuntu version of LibreBae is the cause of the 
problem.


I am not quite sure how I do what is required to get the proper version 
of the LibreBase software. (By the way as you know in ubuntu it does not 
come bundled with LibeOffice but requires a separate download.


Many users of librebase on ubuntu will use the version in the ubuntu 
repository.  While I can obviously ( with some guidance) download the 
latest versions form the LibreOffice site, should I be checking the 
documentation against the ubuntu version or the official site version? 
Or do I need to check it against both?


There are a number of linux distributions which bundle LibreOffice in 
the installation. Do all of these have the same sort of problems as Ubuntu?


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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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 Media
It returns 8 rows.
The following query fails
SELECT ID, Title, Pub_Year FROM Media LIMIT 5
The error complains about 5 being an unexpected token.

I created the query in both design and sql view and get the same 
result. I repeated with several tables  and got the same result and 
problem.


I found that if I used sort on a field then no matter where I 
created the query (design or sql mode it worked)


The documentation implies that this is a problem from earlier 
versions of the data base, prior to 4.1. and also the limit could 
only be set in direct SQL mode.  I can set the limit in both modes 
but as stated an order field condition is rquired.My version 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 a bug where do I report it?

Regards

Peter Goggin

 I ran the same query without any problem using 4.2.6.3 that I 
downloaded from the LibreOffice web site. I also use Ubuntu as my OS 
(12.04) so yours should have worked.

 A couple of possible problems though:
1)  Did you download Media_with_Macros.odb or Media_without_Media.odb 
and run create the query in one of these, or did you use the database
 you created? (If the latter, there might be a problem with your 
database.)
2) The LibreOffice distributed by Ubuntu has been modified from the 
version distributed on the LibreOffice web site. This error could be 
caused
 by a bug introduced by the modification process. This has been 
known to happen down through the years and has happened in a variety 
of distributions of Linux.


For #1, you should download the English version of the database 
file mentioned in the Query chapter. (It probably does not matter 
which one.) Create and run the query. If you still get the error, the 
problem is with the Ubuntu version of LibreOffice.
 For #2, I always remove the Ubuntu version of LibreOfficeusing 
Synaptic first when I install a newer version of Ubuntu. Then I 
download and install the versions including the help packs that I 
want from the LibreOffice web site. The menu will only show the 
Ubuntu version unless you do it in this order. Once the Ubuntu 
version is deleted, all version installed from the LibreOffice web 
site appear in the menu.
 Right now I have LibreOffice 4.2.6.3 and 4.3.2.2 installed, and 
I use both versions for a variety of purposes including testing them 
for how Base works in both of them. Specifically, I can check the 
problem you have had with both versions or even 4.2.7.1.


Dan

I down loaded the sample data base Media_with_Macros.odb or 
Media_without_Media.odb. I was using the without version.  As I am 
checking the documentation I am using the sample data bases rather 
than my own since the samples in the documentation come from the ample 
databases. It appears the ubuntu version of LibreBae is the cause of 
the problem.


I am not quite sure how I do what is required to get the proper 
version of the LibreBase software. (By the way as you know in ubuntu 
it does not come bundled with LibeOffice but requires a separate 
download.


Many users of librebase on ubuntu will use the version in the ubuntu 
repository.  While I can obviously ( with some guidance) download the 
latest versions form the LibreOffice site, should I be checking the 
documentation against the ubuntu version or the official site version? 
Or do I need to check it against both?


There are a number of linux distributions which bundle LibreOffice in 
the installation. Do all of these have the same sort of problems as 
Ubuntu?


Regards

Peter Goggin


I retried the queries using the withmacros version of the sample data 
bases. This refused to load cleanly until i enabled macros. Now the 
queries work correctly in both databases.


Regard

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] Base documentation - Forms

2014-10-03 Thread Peter Goggin

On 03/10/14 23:43, Tom Davies wrote:

Hi :)
I tried to fix it to show the right updated status of the 2 chapters 
in question.


I think it's correct?  Peter, is that correct now?
Regards from
Tom :)


On 3 October 2014 11:26, Jean Weber jeanwe...@gmail.com 
mailto:jeanwe...@gmail.com wrote:


On Fri, Oct 3, 2014 at 4:16 PM, Jean Weber jeanwe...@gmail.com
mailto:jeanwe...@gmail.com wrote:
 On Friday, October 3, 2014, Peter Goggin
petergog...@bigpond.com mailto:petergog...@bigpond.com 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 and you appear to
have the
 necessary permissions to change a file's status, so I don't
know why
 you can't. Don't worry about it; it's not stopping you from doing
 anything else. Anyway, there is no reviewed status for files
on the
 ODFAuthors website; we keep track of that on the wiki:



https://wiki.documentfoundation.org/Documentation/Development/UserGuideTasks#Status_of_tasks_BH_v4.2

 As for checking out another chapter, just download it from
ODFAuthors.
 Then put your initials in the Checked out column on the wiki
page I
 linked above.

 Yes, I know it's a slightly clunky system. We tried to do a more
 automated one several years ago, using a different platform,
but it
 didn't work out. (Long, boring explanation omitted here.) The
people
 actually doing the work at the time appeared to be happy with the
 system we're using. Of course, it may be time to change the
system, if
 enough people find it's a problem and want to do something
different.

 Lastly, I see there was no folder for Reviewed 4.2, so I have
created
 one and moved your reviewed file from Drafts 4.2 to the new
folder.
 Using different folders seems to help people keep track of
what stage
 a file has reached.

http://www.odfauthors.org/libreoffice/english/base-handbook/reviewed-4.2/

 --Jean

 This is the 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

 Peter Goggin.


 Which precise page are you attempting to access without success? You
 uploaded a file to ODFAuthors so you definitely have a working
login there.

 If you mean the LibreOffice wiki page, that is a different
website which
 uses its own login, separate from ODFAuthors. You should be able
to create
 your own login on the wiki: look for the link in the upper right
hand
 corner. You can use the same username etc when you create your
account
 there, if you wish.

 --Jean

Sorry, the wiki page referred to is actually on the Document
Foundation wiki, as shown in the URL.

--
To unsubscribe e-mail to:
documentation+unsubscr...@global.libreoffice.org
mailto:documentation%2bunsubscr...@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/documentation/
All messages sent to this list will be publicly archived and
cannot be deleted



Thanks, that looks ok to me.

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-documentation] Base Handbook Chapter 5 Queries.

2014-10-03 Thread Peter Goggin

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 following query fails
SELECT ID, Title, Pub_Year FROM Media LIMIT 5
The error complains about 5 being an unexpected token.

I created the query in both design and sql view and get the same result. 
I repeated with several tables  and got the same result and problem.


I found that if I used sort on a field then no matter where I created 
the query (design or sql mode it worked)


The documentation implies that this is a problem from earlier versions 
of the data base, prior to 4.1. and also the limit could only be set in 
direct SQL mode.  I can set the limit in both modes but as stated an 
order field condition is rquired.My version 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 a bug where do I report it?

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[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/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] Base documentation - Forms

2014-10-02 Thread Peter Goggin

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 and you appear to have the
necessary permissions to change a file's status, so I don't know why
you can't. Don't worry about it; it's not stopping you from doing
anything else. Anyway, there is no reviewed status for files on the
ODFAuthors website; we keep track of that on the wiki:
https://wiki.documentfoundation.org/Documentation/Development/UserGuideTasks#Status_of_tasks_BH_v4.2

As for checking out another chapter, just download it from ODFAuthors.
Then put your initials in the Checked out column on the wiki page I
linked above.

Yes, I know it's a slightly clunky system. We tried to do a more
automated one several years ago, using a different platform, but it
didn't work out. (Long, boring explanation omitted here.) The people
actually doing the work at the time appeared to be happy with the
system we're using. Of course, it may be time to change the system, if
enough people find it's a problem and want to do something different.

Lastly, I see there was no folder for Reviewed 4.2, so I have created
one and moved your reviewed file from Drafts 4.2 to the new folder.
Using different folders seems to help people keep track of what stage
a file has reached.
http://www.odfauthors.org/libreoffice/english/base-handbook/reviewed-4.2/

--Jean

This is the 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

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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 petergog...@bigpond.com
To: documentation@global.libreoffice.org
CC: Jean Weber jeanwe...@gmail.com



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 and you appear to have the
necessary permissions to change a file's status, so I don't know why
you can't. Don't worry about it; it's not stopping you from doing
anything else. Anyway, there is no reviewed status for files on the
ODFAuthors website; we keep track of that on the wiki:
https://wiki.documentfoundation.org/Documentation/Development/UserGuideTasks#Status_of_tasks_BH_v4.2

As for checking out another chapter, just download it from ODFAuthors.
Then put your initials in the Checked out column on the wiki page I
linked above.

Yes, I know it's a slightly clunky system. We tried to do a more
automated one several years ago, using a different platform, but it
didn't work out. (Long, boring explanation omitted here.) The people
actually doing the work at the time appeared to be happy with the
system we're using. Of course, it may be time to change the system, if
enough people find it's a problem and want to do something different.

Lastly, I see there was no folder for Reviewed 4.2, so I have created
one and moved your reviewed file from Drafts 4.2 to the new folder.
Using different folders seems to help people keep track of what stage
a file has reached.
http://www.odfauthors.org/libreoffice/english/base-handbook/reviewed-4.2/

--Jean


This is the 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

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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-documentation] Base documentation - Forms

2014-10-01 Thread Peter Goggin
I have worked through chapter 4 - forms on the Base documentation. Apart 
from a minor concern relating to the descriptions of the various options 
in the drop down menus I found that it was a good document, and would 
certainly be of help to people developing forms.   Owing to a disk crash 
 I have lost a number of e-mails relating to this project.

Would it be possible for someone  to advise me on
1. How to check the chapter back in
2. What chapter should I work on next?
3. How do I check out any new chapters I work on?
4. What are the links for downloading chapters?

Sorry to be a pain 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-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] Base documentation - Forms

2014-10-01 Thread Peter Goggin
Thanks for the instructions.  When I try to upload my file it asks for a 
title and then another field for description used in searches etc.


What do I put in these field?

Is the title the file name?

Again sorry for the trouble, but as I get older I have some difficulty 
in grsping new concepts, 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/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-documentation] Base Forms - and subforms

2014-09-29 Thread Peter Goggin
I am checking the functionality of sub forms. I have a main table for 
people and a second table for contacts made with the people. They are 
linked by the people primary key. For each person there can be a 
variable number of contacts. The main form shows the people and the 
subform shows the contacts. Every thing works, if I change the person 
the corect contact records are shown. However I cannot add new contacts 
to the subform.  I have recreated the data base a number of times and 
then recreated the form and subforms but I am not able to add new 
contacts. I presume I must be missing 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/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

I finally solved how to transfer the data from Access to Base. The steps
are very simple and work well. During the creation stage I did not
realize that while the Create button was available there was a Next
stage also available where the data types of the newly crated table
fields can be modified. (May be the Create button should not be
available until the data types have been checked) Setting the date
fields to date and the other fields to correct types solved the
problems. Since my ACCESS data base allows me to fully check the forms
documentation I will continue using this in parallel with the proper
sample data bases.

Regards

Peter Goggin



Walther Koehler-4 wrote

Hi,

export tables from MSACCESS as dbase  files in a proprietary directory.
Connect to that directory from LO-base.

Yours

Walther
snip /





Paul-6 wrote

I've got some experience with various databases, but little with
Access, sorry.

Given the OP exported the data from Access once, I'd assume that it's
possible to export to csv format instead of Excel spreadsheets, and I'd
recommend that. Then importing into Base should be straightforward, and
formatting shouldn't be lost. Access might even give some options for
the export formats, but worst case the data can be massaged in Calc
before importing into Base, say to change the date format.

If the OP is still having trouble with this, he can try posting a
couple of lines of the exported csv file, and we can see if there is a
reason Base is not importing it correctly.

This does sound like it should be possible with the method he is using,
but it's much harder for me to debug. If he's using plain csv files,
just posting a couple of lines would give me an idea of how the data
looks, and I could test on my machine, which does have Base, but not
Access.

And if he wants to go to MySQL/MariaDB/PostgreSQL, again using csv
files should be pretty straightforward, even if it does mean command
line and queries, and not a GUI interface. Although those exist, I'm
just not as familiar with them.

Paul

snip /





--
View this message in context: 
http://nabble.documentfoundation.org/Re-libreoffice-documentation-Re-Base-Document-Forms-tp4123900p4124035.html
Sent from the Users mailing list archive at Nabble.com.

I should have included details of my set up.  I am running ubuntu 14. on 
a lenovo laptop. I have windows xp and access installed in virtual box. 
I am hoping to be able to drop windows completely on this machine, since 
all I nee it for is the access databse.  I use shared directories to 
transfer data for windows to linux.


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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted



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 that to work.

This is based on a distant memory though, so I may be wrong.

Regards
Mark



The data in the two tables, people and contacts are the same as in my 
Access base. In the Access forms I can add contacts in the contact 
subform. In the Base forms when I change the person the contacts subform 
changes to match the person. When I checked the table definitions in 
Base I found that the primary key could not be made auto if there was 
data in the table. I deleted all of the data in the contacts table, 
changed the primary key definition and re-imported data. Now my forms 
work correctly.  One other thing, I found that if the spreadsheet format 
for date was not -MM-DD the import failed.


I now have a fully functional database which does all that I require and 
so can now drop virtualbox, windows XP and OfficeXP from this machine.


--
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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted



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

2014-09-28 Thread Peter Goggin
I finally solved how to transfer the data from Access to Base. The steps 
are very simple and work well. During the creation stage I did not 
realize that while the Create button was available there was a Next 
stage also available where the data types of the newly crated table 
fields can be modified. (May be the Create button should not be 
available until the data types have been checked) Setting the date 
fields to date and the other fields to correct types solved the 
problems. Since my ACCESS data base allows me to fully check the forms 
documentation I will continue using 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/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-09-27 Thread Peter Goggin
I am working through the documentation for the forms. To do this 
properly I needed a data base. As I have an access data base which I 
want to convert to Librebase I used this. I exported the tables from 
Access as Excel files, opened them in Librecalc, saved them in native 
librecalc format. I made sure the column definitions were correct for dates.


I copied the data cells and imported them into a Base table. I found a 
problem with all fields which were created as text.  If I change the 
date columns to date format I cannot save the new version of the base 
table without losing the date data. Is there any way of importing data 
and preserving the data format?


Many years ago using Oracle SQL I believe you could import text data 
into an already created table if your text data had been properly 
formatted. Is this possible with LibreBase?


Thanks for an advice.

This won't 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/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-09-26 Thread Peter Goggin

On 21/09/14 20:00, Tom Davies wrote:

Hi :)
Are you using Windows, Mac or Linux?  I am not sure how to do that in
Windows but in Linux it would be something like;

sudo apt-get install libreoffice-base-drivers

Rinse and repeat for the other 2.  In some distros you might need to
replace apt-get with something else, usually yum or something.
Alternatively just open a package-manager and have a look for those
packages/programs in there.

Sorry i have no idea how to check this in Windows! :(
Regards form
Tom :)





On 21 September 2014 09:38, Alex Thurgood alex.thurg...@gmail.com wrote:


Le 21/09/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: 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/documentation/
All messages sent to this list will be publicly archived and cannot be
deleted

I solve most of my problems with Base. I removed it and then did a full 
install with all of the extras, whether they looked as if they may be 
needed or not. I am now more than halfway through reveiwing the Forms 
chapter, checking that the documentation and the program match. Once I 
have a list of comments and suggestions I will e-mail them out.


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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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

2014-09-20 Thread Peter Goggin

On 20/09/14 18:30, Tom Davies wrote:

Hi :)
All the way at the bottom of that page
https://wiki.documentfoundation.org/Documentation/Development/UserGuideTasks#Base_Handbook
It looks like the Base Handbook has plenty of chapters ready to review.
For example chapter 4 about Forms is ready to review.

Gary Collins expressed interest in working on the Base Handbook too and
might want to take on Chapter 3 about Tables.


Jean or Sophie (or Alan or Dan)
Should i add a column for proof-reading?  I like the idea of skipping
proof-reading the Base Handbook for this version, in the interests of
expediency but now that it looks more possible should i add the column back
in?
Regards from
Tom :)



On 20 September 2014 08:41, Sophie gautier.sop...@gmail.com wrote:


Hi Peter,

The workflow for the guides is here, you can see what is currently work
on or need review, etc.

https://wiki.documentfoundation.org/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* petergog...@bigpond.com
Date: Saturday, September 20, 2014
Subject: Writer 4.2 Guide Chapter 12 for review
To: Jean Weber jeanwe...@gmail.com


On 20/09/14 13:21, Jean Weber wrote:


You can get it from here:
http://www.odfauthors.org/libreoffice/english/writer-
guide/drafts-v4.2/folder_contents



On Sat, Sep 20, 2014 at 12:38 PM, Peter Goggin petergog...@bigpond.com
wrote:


On 20/09/14 11:06, Jean Weber wrote:


The updated Chapter 12, ToCs, Indexes, Bibliographies is available
for review, along with other chapters.


http://www.odfauthors.org/libreoffice/english/writer-guide/drafts-v4.2/

This completes the draft book. As soon as chapters have been reviewed,
and revised as necessary, I will publish the chapters and compile the
full book. Please note that any major changes suggested (that is,
improvements rather than correcting errors) will probably be postponed
to the next update of the book. Improving the book is a very good
thing to do, but not at this stage of production... unless nobody
(except me) cares whether this book gets done in a reasonable time or
not. It's already very late.

--Jean

  How do I choose a chapter to review? I am particularly interested in

the

forms area and would like to review this chapter.

Regards

Peter Goggin


Sorry to be a pain but when I select a chapter how do I set so others

know

I am reviewing it and how do I tell if a chapter is under review?  My
interests cover both the forms side (gui fort end) and the data base
setting up tables, views queries etc.  As I was a database manager and
designer for many years I have spent many hours dealing with both the

front

end (gui user forms and controls) and the back end data base design.

Please advise me where you think I would be most useful.

Regards

Peter Goggin



--
Sophie Gautier sophie.gaut...@documentfoundation.org
Tel:+33683901545
Co-founder - Release coordinator
Certification Committee Member
The Document Foundation

I would certainly be happy to review the chapter on forms.  How do I let 
others know thta I am reviewing it , how do I down load the chapter? How 
do I submit corrections etc and then upload it?



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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] review

2014-09-20 Thread Peter Goggin

On 20/09/14 11:06, Jean Weber wrote:

The updated Chapter 12, ToCs, Indexes, Bibliographies is available
for review, along with other chapters.
http://www.odfauthors.org/libreoffice/english/writer-guide/drafts-v4.2/

This completes the draft book. As soon as chapters have been reviewed,
and revised as necessary, I will publish the chapters and compile the
full book. Please note that any major changes suggested (that is,
improvements rather than correcting errors) will probably be postponed
to the next update of the book. Improving the book is a very good
thing to do, but not at this stage of production... unless nobody
(except me) cares whether this book gets done in a reasonable time or
not. It's already very late.

--Jean

Sorry to be a pain but when I select a chapter how do I set it so others 
know I am reviewing it and how do I tell if a chapter is under review?  
My interests cover both the forms side (gui front end) and the data base 
back end setting up tables, views queries etc.  As I was a database 
manager and designer for many years I have spent many hours dealing with 
both the front end (gui user forms and controls) and the back end data 
base design.


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.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


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+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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-documentation] Base Document - Forms

2014-09-20 Thread Peter Goggin
When i bring up my version of LibreBase the menus are somewhat different 
to those in the documentation. I was unable to find the forms options 
described.  I downloaded my copy from the ubuntu repository.  It says it 
is libreoffice-base 1:4.2.6.3-0ubuntu1. There are a whole heap of 
optional extras which I did not download initially.


1. Is this the right version of the database software, i.e. the one the 
documentation is intended for?

2. Do I need all of the optional extras?

I intend to work my way through the document , page by page to ensure 
that whatever it says can be done works 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://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted


[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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted