Anyone know of a dropdown box that has 2 columns

[bigfoot]

Anyone know of a dropdown box that has 2 columns.
I can't get by with 1, and I can't use a list. The door to life is never locked, but few have the knowledge to open it.

 

[Snaggs]

How about using a tab and concatenating the two values togther before adding them to the list box? This will give the appearance of having two columns. You'll have to write some additional logic so that values in the listbox line up in the correct columns, but that's a pretty simple task.

lstName.AddItem strFirstName & vbTab & strLastName

Snaggs
tribesaddict@swbell.net
If a parsley farmer is sued, can they garnish his wages?

 

[bigfoot]

I need to be able to get to the 2 columns like 2 separate values. I don't want to be concat- un-concating them.

Is there any other way? The door to life is never locked, but few have the knowledge to open it.

 

[jpb]

I am trying to design a report useing vb report writer .
The report is a profit and loss account.
I have a table in my DB called accounts, which containds the account name , type(incom/expense) accumulated balance.
I want to print the account name and their individual balances , and a total at the end of each group for example , a total for all the income accounts...

eg...

Bank £12000
Cash £300
£12,300
Total


rent £300
Esb £400
Total £700


Overall Total £11,600


I thought I could do a group by query as follows but it is not correct
"Select AccountName, AccBAL,SUM (AccBAl), TypeID from Accounts Group By TypeID"

Any suggestions on how I could achieve this would be greatly appreciated

 

[jmarler]

bigfoot,
Sherida makes a pretty decent combo box that has as many columns as you want. Along with that packages you get a pretty decent grid control. At my last job, we used these controls a lot and they worked well for us. You could pprobably download a demo of it from

http://www.shersoft.com/

to see if it works for you.
- Jeff Marler B-)

 

[petermeachem]

I tried a combo from (I think) iqdesign. It didnt work properly however, so I mailed them for help. They didn't bother to reply, so I dropped it.
As the customer in this case has Office 97 everywhere, I decided to use the Access drop down which works very well. The only snag is that you arent allowed to distribute it, but it's fine for people who have Office already.
I've just read

http://support.microsoft.com/support/kb/articles/Q224/3/05.ASP

Apparently there is something called the activex control pad. This is a free download that includes fm20.dll, so it is ok to use the Access combo. Hooray.

 

[edderic]

to jpb

your question is not a RE to bigfoot question (buth Sum As)

To Bigfoot (what a name ;-) )

Forms2 Object Library on VB have a combobox whit 2 of more collums

Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com

 

[petermeachem]

Thats what I said Edderic. Forms2 is fm20.dll and you must not distribute it with vb. It comes with Office, not VB.

 

[edderic]

BoelSheet ,its works fine with VB and after Install on another computer Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com

 

[bigfoot]

I used the Forms2 Object Library combobox, and it worked fine. Since all my salesmen have Office anyway, I included it in my project.

-BF