*correction* I can't find a way to get a form to execute a query. On Aug 27, 2016 6:55 PM, "Alanon SR3" <alanon....@gmail.com> wrote:
> 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" <bruceh...@gmail.com> 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 <alanon....@gmail.com> 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