Upgrade of VB6 MSForms.ListBox

[Guest]

I am trying my first VB6 to ,Net upgrade. The app uses the MS Forms 2 ListBox
control.

My original program assigns a column in the list box using:
.Column = V
where V is a two dimensional variant array. The upgrade (.Net 2003) changes
the line to:
.set_Column(V)
with an error 'Overload resolution failed..' - the function appears to need
either zero or 3 parameters. I canot find any documentation on the
..set_column routine and I dont really get the 3 arguments (Column as object,
Index as object, Value as object). Any ideas?

 

[Peter Huang [MSFT]]

Hi,

Currently I am researching the issue and we will reply here with more
information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Herfried K. Wagner [MVP]]

I am trying my first VB6 to ,Net upgrade. The app uses the MS Forms 2
ListBox
control.

Make sure you read the following article:

INFO: Usage and Redistribution of FM20.DLL
<URL:http://support.microsoft.com/?scid=kb;EN-US;224305>

 

[Guest]

Thanks Herfried, very interesting! I was not aware of the distribution issue.
The combo box in MS forms 2 is great though - multiple columns and hidden
columns - you can display a code and its description. When the combo is not
expanded it can show just the code, when it is expanded it can show the code
and the description - why could we not have this in VB6? True it messes up
the tab and backtab functions but they can be surmounted.
Best regards,

 

[Peter Huang [MSFT]]

Hi

Thanks for Herfried's suggestion.
So far the the controls were only licensed for use in Office in any case.

If you have Office you can use them in your applications, but the use is
unsupported and not recommended.
The big issue is that the DLL is not redistributable so your customer base
is limited to people who have Office installed.
Please check this article as Herfried's suggestion.
INFO: Usage and Redistribution of FM20.DLL
http://support.microsoft.com/default.aspx?scid=KB;EN-US;224305

So far I think you may try to use .NET control(listbox, list view or else
to do that job)
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guest]

Hi Peter,

In fact all users of this application have to have MS Office installed, so
the distribution issue does not matter in this instance. Any info regarding
set_column would be most welcome!

 

[Herfried K. Wagner [MVP]]

John,

In fact all users of this application have to have MS Office installed, so
the distribution issue does not matter in this instance. Any info
regarding
set_column would be most welcome!

I suggest to try to remove the dependency from this library because its use
in a Windows Forms host has neither been tested nor is it supported. If you
want to display tabular data, you can use the datagrid or listview controls
instead which are included in the .NET Framework's 'System.Windows.Forms'
namespace.