Multi column list box

[ChrisProg]

I have two queries.

1. I would like to employ a multi column list box, derived from a simple query. Does such a control exist? If yes, can you please identify the file name.

2. With a drop down combo box which is bound to a query, I am having a problem making the selected item in the combo box automatically make the corresponding record in the data control the currect record!
Any advice on the best way to do this please.

 

[sunaj]

Hi,

1) You can use the listbox from the microsoft forms 2.0 object library. Or you could use a listview.

2) Databinding is not by cup of tea (I prefer to code everything myself, which gives a higher degree of control). But try:
data1.Recordset.AbsolutePosition = combo1.listindex


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[johnwm]

sunaj,

have you found microsoft forms 2.0 object library consistently reliable? I've had occassional instabilities (not always traceable) when I've tried it.

Microsoft says

"The Fm20.dll is NOT redistributable. You must have an application such as Microsoft Office 97 on the target system that installs Fm20.dll as part of its setup. (Fm20.dll is included with the OSR2 and OSR2.5 releases of Windows 95.) You can also find this file on the Visual Basic 5.0 CD under the \TOOLS\DataTool\Datatool\Msdesign folder. This will be installed only if you run the setup for the Visual Database Tools. In any case, you may not distribute the Fm20.dll as part of your setup, even if you purchase the Microsoft Office Developer Edition product.

As an alternative to having your end users install Microsoft Office, you can have them freely download and install the Microsoft ActiveX Control Pad, which also installs the Fm20.dll. For more information, see the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/html/cpad.asp

NOTE: The use of these Microsoft Forms components in your own compiled applications, such as those written with Microsoft Visual C++ and Microsoft Visual Basic, is not recommended or supported. These controls were designed and tested to work exclusively within Microsoft Office and its Visual Basic for Applications environment.
"

my italics Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[sunaj]

Hi John

I've only deployed applications with form2.0 internally on pcs which all run win2000 or higher (and all have office installed) - and thus never experienced any problems.
Your point should certainly be taken into account if Chris is going to distribute his app into the 'real world' where you never know how people are going to abuse you program....

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'