Stel uw vraag

cpb's profiel - activiteit

2020-10-04 01:25:46 +0100 beantwoorde een vraag How do I count the number of rows selected in a macro?

@Roadkill1954, i obviously cannot test the code but you can retrieve the record count from the result set like so: Sub

2020-09-23 02:05:48 +0100 reageerde op een antwoord base flatten query

it seems that the OP will not respond which helps no one and means that the thread cannot develop. my solution was base

2020-09-21 21:38:57 +0100 beantwoorde een vraag Error linking subform when connecting LO Base 7 trough tcp

@rstp looking at the error message i can only suggest: from the 'Base' window 'menu:Edit>Database>Advanced Set

2020-09-16 20:18:12 +0100 bewerkte een antwoord base flatten query

@mathteacher asked Is there an easy way to write a query that will flatten the rows into columns? none of the open sour

2020-09-16 20:11:07 +0100 badge ontvangen  Mede-redacteur (bron)
2020-09-16 16:00:35 +0100 beantwoorde een vraag base flatten query

@mathteacher asked Is there an easy way to write a query that will flatten the rows into columns? none of the open sour

2020-09-11 15:41:55 +0100 bewerkte een antwoord Synchronise scrolling of subforms

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your pr

2020-09-10 16:15:15 +0100 reageerde op een antwoord Synchronise scrolling of subforms

@Ratslinger said do not understand why you have not posted before? initially i did not know what to make of this commen

2020-09-10 03:43:33 +0100 reageerde op een antwoord Synchronise scrolling of subforms

have replaced attachment.

2020-09-10 03:35:13 +0100 bewerkte een antwoord Synchronise scrolling of subforms

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your pr

2020-09-10 03:02:27 +0100 beantwoorde een vraag Synchronise scrolling of subforms

i am making this post as an answer because i cannot see how to include an attachment in a comment. @gkick i saw your p

2020-08-27 14:31:20 +0100 badge ontvangen  Goed Antwoord (bron)
2020-08-27 13:24:29 +0100 badge ontvangen  Mooi Antwoord (bron)
2020-08-27 13:14:17 +0100 beantwoorde een vraag Base Average Function Bug?

hello @JohnnyG, you can return a decimal value like this: select avg(1.00 * "MyFieldName") from... precision is deter

2020-08-22 03:53:03 +0100 reageerde op een antwoord delete cascade seems not to work

@LeoP, Ratslinger has solved your issue. the Base Relations Design window is buggy and unreliable so it's worth double c

2020-06-10 19:19:49 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! struggling to format this. ( case when (select "ID_assunto1" from "tFilt

2020-06-10 18:56:15 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! struggling to format this. ( case when (select "ID_assunto1" from "tFilter") i

2020-06-10 18:55:58 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! do not seem to able to format this. ( case when (select "ID_assunto1" fr

2020-06-10 18:54:28 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! do not seem to able to format this. ( case when (select "ID_assunto1" from "tF

2020-06-10 18:53:56 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

2020-06-10 18:52:55 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

2020-06-10 18:52:30 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

2020-06-10 18:52:02 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

2020-06-10 18:51:47 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end +

2020-06-10 18:51:33 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end

2020-06-10 18:50:59 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! ( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end

2020-06-10 18:50:41 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

what an effort to post a comment!!! case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case

2020-06-10 18:49:27 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select "ID_assunto2" fr

2020-06-10 18:48:19 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select "I

2020-06-10 18:47:46 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case whe

2020-06-10 18:46:54 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case whe

2020-06-10 18:46:29 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case

2020-06-10 18:45:24 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

( case when (select "ID_assunto1" from "tFilter") is null then 0 else 1 end + case when (select

2020-06-10 18:43:12 +0100 reageerde op een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

@pmfs1987. it's gratifying to see that you have achieved your own solution. query execution depends largely upon the s

2020-06-10 18:43:12 +0100 badge ontvangen  Commentator
2020-06-09 21:07:24 +0100 bewerkte een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

2020-06-09 20:43:26 +0100 bewerkte een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

2020-06-09 20:36:29 +0100 bewerkte een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

2020-06-09 20:30:27 +0100 bewerkte een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

this answer replaces the original in order to reflect the objectives as i now understand them. ok so user pmfs1987 want

2020-06-09 20:16:17 +0100 bewerkte een antwoord Libreoffice Base: How to filter and search in multiple tables? [closed]

hello pmfs1987, Edit: 2020-06-05 i have replaced my original answer in response to the comment "ID_assunto" field

2020-06-08 10:52:02 +0100 badge ontvangen  Mooi Antwoord (bron)
2020-06-08 10:31:47 +0100 reageerde op een antwoord Two issues with Report Builder

continuation of previous comment. the only field within the group 'Style' which is guaranteed to be UNIQUE is 'Name'.

2020-06-08 10:27:04 +0100 reageerde op een antwoord Two issues with Report Builder

@Ratslinger yes my comment is misplaced, it should have been targeted at the original poster. sorry but unable to fix as

2020-06-08 03:30:09 +0100 reageerde op een antwoord Two issues with Report Builder

with reference to my answer: your report is actually displaying the data exactly as instructed. you declared 1 group '

2020-06-08 00:53:59 +0100 beantwoorde een vraag Two issues with Report Builder

hello ptoye, the field causing the issue is "Name". use the 'Sorting and Grouping' dialogue to fix like so: would a