Re: [users] Base query

2009-05-29 Thread Ocke Janssen
Moin John Meyer, On 28.05.09 23:02, John Meyer wrote: I'm trying to make a query that will only select the odd entries in an integer field. How do you do that in Design View? What about SELECT ID from Table WHERE MOD(ID,2) = 1 and switch back to design view. - oj PS: A good list for those

Re: [users] ooOrg.Base: Problem with SQL-Statement - remains related to old filename after table-rename

2009-05-29 Thread Ocke Janssen
Moin Guido, On 28.05.09 22:44, SHIMMO wrote: Hi there, i have replaced a table called OriginalTable by doing the following steps: a) copying the original file to a file called NewName b) added and changed fields in NewName c) deleted OriginalTable d) renamed NewName to OriginalTable After

AW: [users] ooOrg.Base: Problem with SQL-Statement - remains related to old filename after table-rename

2009-05-29 Thread SHIMMO
Moin Ocke, Do you mean the order-command in the SQL-Statement? If so, I did not enter it, at least I do not remember. ;-) The table has only a primary key, nothing else. The error occcurs directly after doubleclicking the table, and than I get an empty window without data. Kind regards guido

[users] outline problem

2009-05-29 Thread Guy Voets
hello list, I have a simple but annoying problem with the outline structure of a document. I have 3 parts with Heading1 level, but they don't need numbering. Then in the second and third part (Heading2 and Heading3), there are subdivisions. I can't get the numbers right. This is the structure:

Re: [users] A system wide macro, a system wide key assignment

2009-05-29 Thread Harold Fuchs
2009/5/28 Verner Kjærsgaard v...@os-academy.dk Hi list, Using my ordinary user account I can record a macro and subsequently assign it to a key. This works fine. Now what if I wish to record a macro and assign it to a key for everyone to use? In other words, make it a system wide

Re: AW: [users] ooOrg.Base: Problem with SQL-Statement - remains related to old filename after table-rename

2009-05-29 Thread Ocke Janssen
On 29.05.09 09:45, SHIMMO wrote: Moin Ocke, Do you mean the order-command in the SQL-Statement? If so, I did not enter it, at least I do not remember. ;-) The table has only a primary key, nothing else. The error occcurs directly after doubleclicking the table, and than I get an empty window

[users] ooOrg.Base: Problem with SQL-Statement - remains related to old filename after table-rename

2009-05-29 Thread SHIMMO
Sorry, it's a REAL problem, not just a WBO (WrongButtonPressed). I understand, that after doubleclicking on a table, a view is created to show the table-content. That view obviosly uses a field-description of the table ADRESSEN, that's stored somewhere in the odb-file. In my case, due to an

Re: [users] Base query

2009-05-29 Thread John Meyer
Thanks. I found that also by looking up the HSQL syntax online. Ocke Janssen wrote: Moin John Meyer, On 28.05.09 23:02, John Meyer wrote: I'm trying to make a query that will only select the odd entries in an integer field. How do you do that in Design View? What about SELECT ID from Table

Re: [users] Is this even possible? (Compacted table from long list...)

2009-05-29 Thread Mark Knecht
On Thu, May 28, 2009 at 3:56 PM, Mark Knecht markkne...@gmail.com wrote: On Thu, May 28, 2009 at 3:15 PM, Brian Barker b.m.bar...@btinternet.com wrote: At 14:10 28/05/2009 -0700, Mark Knecht wrote: I have a large table of weekly equity data coming out of another program from which I need to

Re: [users] Envelope printing problems

2009-05-29 Thread Tim Deaton
At 2/23/2009 1:58 AM Tim Deaton wrote: At 18:05 16/02/2009 -0500, Brian Barker wrote: At 17:08 16/02/2009 -0500, Tim Deaton wrote: I'm using OOo Writer v3.01 (OOO300m15 build 9379) on WinXP SP2. The hardware is a no-name PC with an AMD Duron 950mhz processor and 1gb ram. Whenever I write

Re: [users] outline problem

2009-05-29 Thread Hagar de l'Est
If I understand correctly, the problem comes from the fact that heading 1 (Intro, Part 1, Part 2) are not numbered. As a workaround, you can create a character style with white font and number the Heading 1 titles with the numbering but with that character style. The numbering won't appear in

Re: [users] Is this even possible? (Compacted table from long list...)

2009-05-29 Thread Johnny Rosenberg
If you press Ctrl+F2 you can make cell formulas by clicking and typing and with some guidance. If you look up the VLOOKUP command, double click it and place the cursor in the Sort Order field, you can see information about that parameter. It says that if it's TRUE or NOT GIVEN, that means that the

[users] OpenOffice 3.1 not compatible with Windows 7?

2009-05-29 Thread Web Kracked
I just ran - Windows 7 Upgrade Advisor Beta It stated that OpenOffice.org 3.1 was not compatible with Windows 7. Of course the publisher's website that the software link listed Nero's website for OOo web site. Also some articles seems to think Windows 7 will cost at least 25% of the total

Re: [users] OpenOffice 3.1 not compatible with Windows 7?

2009-05-29 Thread Adam Tauno Williams
Also some articles seems to think Windows 7 will cost at least 25% of the total cost of a new PC. It also appears that the same web sites are hosting articles saying MS is already working on the pre-Alpha version of Windows 8. And how does that have anything to do with OOo? Well, if anyone out

Re: [users] OpenOffice 3.1 not compatible with Windows 7?

2009-05-29 Thread David B Teague
WebCracked wrote, and Adam Tauno Williams saw fit to omit: I just ran - Windows 7 Upgrade Advisor Beta It stated that OpenOffice.org 3.1 was not compatible with Windows 7. Of course the publisher's website that the software link listed Nero's website for OOo web site. Adam Tauno Williams

[users] [Ping Web Kracked] 3.1 ISO

2009-05-29 Thread NoOp
I think that you'll be interested in this thread from the releases list: http://comments.gmane.org/gmane.comp.openoffice.releases/11705 [3.1 ISO available.] The iso is only in dvd format (2.25GB) and there is no CD iso available. Might be a good idea for you to subscribe to the releases list and