Hi all.
I'm tring to move from msAccess to OpenOffice. I'm not expert at all.
I have a working form in msAccess, but I don't understand how to implement it on OO.
The form is used to select a customer by typing the phone number or the name. When the user starts typing name (eg: "rt") or phone number (eg: 342) the basic script connected to the event "modified" writes a SQL string that is used to change the "rowSource" propery of the list box, so that the list box content is narrowed by the updated SQL query.
Now I have two questions:
- Is it possibile to display more than one column in a OO listbox? So far I just succeded in showing only one column
- Is it possibile to change the data source of the listbox, writing a property with a SQL string?
THanks a lot.
Salvatore
List box data and colums
-
- Posts: 5
- Joined: Fri Aug 30, 2013 4:15 pm
List box data and colums
OpenOffice 4.1.4 on Windows 10
Re: List box data and colums
Yesterday's answer: viewtopic.php?f=13&t=91253
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice