Sorry - My mistake. Thanks Piet!!
On 08/26/2017 09:27 AM, Piet van Oostrum wrote:
Ian Whitfield <whitfi...@blinkmail.co.za> writes:
Hi All
I have been watching this thread and hoping a problem I have with this
might be mentioned!!
I produce a monthly "Journal" and also mak
Hi All
I have been watching this thread and hoping a problem I have with this
might be mentioned!!
I produce a monthly "Journal" and also make use of the TOC to list the
contents. It works fairly well (with a bit of editing) but the one
problem I have is as follows.
The first two pages of
If you use Thunderbird for your eMail add the extension "ReminderFox" -
It does this kind of thing perfectly!!
On 04/24/2017 07:13 PM, charles meyer wrote:
My esteemed listmates,
I’m wondering if in Libre Writer or Calc a user can set up a sound or
pop-up notification of an approaching
*Thanks Cley*
That did it for me - It was not the 'Local' or the 'User Profile' that
was out - but thanks to others for the suggestions!!
It was just the convoluted (IMHO) way that LO works to achieve this.
I my World I would suggest that a better way to do this is to have a
"Default" set of
Hi All
I have a MAJOR problem setting some defaults in LibreOffice!!
The first one is the Default Font - I have battled with this for some
time now and discussed it on the Forum and tried ALL the suggestions but
can not get rid of 'Liberation Serif' as the default!! This should be a
quick
*Thank you, Thank you Piet and Brian*
That did it - Magic!! Just what I wanted. You have made my frequent use
of Calc so much better!!
I still think it is a convoluted way of doing things but I'm very happy
to have the answer at last.
With much appreciation!!
Ian
Pretoria RSA
On
*Thanks Everyone*
I seem to have stirred-up a real Hornets Nest here - but to me it just
shows how badly this part of LO is!!! It's a GREAT program except for
this problem and of course the orphan child Base!!
Anyway - still no luck here - I tried the Side-Bar method first of all
but my
Bar for Templates or Edit Templates. So where do you find this and
edit it??
This should be as easy to do as it is in Scribus!!! Why make things so
difficult??
Thanks all
On 02/20/2017 06:27 PM, Piet van Oostrum wrote:
Ian Whitfield wrote:
> *Thanks Bruce*
>
> BUT that does
b select your desired font.
You might want to save this as a template and use as your default template.
On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield <whitfi...@telkomsa.net>
wrote:
*Hi All*
_PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!!
I have tried ma
*Hi All*
_PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!!
I have tried many times to do this, Googled lots of suggestions but
NOTHING WORKS!! And there are many different sets of instruction on how
to do this. It is one of the most frustrating things in LO Calc and
Thanks Guys - Appreciated!!
But I'm confused. The Handbook says Calc can be used as the datasource
for a Form in Writer.
But even Alexander's method still gives me no option to select the
Registered Spreadsheet (The options box remains empty)!!
The other replies tell me Calc can _NOT_ do
*Hi All*
I need some help with Forms for LO.
I have a Spreadsheet of Data and I have prepared a Form in Writer to
display and edit this information.
As per "Getting Started with LO", Chapter 15 I select - New - Database,
Connect to existing DB, select the Spreadsheet and Register it
I then go
*Hi all*
*Re: The LO Base discussion* - just my "Penny's Worth"!!!
After a 5+ years effort to use LO Base I have given up completely!! It
is *NOT* usable at all in it's "out of the box" set-up, ie with the HSQL
engine. It is totally unstable, crashes frequently AND - *MORE
IMPORTANT* -
Hi all
I'm trying to use LO Base - linked to a Spreadsheet and so far all is
going well.
However I don't seem to be able to get Dropdown Boxes to work. On my
'User Form' they are greyed out and do not react when clicked. I have
set them to be Dropdown, entered the list of options and set the
Hi Alexander
On 03/17/2016 05:59 PM, Alexander Thurgood wrote:
So Alexander has told me how to save my Form (that helps a lot) and I
>decided to get back into Base as it seems to be the only way to go for
>me. But MySQL is giving me up-hill. It does not seem to want to save an
>empty Table for
Hi Alex
On 03/10/2016 01:11 PM, Alex Thurgood wrote:
Why not separate out your forms from the ODB file if you are concerned
about the stability of the ODB file itself ? It is perfectly possible,
you can still link to a mysql db and you won't have the issues of
screwing up your ODB just because
Thanks Dan and Alan
I know about the Base > Calc link but I have been using Base since about
2010 and had many, many crashes where in most cases the crash takes out
the data as well and you need to spend hours and hours re-building the
Database and re-designing your Forms etc. This has
Hi All
I was thinking the other day about using Calc as a Flat File Database -
ie with no relationships.
Many users make use of a Spreadsheet as a kind of Database but the
problem is viewing the data.
So I was wondering if there is and Add-On or Extension available to give
you a "Form" to
Hi All
I have been trying to import a CSV file from Calc into MySQL to run with
Base for over a week now and can not believe this is so difficult to do
so I'm hoping some other Base users might have cracked this one!!
My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
Hi All
I take from the lack of any replies to my post of a few days back that
either anyone who can help out is still on Christmas Holidays or this
just can not be done ??
Ianw
Pretoria RSA
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Hi All
I have another table of data that I would like to link to an existing Form.
The Form was originally linked to Table "ABC" but I now want to link it
to table "Name/DEF".
Is this possible and how would I do this please??
Thanks for any help
(I'm using PClinuxOS and LibreOffice 5.0.0.2
Thanks Alex
Sorry have been away from the computer for some days due to work and
other personal reasons!!
I seem to be getting somewhere but I sit with the problem that the DB
will not accept the old username and/or Password.
Is there a way to reset this at all??
--
To unsubscribe e-mail
Up-date
I have been busy with other things and just got back to this problem.
I found that the link to the Class file was not working so corrected
that and the whole set-up now works fine.
But when I try to open the Database it opens the input Form and pops up
an error -
"The data content
On 10/22/2015 03:31 PM, Alexander Thurgood wrote:
Is the mysql server actually running ?
mysqld is running, (start on boot) in Services.
Is your JDK recognized by LO (Tools - Options - Advanced) ?
YES- /usr/lib/jvm/java-1.8.0-sun-1.8.0.60/jre
--
To unsubscribe e-mail to:
Thanks Alex and Dan.
I had forgotten to do that - so have downloaded 5.1.37 and set it up in
LO but I still get the same error.
I notice also that when checking Services I have no htppd available to
switch on!!??
Any other ideas please?
Thanks a lot.
--
To unsubscribe e-mail to:
Hi All
Due to problems with Kernel updates I have rebuilt my system using the
last ISO disk I had, (2014-12).
I re-installed the ISO formatting the complete drive, updated the system
via Synaptic to bring it up to date and restored all my backed-up data
to /home. I then restored the MySQL
/On 26/07/2015 14:50, Erik Jan wrote://
/
/To tell you the truth: I still use my slide rule, very easy and
useful for calculations that need only to be about 95% accurate with
the correct order of magnitude. I even once corrected errors in an
Excel spreadsheet with the help of my log tables
_**_
*Hi All
*After 25+ years in the Computer business I retired in the early 2000s.
I had been involved with CP/M, DOS and Windows during this period and
even did a Xenix Course at one time which I found interesting, (Unix was
a propitiatory name in those days!!). I also played with Coral
I couldn't find a good OCR solution for linux either. Project for
someone?
Cheers
Harvey
I also battled to find a good OCR program for a couple of years on my
Linux System (PClinuxOS)!!
Then about two years or eighteen months back I came across the
combination of YAGF with Tesseract.
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
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 stick.
ie - I sort into Lastname then First Name and
Ditto!!!
+1
It has cemented the decision I took last year to move to Base+MySQL -
which works very well indeed!!
IanW
Pretoria RSA
On 03/05/2015 04:08 PM, HBarr wrote:
Just want to say this thread has been so helpful and enlightening, I have
learned a lot about base, mysql and databases.
Hi Peter
Noted on your comments and others
I can confirm that using the embedded DB in Base is a disaster - I
battled with it for a couple of years until I found out about using an
external engine - I use MySQL and have had _NO_ problems, (except my own
finger problems!!) since then.
Thanks Alex and Paul!!!
We have cured the problem!!
Alex - your correction still gave me the SQL Error as before.
Paul - your correction was on the nail!! Worked like a charm and my
RecordID now Auto-Increments!!
I appreciate GREATLY all this help guys!! As I mentioned I'm not - and
don't
On 02/22/2015 03:20 PM, Alex Thurgood wrote:
You could try using :
ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY;
Thanks Alex
I gave this a try in MyAdmin and got ...
Error
*SQL query:*
||
|ALTER TABLE Members CHANGE RecordID1 INT
Thanks Alex
But I fear this is getting nowhere.
As per your suggestion I built a new ODB file and it showed the same
problem.
i have run the MySQLcheck program and it confirms the DB is OK.
Maybe it is a funny in Base itself??? And it may come right with the
next release??
In itself the
Hi Alex
I really appreciate your help here!!
But still no luck - My replies are below.
A quick, alternative possibility :
Create a new ODB file that connects to your database. Save it under a
new name.
Open the newly named (and currently empty, at least with regard to
forms, queries,
On 02/20/2015 04:47 PM, Alexander Thurgood wrote:
Try mysqlcheck -A -p
Thanks for the explanation Alex. This is what I get .
FedSaints.Members OK
mysql.columns_priv OK
mysql.db OK
Hi All
I've spent today trying to cure this problem.
I have only ONE table in my Database and needed to make the RecordID
field Auto-incrementing. (I forgot when I set it up)
Using the Base Front End it will *NOT* change the setting - as soon as
you save it reverts to 'No'
Using
On 02/18/2015 05:35 PM, Alexander Thurgood wrote:
Le 18/02/2015 15:23, Ian Whitfield a écrit :
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called 'id'. And this is now
working fine and Auto incrementing. I deleted the old
*Hi All*
I have been rebuilding/revamping my Database over the past few weeks and
everything has been going great.
I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called
Hi All
I have been running a MySQL Database with LO Base as a front-end for
some time now -
and VERY successfully indeed compared to the built-in engine in LO Base!!
(My OpSys is PClinuxOS 32-bit)
For a variety of reasons I decided to rebuild my system last week. I
have a back-up of my
I had to add the /usr/bin/thunderbird and then it worked fine.
But I agree this should be automated some how.
My OpSys is PClinuxOS
IanW
Pretoria RSA
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
*Hi All*
Since I upgraded to LO 4.3.4 I have a problem with LO Manager!!
Whenever I start it it shows the error -
/Please close your package manager 'synaptic' //
// and then run LibreOffice Manager again.//
//
// Exiting../.
Synaptic is _*NOT*_ running - So am unable to update the
*Thanks Paul - answers below ...*
On 12/08/2014 05:18 PM, Paul D. Mirowsky wrote:
This sounds like LO Manager is calling to synaptic twice.
Did you confirm synaptic is not running by process status command ps
that includes all processes before starting LO Manager? /*- YES NOT
RUNNING*/
Try
Hi Regina
On 11/13/2014 09:13 PM, Regina Henschel wrote:
Hi Ian,
try this:
1. menu File New HTML Document. Now you should have an
HTML-source-icon between ABC-icon and Print-Preview-icon. If it is not
there, see below.
2. menu Insert Document.
3. Click on the HTML-source-icon. You have
Hi All
Can I get some help on this please??
I have read about, and looked-up, the possibility of editing HTML
documents in Writer but can not get it to work!!
No matter what I do I can not fine 'HTML Mode' or 'View HTML' as talked
about ion the help files.
I can load my document but can not
saving your document, select HTML Document (Writer) (.html) in
the File type: drop down list in the Save dialog.
Kolbjoern
Den 13.11.2014 11:18, skreiv Ian Whitfield:
Hi All
Can I get some help on this please??
I have read about, and looked-up, the possibility of editing HTML
documents
Thanks all.
Well it looks as if the PClinuxOS version of LO has omitted or taken out
this function. No matter which way I open the file I get _NO_ option in
'View' that has anything to do with HTML!!
I even tried a 'Save as selecting HTML and still no luck. (Although
doing this changed the
On 11/13/2014 05:28 PM, Brian Barker wrote:
At 17:03 13/11/2014 +0200, Ian Whitfield wrote:
Well it looks as if the PClinuxOS version of LO has omitted or taken
out this function. No matter which way I open the file I get _NO_
option in 'View' that has anything to do with HTML
On 11/03/2014 11:44 AM, Tom Davies wrote:
Can other people try on other systems? Mint and other Debian family
probably have the same result as me. Someone in the thread already tried
with Fedora. So ideally if you are using something else it might help
more. Windows anyone? ;)
Loads
On 10/30/2014 11:02 PM, Virgil Arrington wrote:
On 10/30/2014 04:12 PM, Paul wrote:
On Thu, 30 Oct 2014 12:53:09 -0700 (PDT)
Andreas Säger ville...@t-online.de wrote:
And Tom is a phony idiot who knows nothing.
I hope that you personally know Tom very well, and know that he is ok
with you
On 09/28/2014 11:53 AM, Paolo Debortoli wrote:
a debian user has written on a mailing list that differently from version 4.2, in
the last 4.3.2.1 version the ordering function (right click - sort) in calc is
not working yet (I haven't verified it by myself at the moment actually).
It works
On 08/04/2014 04:15 PM, dave boland wrote:
On Mon, Aug 4, 2014, at 09:10 AM, Jean-Francois Nifenecker wrote:
Le 04/08/2014 14:51, dave boland a écrit :
How does switching to Firebird solve the issue of an embedded, all in
memory database? I would be happy if LO offered an option (when
Hi All
I'm using a lot of IF functions in my Spreadsheets to limit DIV and NAME
errors with rows that don't have values in them yet.
I came across a situation today where I need to test text - ie I need to
test for a month's name.
I tried =IF(Cell Ref=AUG,do calculation.)
But this gives
On 07/29/2014 10:45 PM, Brian Barker wrote:
The only thing wrong with your example is the dot separating the
second and third arguments - which presumably should be a comma. There
is nothing in the basic structure you are illustrating here that would
stimulate a #NAME? error, so the problem
On 07/11/2014 04:21 PM, dave boland wrote:
Thank you Noel. I will check this out. My head is spinning right now
with all of the choices. I need to get something together for next
Fri., so I'm going with LO Base for now. Seems like a decent choice
because I will be the only user for most of
Hi All
I have several of Spreadsheets that work with monthly figures. They also
have columns with calculations of these figures. (ie Totals, averages
etc). At the moment I get a lot of 'DIV by Zero' results and the current
total repeating BELOW the current month.
Is there a way to only show
On 07/09/2014 11:28 AM, Brian Barker wrote:
Yes: there is the IF() function: is that a close enough equivalent?
Just put
=IF(condition;expression-for-true;expression-for-false) .
Your expression for false may well be consecutive double-quote marks,
representing the null string.
Thanks Brian
On 07/09/2014 12:23 PM, Brian Barker wrote:
Yes - but you don't say what the controlling factor might be. There
must be some aspect of the list that indicates the point at which you
want the totals to stop. Instead of using
=X100-X99
you need something like
=IF(condition;X100-X99;)
with
+100 Wolfgang!!!
I fell in the same hole!!! PostgreSQL or MySQL is the ONLY way to go.
IanW
On 05/05/2014 05:44 PM, Wolfgang Keller wrote:
I'm new user of LO Base, we are transitioning from MS Access, and I
need to redesign our db from it.
One word of advice based on experience:
Avoid use
On 02/13/2014 08:04 PM, Tom Davies wrote:
Hi :)
I think some people here do read the manuals
https://wiki.documentfoundation.org/Documentation/Publications
But i agree that it might be good for certain people (mostly thinking
about me tbh) to dip in and read-up even on just 1 feature per week
Hi All
I'm looking for someone to help me out with a serious and URGENT
mySQL/LO Base problem please.
I prefer to do it Off-List but am happy to post the end result on the
Forum later. I did write to Alex Thurgood directly but got no reply -
maybe he's busy of away??
My direct eMail is
Hi All
I've been using the Base/MySQL combination since mid-last year now and
it is fantastic!! It is much faster, never crashes or freezes and just
works the way it is supposed to. I can definitely recommend it to
anyone!! (In my opinion this should be the standard and HSQL should be
Sorry All
I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55
A MySQL 'expert' was telling me recently that HSQL is only meant to be a
prototyping utility and should *NEVER* be used for any proper work - -
interesting!!??
I can confirm that when it crashes it takes everything
On 04/12/13 16:48, whatever wrote:
Tom Davies wrote
You can double-click on the line between the row
headers to make it auto-adjust the height of the row.
THANKS TOM!!
I've been wanting this function for a long time and could not find it.
BTW - I think you mean auto-adjust the WIDTH of
Thanks for the comments Tom
You are right - I was meant to send it to the Scribus Forum but I
selected the wrong eMail address!!
My Bad as they say these days!!
Regarding your comments - what you say makes a lot of sense.
All the best
--
To unsubscribe e-mail to:
Hi all
I've been looking for a way to index my monthly Journal I edit in Scribus.
I have managed to get the Scribus function working, (after a battle),
but two problems remain.
1) In all my Paragraph Styles the 'Fill Character' is greyed-out!!
How do I activate this?
2) The created Index is
Hi All
I've had some success at last!!
Using Shane Piper's Tutorial at
http://www.youtube.com/watch?v=TcudVETPePY I have got my sub-Forms
working fine.
My last problem was with Opening a Form with a Button and again Shane
has a Tutorial on this at http://www.youtube.com/watch?v=9Zmd-zidIvg
On 15/10/13 22:41, Andrew Douglas Pitonyak wrote:
If I remember correctly (and I have not looked at this in a while), I
think that you need to link the master and slave fields.
So, if you open your form in edit mode, load the form navigator, right
click on your sub-form and choose
Hi All
I'm still stuck with LO Base Sub Forms!! I've been at this for some
time, off and on, but over the past few months I have been very busy
converting, editing and checking/updating my DB to now run on MySQL.
I must say it is a GREAT improvement!!
OK - My OpSys is PClinuxOS 2012-10. LO
Thanks to all for the input - appreciated!!
Pedro contacted me directly and has put me right and I now have it
working 100%.
He picked up my error and said The trick is that the 'Pitch' means the
label width PLUS any following space whereas I was putting in only the
gap between the labels,
Hi All
After some time working on other aspects of my Database I'm back to
trying to get a Pushbutton working to open a SubForm.
PClinuxOS 2013.08; LO Base 4.1.1.2; MySQL 5.1.55
My Database - FSNew
Tables - Members Story
Forms - FSNew.Members FSNew.Story
The Pushbutton on the Members Form
Thanks to Andrew and Mark for their input
I thought about this over the past few days and did not want to wind
back to the earlier version of LO and have the problem of getting the
link to my SQL Database working again.
So yesterday afternoon I came up with a Workround!! I converted all the
Hi Andrew
On 05/09/13 23:09, Andrew Douglas Pitonyak wrote:
Is it possible that the form is in edit mode? As in, you are editing
the control? It is a long shot guess...
On 09/05/2013 04:47 AM, Ian Whitfield wrote:
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
On 06/09/13 10:58, Alexander Thurgood wrote:
Le 05/09/13 10:47, Ian Whitfield a écrit :
Hi Ian,
Has anyone seen this effect or got any idea how to fix it please??
This has also been reported on the French users mailing list. Sounds
like a bug to me.
So how do we, or can we, report
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
upgraded my LO Office to 4.1.2.
Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or
add to them. If you click on one a tick appears in the box but as you
select
FIRST POST DID NOT SEEM TO GET THROUGH - RE-SENDING ...
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
upgraded my LO Office to 4.1.2.
Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or
add to them. If
Hi Noel
On 29/08/13 06:12, Marion Noel Lodge wrote:
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3. Click on the Data Tab
4. The contents field
Hi Noel
On 29/08/13 06:12, Marion Noel Lodge wrote:
Hi Ian,
With a Form, I have found the following is the way to lock in the Form's
sort order -
1. Open the Form in Edit mode
2. Right click on the form and from the dropdown choose Form...
3. Click on the Data Tab
4. The contents field
Thanks Jay
On 26/08/13 15:54, Jay Lozier wrote:
Ian,
Is there an id key field? If there is the default sorting is by the id
key (usually numerical order).
In SQL you can add the line:
ORDER BY Last-Name, First-Name
The default order is ascending (ASC) if descending is needed
ORDER BY
Hi All
I now have my new MySQL/LO Base Database up, running and fully edited
from the old one. And what a pleasure it is to work with!! This IS the
way to go,
One question - It seems to have a strange way of sorting the Data as
displayed in the Form I designed and I have to select 'Sort' in
Hi All
Very interesting article on using variables in LO that I just came
across. Worth a read
http://www.techrepublic.com/blog/opensource/three-great-ways-to-use-variables-in-libreoffice-and-openoffice/4446?tag=nl.e101s_cid=e101ttag=e101ftag=
IanW
Pretoria RSA
--
To unsubscribe e-mail
Thanks to everyone who has helped me out in the last week or so -
appreciated!!
It's fantastic to have a Forum like this, (as is the Scribus Forum that
I also use).
A week or so back I asked about 'Searching in a Column' so thanks to
Suo, Tom and Luuk for that help - Not exactly how I would
Hi All
I have LO 3.6.5.2 on PCLOS 2013
Is it possible to do the following in Calc??
I have two list of names (and other data) side-by-side in a Spreadsheet
and I want to Split the Spreadsheet vertically to show the LH part on
the left and the RH part on the right.
This I can do but the two
On 17/06/13 13:20, Regina Henschel wrote:
Do not use split or freeze options, but from the menu 'Window' the
item 'New Window'. You get a new UI, but on the very same document. So
the content changes in one Window will be in the other window too.
That are not two documents but only one
Hi All
Is it possible to get Calc to search/Find in a specific column??
I have a three column list of names, (A=First, B-Surname, C=Former
Name), with about 3000 entries and want to get the Search function
(CTRL-F) to look in just the specific column related to the Search. I
have tried to
Thanks to everyone on this!! Appreciated!!
On 07/06/13 11:52, Luuk wrote:
On 07-06-2013 11:35, Suo Kunlong wrote:
06/07/2013 05:07 PM, Ian Whitfield :
Hi All
Is it possible to get Calc to search/Find in a specific column??
I have a three column list of names, (A=First, B-Surname, C=Former
Hi All
I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
front-end - all on PCLOS 2013.
I've been messing around since late last year getting this all right,
(with lots of GREAT help from the Forum!!)
My question now is - Where does MySQL store the Database and how do
Hi All
I have a Database with about 3000 addresses in it and need - from
time-to-time - to check how many different Countries are listed in it.
I have a Query that extracts this for me but naturally it pulls out
EVERY entry for EVERY Country.
Is there a way for a Query to do this BUT only
Thanks Noel !!!
On 25/05/13 11:58, Marion Noel Lodge wrote:
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM your Table name
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax
Error'!!
On 14/05/13 10:52, acanela wrote:
What´s the problem? What sould I do?
I have the feeling that the solution is easy, but I can't find it. I mean
for italics and bold in BASE.
Set-up your requirements in your Form ..
Select Form (Right-Click) Edit
Control-Click on any Field
Then Double-Click
Hi All
I'm sure Alex is right - so thanks for pointing out the 'bits' that
don't work from Base!!
As a plain ordinary - everyday Front-End I have so far found Base to
be adequate... so far (??) But I note the comments made. Must say I've
been busy with other things for some days and have
On 12/05/13 13:30, Tom Davies wrote:
Hi :)
That is a good question.
Ultimately the Tables 'should' be in MySql (or whichever back-end you are
using). One thing i don't know is if you can use the nice GUI front-end in
Base to create the Tables and find the Tables are automatically in the
Hi All
Tom says ...
I'm fairly sure that quite a few people have had troubles with the internal
back-end that were solved by 'just' moving to an external back-end. I vaguely
remember someone even suffering data-loss using the embedded/internal back-end.
Was there a bug-report? Should
Hi All
Question regarding LO Base, (being used as a Front End to a MySQL
Database). (PCLOS, LO 3.6.5.2)
I have eight 'Check Boxes' on my Form that work just fine but I find
them a little small and can find no way to make them larger. I tried
pulling them out and changing the Font size but
On 30/04/2013 12:43, Ian Whitfield wrote:
Is there a way of adjusting the Check Box size at all?
On 30/04/13 14:54, Fernand Vanrie wrote:
The model must have a Height and Width property ?
Changing this only seems to enlarge the background colour. The Check
Box itself DOES
Thank you Dan and Alex!!!
This is the kind of help I was needing to understand the problem. I knew
one of you DB Boffins would point me in the right direction.
Dan I will try your method but first I must investigate what Alex says
about MyISAM and InnoDB.
So - That leaves me now with two
Thank you both (Dan and Alex)
I will follow these routes.
Appreciate the help!!
IanW
Pretoria RSA
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
Hi All
I posted the question below on the 13th but have seen no comments or
replies.
Surely someone has an idea or a thought on this??
Thanks a lot.
On 13/04/13 17:29, Ian Whitfield wrote:
Hi All
You will have seen my question to Noel about Relationships and his reply.
I just tried again
1 - 100 of 209 matches
Mail list logo