Ask Your Question

Spur52's profile - activity

2019-02-01 17:20:47 +0200 asked a question No New Record Tab

No New Record Tab This is purely a curiosity question. I have started using the Enterprise/Corporate ver 6.0.7. There

2018-12-18 00:56:56 +0200 commented answer Value must be entered before I can move to next field

I found the problem. The field I was having trouble with has a drop down list linked to it and I did not change the pro

2018-12-17 23:54:17 +0200 received badge  Popular Question (source)
2018-12-17 21:15:57 +0200 commented answer Value must be entered before I can move to next field

how do I get it to you?

2018-12-17 20:09:18 +0200 commented answer Value must be entered before I can move to next field

I was wrong. It happens when trying to save. Property shows NO. I could attach some screen shots but can't find how

2018-12-17 20:09:18 +0200 received badge  Commentator
2018-12-17 18:22:07 +0200 asked a question Value must be entered before I can move to next field

Value must be entered before I can move to next field Recently I have updated my L.O. version to 6.1.3. After opening t

2018-12-17 17:22:07 +0200 commented answer LibreOffice 6.1.2 Base value field problem

I am also having the same problem, of sorts. I upgraded to Version: 6.1.3.2 (x64). At first a couple of fields were ch

2018-10-27 09:19:59 +0200 received badge  Popular Question (source)
2018-10-25 00:58:46 +0200 received badge  Famous Question (source)
2018-10-24 22:46:23 +0200 received badge  Notable Question (source)
2018-10-24 22:43:03 +0200 received badge  Notable Question (source)
2018-10-24 22:37:23 +0200 asked a question ID doesn't show in queries Base

ID doesn't show in queries Base I have a query that contains the ID #. When doing the query the ID remains 0 even thoug

2018-05-28 03:35:20 +0200 commented answer Can't change checkbox default to blank (null)

This does not answer my question.

2018-05-27 19:49:45 +0200 received badge  Popular Question (source)
2018-05-27 16:46:52 +0200 commented question Can't change checkbox default to blank (null)

0 or 1 doesn't change the default to blank. It will still be checked. In table view the box is black, click on it agai

2018-05-27 16:40:07 +0200 commented question Can't change checkbox default to blank (null)

0 or 1 doesn't change the default to blank. It will still be checked.

2018-05-27 16:39:53 +0200 edited question Can't change checkbox default to blank (null)

Can't change checkbox default to blank (null) In table view, edit mode, I have added a checkbox. Entry required no, le

2018-05-27 16:39:44 +0200 edited question Can't change checkbox default to blank (null)

Can't change default to blank (null) In table view, edit mode, I have added a checkbox. Entry required no, length 0 an

2018-05-27 16:39:44 +0200 received badge  Editor (source)
2018-05-27 16:03:41 +0200 asked a question Can't change checkbox default to blank (null)

Can't change default to blank (null) In table view, edit mode, I have added a checkbox. Entry required no, length 0 an

2018-05-27 15:07:32 +0200 received badge  Notable Question (source)
2018-04-21 01:59:34 +0200 received badge  Notable Question (source)
2018-03-25 21:30:42 +0200 received badge  Popular Question (source)
2018-03-25 17:54:14 +0200 commented answer BASE: I have a file for recipes.

Oh well, thanks

2018-03-25 17:00:27 +0200 asked a question BASE: I have a file for recipes.

BASE: I have a file for recipes. I have a file for recipes. Is it possible to reference a record using the ID? Simil

2018-03-21 17:58:59 +0200 commented answer In toolbar record # of record # is garbled in base

I have newest version and still not fixed 6.0.2.1(Mar 21,2018) So anxiously awaiting 6.1

2018-03-21 16:32:01 +0200 asked a question In toolbar record # of record # is garbled in base

In toolbar record # of record # is garbled in base In toolbar record # of record # is garbled. Have seen this problem b

2018-03-11 05:34:10 +0200 received badge  Famous Question (source)
2018-01-28 02:16:46 +0200 answered a question address labels in Base

Hard to answer as you are very vague in your question. Are you using Writer or Base. It sounds like Writer.

2018-01-27 10:45:13 +0200 received badge  Notable Question (source)
2018-01-26 20:40:33 +0200 received badge  Popular Question (source)
2018-01-26 18:14:00 +0200 asked a question Libreoffice Base

Libreoffice Base I am only interested in the Base side. Is there a way to filter out all others and just see Q & A

2017-09-27 01:28:55 +0200 received badge  Popular Question (source)
2017-09-26 01:27:04 +0200 commented answer Checkboxes with 3 Flavors

Thanks. Interesting

2017-09-25 17:16:50 +0200 commented answer Checkboxes with 3 Flavors

Can you tell me what purpose it serves??

2017-09-25 17:14:51 +0200 marked best answer Checkboxes with 3 Flavors

When using checkboxes there is 3 colors. Blank is white, then check it and it is black, and check it again and it is grey. What does the grey represent??

2017-09-25 16:21:37 +0200 asked a question Checkboxes with 3 Flavors

Checkboxes with 3 Flavors When using checkboxes there is 3 colors. Blank is white, then check it and it is black, and c

2017-09-25 00:42:18 +0200 marked best answer 2 word query for same field

I have a recipe database. 2 fields (Recipe Name and Ingredients). I want to query Recipe Name using 2 words and also query Ingredients. Example: asian salad in Recipe Name and lettuce in Ingredient. Using the formula below it works well using one word but how to search using 2 words?

SELECT * FROM "Recipe Table" WHERE "Recipe Name" LIKE '%' || :Enter_Search_Word || '%'
AND "Ingredients" LIKE '%' || :Enter_Search_Word || '%'

2017-09-25 00:42:18 +0200 received badge  Scholar (source)
2017-09-25 00:41:34 +0200 received badge  Enthusiast
2017-09-24 17:59:50 +0200 commented answer 2 word query for same field

Thanks Ratslinger. I am new to SQL and love it. Just have to learn the lingo, etc. Help like you make it easier.

2017-09-24 11:37:56 +0200 received badge  Popular Question (source)
2017-09-24 01:24:23 +0200 commented answer 2 word query for same field

Thanks for getting back to me. I tried that and it only asked " :Enter_Search_Word" once

2017-09-23 15:30:27 +0200 asked a question 2 word query for same field

2 word query for same field I have a recipe database. 2 fields (Recipe Name and Ingredients). I want to query Recipe N

2017-09-23 14:57:27 +0200 received badge  Notable Question (source)
2017-09-13 23:10:34 +0200 received badge  Popular Question (source)