Re: [libreoffice-users] polish characters PDF problem

2013-01-11 Thread Fernand Vanrie
Gerard , maybe you are hit with the problem ( found for Windows XP) that LO only UTF-8 encoding support some fonts do not have this UFT-8 code page, so start to trie to use a font who is 100% compatible with UTF-8 or trie later Windows versions (7-8) hop it helps Fernand Hi everybody i

Re: [libreoffice-users] Re: Base scenario

2013-01-11 Thread Tom Davies
Hi :) So in the editing can you change the direction? or rather the way that the relationships works? Regards from Tom :)  From: Girvin R. Herr girvin.h...@sbcglobal.net To: Tom Davies tomdavie...@yahoo.co.uk Cc: Dan Lewis elderdanle...@gmail.com;

[libreoffice-users] Re: LibreOffice on Win2008 with RDP terminal services

2013-01-11 Thread Tom Johnson
I was able to resolve my problem. Here's what I learned. It appears that LibreOffice creates some sort of session/temp file within the user profile folder while LO is in use. The user profile folder was located in c:\users\username\appdata\roaming\LibreOffice\3. When more than one terminal

[Solved], Congrats! :) Re: [libreoffice-users] Re: LibreOffice on Win2008 with RDP terminal services

2013-01-11 Thread Tom Davies
Hi :) Blimey!!  Well found!  Hopefully that and other tricks are in the documentation for 'corporate' users https://wiki.documentfoundation.org/Documentation/Publications#Corporate_Users Sorry i didn't spot the question in good time! Apols, congrats and regards from Tom :) 

[libreoffice-users] Base: Action Queries

2013-01-11 Thread Tom Davies
Hi :)   I'm trying to re-build a database that has become unweildy in Access and because it's Access it lacks scalability and some of the functionality we expect of it.  I've exported a tiny part of the data, and ended up with 2 columns ClientID CompanyName Not all clients have a company name

[libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Alex Thurgood
Le 11/01/2013 21:28, Tom Davies a écrit : Hi Tom, I've exported a tiny part of the data, and ended up with 2 columns ClientID CompanyName Not all clients have a company name so there are a lot of blanks in the 2nd column. I've written a query to just show the non-blanks (=non-nulls) but now

Re: [libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Tom Davies
Hi :) Thanks guys :)  Ok, so i am starting out with the embedded database against all advice but just so that i can keep emailing it to myself easily until i get to grips with it better.  Then i hope to export this table to whatever small back-end seems best.  My Sql coding gets rejected Syntax

Re: [libreoffice-users] Re: Base scenario

2013-01-11 Thread Girvin R. Herr
Tom, I can't seem to change the direction from the editing (Join Properties) dialog. If the direction needs to be changed, I have been selecting the line by right-clicking on it and selecting the Delete option. I then re-enter the relationship (Join) in the opposite direction as I had

Re: [libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Girvin R. Herr
Tom, One thing that popped out at me is that you used double quotes () around your names. So I checked one of my queries to be sure and confirmed Base is using the single reverse quote ` ( not '). You might try that. The ...unexpected $end... is a clue. It sounds like it is finding an

Re: [libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Dan Lewis
I wonder about the last line of your code: WHERE OrgName IS NOT NULL; Above this line you used OrgName Your field has upper and lower case letters. When this is the case, you must enclose the field's name in double quotes. So, I'm thinking that this is likely the problem. A

Re: [libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Tom Davies
Hi :) I think i need to explore this a bit more tomorrow.  I tried both types of quotes and no quotes.  Then i made the field names unique and all lower-case and i tried using a query as the source rather than a table.  Then i tried editing my Sql code to the most basic example on the page

[libreoffice-users] Switch off warnings

2013-01-11 Thread C. H. D.
Hi! When using PDF/A, the following messages were shown. During PDF export the following problems occurred: PDF/A forbids transparency. A transparent object was painted opaque instead. Some objects were converted to an image in order to remove transparencies, because the target PDF format

[libreoffice-users] Base: Changing restoring (Default) font

2013-01-11 Thread Girvin R. Herr
Greetings, I am running Base in LO 3.6.4.3. In a form, I am trying to change the (Default) font without any progress. I do not know where this (Default) font setting is located and the styles icon on the toolbar, along with the font window on the toolbar are grayed out if I have a control

[libreoffice-users] Base: Setting the default listbox entry

2013-01-11 Thread Girvin R. Herr
Greetings, I am using LO 3.6.4.3 for Linux. I am trying to set a default entry for a listbox based on a joined table. The listbox has entries from the joined table as options. One of those options is the character: - (dash). I would like this option to be used whenever I do not set the

[libreoffice-users] No version named 4.0.0.0 RC1

2013-01-11 Thread C. H. D.
Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here: https://www.libreoffice.org/get-help/bug/ The error message I get is: There is no version named '4.0.0.0 RC1' in the 'LibreOffice' product. Regards, C. H.

[libreoffice-users] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread NoOp
On 01/11/2013 08:04 PM, C. H. D. wrote: Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here: https://www.libreoffice.org/get-help/bug/ The error message I get is:

Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Dan Lewis
On 01/12/2013 12:14 AM, NoOp wrote: On 01/11/2013 08:04 PM, C. H. D. wrote: Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here: https://www.libreoffice.org/get-help/bug/ The error message I get is:

Re: [libreoffice-users] Re: Base: Action Queries

2013-01-11 Thread Dan Lewis
If you are using Ubuntu, you can download MDB Viewer. It will open a Access database and reveal the database. With this you can export the tables. I think it does have some problems with exporting queries, but I'm not sure. It has been some time since I played around with it. Also, I seem to

Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Joel Madero
On 01/11/2013 09:18 PM, Dan Lewis wrote: On 01/12/2013 12:14 AM, NoOp wrote: On 01/11/2013 08:04 PM, C. H. D. wrote: Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Joel Madero
On 01/11/2013 09:18 PM, Dan Lewis wrote: On 01/12/2013 12:14 AM, NoOp wrote: On 01/11/2013 08:04 PM, C. H. D. wrote: Hello! I think the version numbers have not been refreshed properly. I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

Re: [libreoffice-users] Re: Base scenario

2013-01-11 Thread Hank Alper
Ian How are you defining your primary keys and your foreign keys ? From your post, it looks like you have two tables, 'Members' and eMail. Implicit in your post it appears that the primary key of 'Members' is 'Record ID'. Also, the primary key of 'eMail' is 'Message ID' while a key called 'Members

Re: [libreoffice-users] Switch off warnings

2013-01-11 Thread Joel Madero
On 01/11/2013 06:07 PM, C. H. D. wrote: Hi! When using PDF/A, the following messages were shown. During PDF export the following problems occurred: PDF/A forbids transparency. A transparent object was painted opaque instead. Some objects were converted to an image in order to remove

Re: [libreoffice-users] Switch off warnings

2013-01-11 Thread C. H. D.
Hi! I have submitted the enhancement request. Thanks. https://www.libreoffice.org/bugzilla/show_bug.cgi?id=59271 Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ --- 2013年1月12日 星期六,Joel Madero jmadero@gmail.com 寫道﹕ 寄件人: Joel Madero jmadero@gmail.com 主題:

Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread C. H. D.
Hello! Thanks! I can submit the bugs. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ --- 2013年1月12日 星期六,Joel Madero jmadero@gmail.com 寫道﹕ 寄件人: Joel Madero jmadero@gmail.com 主題: Re: [libreoffice-users] Re: No version named 4.0.0.0 RC1 收件人: