Ask Your Question

K0's profile - activity

2016-04-29 20:17:32 +0200 received badge  Famous Question (source)
2016-04-22 17:02:27 +0200 commented answer I downloaded the lastest version of LibreOffice (5.1.1.3) and I can no longer run my databases. It tells me that Java can't be found

I have downloaded the latest version of Java and LibreOffice database will still not run.

2016-04-15 01:54:52 +0200 commented answer I downloaded the lastest version of LibreOffice (5.1.1.3) and I can no longer run my databases. It tells me that Java can't be found

I did click on Java. I have loaded both the JRE and the JDK versions. LibreOffice base still won't run on my Mac.

2016-04-13 16:34:22 +0200 commented question Why isn't JRE showing up on Preference "advanced" page?

Java version 1.8.0_77 apparently is a JDK version. This is what Oracle says, Java 8 Update 77 (8u77) Release Highlights JDK 8u77 contains IANA time zone data version 2016a. For more information, refer to Timezone Data Versions in the JRE Software. Java Expiration Date The expiration date for 8u77 is 4/19/16. For systems unable to reach the Oracle Servers, a secondary mechanism expires this JRE (v 8u77) on May 19, 2016.

2016-04-13 16:20:39 +0200 received badge  Notable Question (source)
2016-04-12 18:49:14 +0200 commented answer I downloaded the lastest version of LibreOffice (5.1.1.3) and I can no longer run my databases. It tells me that Java can't be found

I did see Java. So far I haven't gotten an answer to my question, but I have spent a lot of time trying to get an answer from Java. You would think it would be very simple. K0

2016-04-12 18:47:29 +0200 received badge  Popular Question (source)
2016-04-11 18:44:19 +0200 asked a question I downloaded the lastest version of LibreOffice (5.1.1.3) and I can no longer run my databases. It tells me that Java can't be found

When I try to run the database I get the following message. LibreOffice requires a Java runtime environment (JRE) to perform this task. The selected JRE is defective. Please select another version or install a JRE and select it under LibreOffice - Preferences - LibreOffice - Advanced. I have downloaded the latest version of Java version 8 Update 77 (build 1.8.0_77-bo3). I tested this version of Java using Firefox and Oracle said that my version of Java is fine. I can't locate Java on my computer and so I can't find it when I use the browse option under LibreOffice - Preferences - LibreOffice - Advanced. The Advanced preference says Java runtime environments (JRE) already installed: , but nothing in listed in the box below. What do I do?

2015-08-28 09:08:05 +0200 received badge  Famous Question (source)
2015-05-23 22:23:18 +0200 received badge  Famous Question (source)
2015-05-23 15:56:24 +0200 received badge  Notable Question (source)
2015-04-28 17:08:19 +0200 received badge  Popular Question (source)
2015-04-28 03:37:33 +0200 asked a question Can LibreOffice file created on a Mac be viewed and saved by LibreOffice on Windows?

I am using Yosemite on a Mac and my daughter is using both windows 7 and windows 8 on a PC. Language is english. I want to know the answer for all components of Libre Office.

2015-04-25 21:41:31 +0200 answered a question I have tried to use queries in the database to find words in multiple text fields contains many words

I would like to make a comment first. I use a Mac for all of my work. I have 2 computers. My new computer runs Yosemite; my old computer runs OS 10.5.8. Since I started using Macs instead of Windows, I have used AppleWorks as my office. I can’t use it on my new computer and I have no idea how long my old computer will continue to work, so I needed to find a replacement office program. After a lot of searching, I choose LibreOffice because it is the only office program on Mac that has all of the features that AppleWorks does.

There is one problem LibreOffice’s database is not as user friendly as AppleWorks is and LibreOffice lacks several very useful features that AppleWorks does and it is not nearly so intuitive. I looked for other possible databases for Mac, but none of them are as good as AppleWorks is. Please, could someone out there bring AppleWorks database back?

OK. Back to my original question. How do I find words in multiple text fields that contain many words? (Note: I am aware that most searches are case sensitive.)

I appreciate the answers I received. In fact, I had tried to use the IN clause in a Query without success. I would write an IN clause, such as IN(‘Missing’) and it would convert to 'IN(''Missing'')'. I didn’t realize that it was necessary to place a space between IN and (; once I did, the criterion remained IN (‘Missing’). However, I found out the following, unless Missing is the only word in the field searched, the search comes up empty. The field in question is the title of books. Thus if the title of the book is Crouching Buzzard, Leaping Loon, to find it with the IN command, I must write the query as IN (‘Crouching Buzzard, Leaping Loon’) in order to find this book. IN (‘Crouching Buzzard’) won’t work, nor will IN (‘Crouching Buzzard*’). So the IN command won’t help me find one work in a field of many.

I hadn’t heard of the LOCATE command and the example included with the answer showed my how to use it. This is a very complicated command, especially the need to include the criterion <> ‘0’ in order to insure that the result doesn’t include all of the records showing that they don’t include the word. However, if you search for the word ‘one’ in a Memo field, it will include one, done and any other word that contains one inside of it. This is also true if you search for ‘one’ in a field using the Find command.

I played around with the LIKE command in both Query mode and in Filter mode. It didn’t work at first because I tried LIKE 'one', for example, in my Memo field and no records were found. It took a while to discover that if ‘one’ was the first word in ... (mehr)

2015-04-25 04:00:49 +0200 received badge  Notable Question (source)
2015-04-21 16:51:21 +0200 received badge  Popular Question (source)
2015-04-21 05:20:01 +0200 asked a question I have tried to use queries in the database to find words in multiple text fields contains many words

LibreOffice Version: 4.4.1.2 (Database) Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: en

Operating system is Mac OS X Yosemite version 10.10.2 in English