Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Bruce,

> On form Form_Filter, is it possible to define the List Box using 
> General - List Entries and Data - ValuelList

No problem to define it separately. But I would only use this kind of
entries if I would knew all entries, which ever should be chosen by
the listbox. So, for example, a listbox for "Mrs.", "Mr." or something
like this. All others I would fill with entries of a table of the
database.

> (without using the separate table Filter and query Query_Filter)?
> 
What you write inside the brackets has nothing to do with the
value-list of the listbox. It is one possibility to filter a table by
a listbox without using any macro. You could get nearly the same
result with a construction of mainform and subform. Then you could do
it without the table "Filter", but also without a listbox. You could
only navigate through the mainform with the distincted values of
"Category" and the subform will show the rows of this "Category".

> The Base Handbook has brief comments on the List Entries & 
> ValueList but only defining those items does not produce a working 
> List Box.

The entries you are defining must match with the entries the field for
the values would accept. You could create a listbox without any
connection to data of any table - but you can't use this for a filter
without also using macros.

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJXwyccAAoJELDKYwaoS9AIk8oP/3zLBk6VFpEBV71PCcgQPWbH
iF9I4sMa2xtn2Eb6KvPmTcq8zG5AjowObbamAscGX79Tsk9Oue23lmRSbX3mXcRR
M1SjsWDHKbFKGAbJQM1XPEbBarUNRcT8Y2BWp7BhRLmcFpL0uB/Xw/xaLALfFo3y
xb+Siw2TetMOu6eBXV3HCSt5Bi5fh/iDJ0YXlELdOoteGgrmaPpFjG5p86Ztybjn
7RlRT4tZZNC2DIfczFT2iXu0K8pIfFQVqz7p2e3Q/On12EvAViP4AbP1hg4/kLMI
hKsheA1zvm7N4/JgH33wbAxPB7Fh1cTVkciEIVGyIzusCb9wgJpjdW1fms36NuNa
OxIX9GCTGG7S7SdNW+9H8eCpRyCX8GkWDQCDlHe8jqqAid41XiiZcG0TxbARmRRN
mV+4u5OyNfJewGyxh1noFjRB1ZwIKz8aWyt70b3nmsGAfWkcZFMQa4m65wqvyiS3
F/ThPXIGj1TdbfbnC+kIySVBGzE452b/lzElNclXagg1KtmTzkXAVH5/WMEACfHJ
ov8NCwZFYm667JHkQkAkQUAejoEs7HZgXPOVDGNLu09wTiUNQClWkRZyxW1rvvMz
mEOVi1ia/vRQgMJcozecqqj44a8FBLDdx063s55AOJclKmeKl2u3kQb3t6/nZlen
gjZDA1WYnmzOnDkFG1fG
=tpYZ
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Bruce Hohl 
On form Form_Filter, is it possible to define the List Box using General -
List Entries and Data - ValuelList (without using the separate table Filter
and query Query_Filter)?  The Base Handbook has brief comments on the List
Entries & ValueList but only defining those items does not produce a
working List Box.

On Sun, Aug 28, 2016 at 3:23 AM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Alanon,
>
> could be you are looking for something like this:
>
> http://robert.familiegrosskopf.de/download/Filter_Database.odb
>
> One table "Table" with the content you will list, one other table
> called "Filter" with only one row. A query lists the content of
> "Table" dependent of the content of "Filter".
>
> In the form there are two separate forms - one for "Filter", one for
> the query. "Filter" will read out the value you have choosen from a
> listbox. The button refreshes the other form for the query. There are
> no macros needed.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJXwpGJAAoJELDKYwaoS9AIIKcP/RpIgCBKZ6jtbSx8EudE9A4i
> SslUhyoPzIgAOSn3daOdOLq/jBTVEOo9hF24lwiu31tyuOU2/vTYvYsXe/0hpfUp
> ieJcr+jVMuVTEPIr7OtskgCkASlMDBnxe3vvzoorYSEr47xW+eczcfxINRH1r9FF
> PtKhI6RRcVYDzj3meUjBPHnVrE9Wh8/7RX9+GJPVcU/GtQE3Yps77FsOhwE/iQah
> q4q2wCjzYWgVTV7ls7YX1Em+dsXLuHsJtyqDaGnJr5U0hb10bLSL0D2ge8ujvMiQ
> ypizv/gaKD9D7SUkfHkrqyMkmx5PPbTX+BVX0P1AjHNCAj1P99T3Nt0bRYFbffVq
> 0x1a1Bt+68BZWI6sfKM6mr8fy3ZYSCdQ0uJhKklTke4ETR+2zXnLsNXUzWYJavrh
> bqED7tlXvh6e0KGRARBLHXxbwN2JJx2LuODs3n0wZtqsSJu5aWdNCPnvPV7QGaRQ
> dl585Kx3k73mn5iyWSnC8NSPsz7qZ6ypA8QJdPi6wy6pdfQ1tTopawqX0d+RTFBk
> DGN+Fo+zVifGGPYDcNWw0SxszGNi1JiuJL4ef2GwAmF6ctmFVhR6znE6UPF92uSY
> K81zrlgmqNRfVlpW1TpVPvE8gnCqakmNNVZGEZwI+S5umfMiOGjynmoWZDGgYHUk
> xxmRPkrgAPQTN/pr26w2
> =MDTk
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Alanon,

could be you are looking for something like this:

http://robert.familiegrosskopf.de/download/Filter_Database.odb

One table "Table" with the content you will list, one other table
called "Filter" with only one row. A query lists the content of
"Table" dependent of the content of "Filter".

In the form there are two separate forms - one for "Filter", one for
the query. "Filter" will read out the value you have choosen from a
listbox. The button refreshes the other form for the query. There are
no macros needed.

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJXwpGJAAoJELDKYwaoS9AIIKcP/RpIgCBKZ6jtbSx8EudE9A4i
SslUhyoPzIgAOSn3daOdOLq/jBTVEOo9hF24lwiu31tyuOU2/vTYvYsXe/0hpfUp
ieJcr+jVMuVTEPIr7OtskgCkASlMDBnxe3vvzoorYSEr47xW+eczcfxINRH1r9FF
PtKhI6RRcVYDzj3meUjBPHnVrE9Wh8/7RX9+GJPVcU/GtQE3Yps77FsOhwE/iQah
q4q2wCjzYWgVTV7ls7YX1Em+dsXLuHsJtyqDaGnJr5U0hb10bLSL0D2ge8ujvMiQ
ypizv/gaKD9D7SUkfHkrqyMkmx5PPbTX+BVX0P1AjHNCAj1P99T3Nt0bRYFbffVq
0x1a1Bt+68BZWI6sfKM6mr8fy3ZYSCdQ0uJhKklTke4ETR+2zXnLsNXUzWYJavrh
bqED7tlXvh6e0KGRARBLHXxbwN2JJx2LuODs3n0wZtqsSJu5aWdNCPnvPV7QGaRQ
dl585Kx3k73mn5iyWSnC8NSPsz7qZ6ypA8QJdPi6wy6pdfQ1tTopawqX0d+RTFBk
DGN+Fo+zVifGGPYDcNWw0SxszGNi1JiuJL4ef2GwAmF6ctmFVhR6znE6UPF92uSY
K81zrlgmqNRfVlpW1TpVPvE8gnCqakmNNVZGEZwI+S5umfMiOGjynmoWZDGgYHUk
xxmRPkrgAPQTN/pr26w2
=MDTk
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-27 Thread Alanon SR3 
thank you Bruce.

I have the Query setup as well as the stand alone or unbound form with the
listbox in it.

I find a way to get the form to execute the Query.  In the controls window,
I am finding where actions can trigger, but it only appears to allow me to
add macros...I can't type anything in the text boxes next to the event
items.  I've also tried adding a push button hoping a wizard would come up
to build the action...no such luck.

I'd prefer not typing in all 12+ categories in the Query criterion field as
more categories will be added in the future on an as-needed basis.  Plus
some are rather longly named.

Can you or anyone assist with getting a form to execute a query?  The
"help" was more like a dictionary than a how-to.

thank you in advance,
alanon

On Aug 27, 2016 6:31 PM, "Bruce Hohl"  wrote:

> > What would I need to write as a criteria so that when the QUERY is run,
> it
> prompts the user to select from a listbox
>
> You must create a form to use the List Box control.  If you really only
> need a query you can add the choices to the query parameter name.  For
> example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
> :enter_dog_cat_or_bird (see simple attached example).
>
> From the installed help see: Contents > Database Functionality > General
> Information > Working with Queries (Query Design / Parameter queries) and
> Working with Forms (Form Controls / List Box).
>
>
> On Sat, Aug 27, 2016 at 3:14 PM, alanon  wrote:
>
>> Hi,
>> Thank you in advance for your help!
>> I'm trying to build a query that would list the records in a database
>> where
>> the user selects from an existing list of categories.
>>
>> IE
>> there are 12 existing categories, each with a bunch of records.
>> the user wants to review just the records under the category "gas", but he
>> doesn't know that exact category name so he needs a listbox to show his
>> existing categories to select from.
>>
>> What would I need to write as a criteria so that when the query is run, it
>> prompts the user to select from a listbox so he can review the records for
>> that said category?
>>
>> Thank you.
>> Alanon
>>
>>
>>
>> --
>> View this message in context: http://nabble.documentfoundati
>> on.org/libreoffice-base-building-query-need-help-with-
>> input-parameter-development-tp4191909.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-27 Thread Bruce Hohl 
> What would I need to write as a criteria so that when the QUERY is run, it
prompts the user to select from a listbox

You must create a form to use the List Box control.  If you really only
need a query you can add the choices to the query parameter name.  For
example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
:enter_dog_cat_or_bird (see simple attached example).

From the installed help see: Contents > Database Functionality > General
Information > Working with Queries (Query Design / Parameter queries) and
Working with Forms (Form Controls / List Box).


On Sat, Aug 27, 2016 at 3:14 PM, alanon  wrote:

> Hi,
> Thank you in advance for your help!
> I'm trying to build a query that would list the records in a database where
> the user selects from an existing list of categories.
>
> IE
> there are 12 existing categories, each with a bunch of records.
> the user wants to review just the records under the category "gas", but he
> doesn't know that exact category name so he needs a listbox to show his
> existing categories to select from.
>
> What would I need to write as a criteria so that when the query is run, it
> prompts the user to select from a listbox so he can review the records for
> that said category?
>
> Thank you.
> Alanon
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> libreoffice-base-building-query-need-help-with-input-
> parameter-development-tp4191909.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-27 Thread alanon 
Hi,
Thank you in advance for your help!
I'm trying to build a query that would list the records in a database where
the user selects from an existing list of categories.

IE
there are 12 existing categories, each with a bunch of records.
the user wants to review just the records under the category "gas", but he
doesn't know that exact category name so he needs a listbox to show his
existing categories to select from.

What would I need to write as a criteria so that when the query is run, it
prompts the user to select from a listbox so he can review the records for
that said category?

Thank you.
Alanon



--
View this message in context: 
http://nabble.documentfoundation.org/libreoffice-base-building-query-need-help-with-input-parameter-development-tp4191909.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted