[libreoffice-users] Re: Libre Office Base

2015-07-19 Thread Alex Thurgood
Le 17/07/2015 15:50, Ian Whitfield a écrit : Hi Ian, > This does not work - You can enlarge the box but this only creates a > larger gray area round two sides of the Check Box which keeps it's > original size!!?? Yes, this is a longstanding known limitation of the tickbox control object. It can

[libreoffice-users] Re: Libre Office Base

2015-07-19 Thread Andreas Säger
Am 19.07.2015 um 06:33 schrieb Peter Goggin: > > For my current needs I have found Libre Base more than adequate. Indeed, I have no important office document that is not connected to some type of database -- one way or the other, dBase, HSQL server, csv, spreadsheet or H2 SQL. My users are ver

[libreoffice-users] Re: Libre Office Base

2015-07-18 Thread Andreas Säger
Am 18.07.2015 um 05:51 schrieb toki: > On 07/16/2015 09:03 AM, Andreas Säger wrote: > >> There are many more reasons why the query designer is completely >> inefficient and inadequate in the context of a relational database. > > What you are forgetting is that all of those functions are supposed

Re: [libreoffice-users] Re: Libre Office Base

2015-07-17 Thread Ian Whitfield
I posted this 2 days back but don't see it coming up on the Form - Let's try again . Hi Gabriele On 16/07/2015 10:45, Gabriele Ponzo wrote: /It is, more or less, in the GUI: You just have to open the Form's properties dialog box and correct the already present query (or insert, not sure

[libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 10:51 schrieb Andreas Säger: > Am 16.07.2015 um 09:15 schrieb Ian Whitfield: >> Hi Andreas >> >> On 15/07/2015 17:32, Andreas Säger wrote: >>> SELECT * FROM "Table" ORDER BY "what","you","want" >> Thanks - I was hoping there was a way to do this from the GUI!! >>> > > The GUI is a

[libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Andreas Säger
Am 16.07.2015 um 09:15 schrieb Ian Whitfield: > Hi Andreas > > On 15/07/2015 17:32, Andreas Säger wrote: >> SELECT * FROM "Table" ORDER BY "what","you","want" > Thanks - I was hoping there was a way to do this from the GUI!! >> The GUI is almost useless compared to the options that are provided b

Re: [libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Gabriele Ponzo
2015-07-16 9:15 GMT+02:00 Ian Whitfield : > Hi Andreas > > On 15/07/2015 17:32, Andreas Säger wrote: > >> SELECT * FROM "Table" ORDER BY "what","you","want" >> > Thanks - I was hoping there was a way to do this from the GUI!! It is, more or less, in the GUI: You just have to open the Form's prop

Re: [libreoffice-users] Re: Libre Office Base

2015-07-16 Thread Ian Whitfield
Hi Andreas On 15/07/2015 17:32, Andreas Säger wrote: SELECT * FROM "Table" ORDER BY "what","you","want" Thanks - I was hoping there was a way to do this from the GUI!! The database engine (MySQL) has zero influence on the tick boxes. OK understood - but is there any way to adjust their size?

[libreoffice-users] Re: Libre Office Base

2015-07-15 Thread Andreas Säger
Am 15.07.2015 um 17:21 schrieb Ian Whitfield: > Hi All > > I'm running two copies of LO Base here - and old one using HSQL embedded > and a new one using MySQL. > > Firstly I notice is that if I sort the DB the sort only holds for the > duration of the session. Is it possible to make a sort order