List box data and colums

Discuss the database features
Post Reply
salrandazzo
Posts: 5
Joined: Fri Aug 30, 2013 4:15 pm

List box data and colums

Post by salrandazzo »

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.
LsitBoxTxt.PNG
LsitBox.PNG
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 :knock:
OpenOffice 4.1.4 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: List box data and colums

Post by Villeroy »

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
Post Reply