Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Adding An Item From One Listbox To Another Listbox


I have several forms, one with a listbox that displays the selected records of a field from a database. I select(click) one of those records and want to have another particular field from that record display in another listbox on another form. So far it works with this code, but pulls all the records from the first listbox.
To be more specific, the database has populations and zip codes, etc. The field for population is called pop2001 and the zip codes is Zip. The listbox with the selected records displays zipcodes and I want to select one of those zipcodes and have it's population display in the other forms listbox, but it displays all of them. Can anybody help?


Code:
Private Sub Form_Load()

PopRecSet.MoveFirst
Do Until PopRecSet.EOF
frmpopfinal.lstpopfinal.AddItem PopRecSet![pop2001]
PopRecSet.MoveNext
Loop


End Sub




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Solved-howto Send First Item Of Listbox Totextbox, Then Delete First Item Of Listbox?
Lol another question, how do you do this

how to send first item of listbox to textbox, then delete first item of listbox?

Thanks

Adding An Item To A Listbox.
I want to add an item to a list box from within the program. i though this code would work.

Private Sub Command2_Click()
List1.AddItem = textbox1

End Sub

The idea was to add whatever was in textbox1 to the list

Adding An Item To A Listbox
I have a listbox with items in it. I want to add another item to it but I want it to slot in at index position 3 in the list. There are already 8 items in the list. How can I do this?
Thanking you in advance
PORRASTAR

Adding Item To ListBox *SOVED*
Is it possable to add items to a listbox on new lines? Below is what I've set up but it doesn't work. Any suggestions?

Line 1 would have Date Of Party and Line 2 would have Time Of Party.

Code:
List1.AddItem rsInformation.Fields("Date Of Party" ) & "vbCrLf" & rsInformation.Fields("Time Of Party")

Adding Item From Recordset To Listbox:need Totals
Hi,
I am adding items from my RecordSet to a listbox on one of my forms. In this instance, there is three records that are displayed in my listbox. How can I get a total of these three into one? So, only one figure is displayed in the lsitbox and that is the total of all the records in the recordset at that moment.
Thanks,
kpearson

Need Urgent Help Adding Several Info Into Item In Listbox
I have used the following code to add a filename to the visible part of a listbox and the part to the "container" or the invisible part of the listbox (the same item location)

But now i need to extract the path info and cant find out how to do that right.
What i do is that i select an item in the list,and when doubleclicking that, a msgbox with pathinfo should appear. but it doesnt! Only error appears (that ive used something wrong)


VB Code:
Private Sub Command1_Click()For i = 0 To File1.ListCountIf File1.List(i) > "" ThenList1.AddItem File1.List(i)  'this add filename to visible part.ReDim Preserve strPath(List1.ListCount - 1)strPath(List1.NewIndex) = File1.Path 'this add path to invisible.End IfNext iEnd Sub


I need help to create a code that can extract the invisible part if you select the item,and press a command button !!

Please help me !!!

Search A Listbox For A String Before Adding Item
I have a listbox, and the user can add items to it by entering text into a textbox and clicking a label. Before an item is added though, I want to check to see if it already exists.

Declarations:
Code:
Private Const LB_FINDSTRING = &H18F
Private Const LB_FINDSTRINGEXACT = &H1A2
Private Declare Function SendMessageString Lib "User32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) As Long


Label Click:
Code:

Dim Index As Long
Dim Find As String
Dim I As Integer
For I = 0 To List1.ListCount - 1
    List1.Selected(I) = True
    Find = List1.Text
    Index = SendMessageString(List1.hWnd, LB_FINDSTRINGEXACT, -1, Find)
If Index > -1 Then
    List1.ListIndex = Index
Exit Sub
End If
Next
    List1.AddItem (TXTList.Text)


The problem is, after I have added my first item it will not let me add anymore because it exits the sub as it has found a match, when really there is no match to find.











Edited by - Rapidfire on 4/29/2007 12:46:12 PM

Make A Listbox With Checkbox Checked When Adding An Item
Hi, this is a very simple question but i have a hard time figuring out.
How do I make an item automatically checked when I add an item in a listbox with checkbox inside?

Thanks.

Adding An Icon/ Small Pic To Item Listbox And Combobox
is there a way that i can add an icon or a small picture to a listbox and a combobox?

Populate A Listbox Based On A Selected Item In Another Listbox
Ok...I am stumped.

I have a single form that has 3 list boxes. I have 4 public strings containing various values. Based on the selection from lstBox1, I need to populate the ListBox2 and ListBox3 list from values in the public strings. Clear as mud?? That is what I thought!

Example string variable

strLuxury = """Hand Wash"" ""Hand Wax"" ""Check Engine Fluids"" ""Detail Engine Compartment"" ""Detail Under Carriage"" ""Fragrance"" ""Shampoo Carpets"" ""Shampoo Upholstery"" ""Scotchgard"""

ListBox1 contains the following:

Standard
Deluxe
Executive
Luxury

ListBox2 is empty, but is contained in a frame indicating Exterior Options
ListBox3 is empty, but is contained in a frame indicating Interior Options

If Luxury is selected in ListBox1, then ListBox2 should contain
Hand Wash
Hand Wax
Check Engine Fluids
Detail Engine Compartment
Detain Under Carriage

And ListBox3 should contain
Fragrance
Shampoo Carpets
Shampoo Upholstery
Scotchgard

If Fragrance is present in ListBox3, a seperate dropdown box should appear allowing selection of the appropriate scent.

Yes, this is a homework assingment.

Thank you in advance for your help!
Mark

Transfering Item From One Listbox To Anotehr Listbox On Click
Hi all i got 2 listbox . I want to be able to click on my first listbox items and once i click on them it transfers to the second listbox. Could any one tell me how that can be done.Thanks

Listbox: How To Know Last Added Item's Index, When The Listbox Is Sorted?
When sorted property of a listbox is set to True, each new item added won't be at the end of the list, it will be automatically placed in the correct index, according to text order, is there a way to know which is the index of that item (last item added)? Looping to find it would be horrendous, I just need the index to mark that item selected.

How To Add A Listbox Item To A Listbox On Another Form Within The Project.
What is the best method to take an item selected in a listbox and add it to another listbox on a different form within the same app?

.: Please Help: Copy Selected Item(s) From A ListBox To The Other ListBox..
Hi everyone!

I'm having problem with copying file to another Listbox, please help..
So, in this case, I have two ListBoxes where the 1st ListBox holds several items..
I need to copy the selected item to the other listbox 'without' a repetition, I mean.. the same item won't copied anymore..
When the user tries to copy the item which have already been in the ListBox2, then a messagebox will pop up to warn the user of the existing item.... So, how should I do that??


Thanks a lot

Moving Listbox Item To Another Listbox
hi does anyone know of an easy way to move an item in a listbox to another listbox, lets say a source and target listbox and vice versa. thanks

Listbox Name Showing Up As First Item In Listbox?
For some reason the listbox I've just added to my form shows the name of the listbox in itself at design time. At run-time, the name of the listbox shows up as the first item in the list.

I've tried looking for a CAPTION or TEXT property but neither seem to be present. Any ideas as to how to fix this?

Drag Item From Listbox To Listbox
I was wondering how to drag one item from one listbox to another listbox on the same form...
By using drag and drop, not by using any button..
I choose an item by pressing and holding the button and then drag it to the other listbox..

Also,How do I drag a file from outside my app and into the listbox?
How to use the drag and drop (onto apps listbox) function?

Please provide a simple example(form) if you can
PS: Do it as simple as possible!! No need for extra's!!

I need more help, The examples below didnt work correctly!

Listbox To Listbox - Adding Index
I have on my form two listboxes: list1 and list2 and a button cmdGo

The item data placed in list one is placed there at runtime so therefore with no index values. When I press the go button I want each item from the first list box to go into the second list box BUT as the items go in I want to set index values because I need to form a string at a later stage and will need to keep adding until all items are added (until index is reached)

This is my code so far:

Private Sub Form_Load()
List1.AddItem "David"
List1.AddItem "Paul"
List1.AddItem "Sarah"
End Sub

Private Sub CmdGo_Click()
Dim x As Integer
Dim i As Integer
With List1
For x = List1.ListCount - 1 To 0 Step -1
List2.AddItem List1.Text
List2.ItemData(List2.NewIndex) = i
Next x
End With
End Sub


As you can see all is not well with the code and I am starting to pull my hair out - Any ideas?

How To Search Listbox For Item If Item Not Found Add Item?
Hi, lol man I cant find nothing today when I search the forum.

This my latest problem, How do I search a listbox for an item lets say "Game Over" And if the item is found the program does nothing, but if the item is not found it will add "Game Over"

Thanks Again

Removing An Item From A ListBox By Clicking The Item
Hi, How do you remove an item from a ListBox by simply clicking the item u want to be removed?

This is the code i tried but it doesnt work:

Private Sub list1_Click()
Dim n As Long
Dim ncount As Long

ncount = List1.ListCount - 0
For n = 0 To ncount
List1.RemoveItem (n)
Next
End Sub

Any ideas?


-Flaw

Last Item In A Listbox
A listbox normaly shows items 1 down to the maximum showable in that box despite of the value of .ListCount . How can I tell VB - after aplying the .AddItem-method - allway to show the .ListCount-item at the last line of the listbox (will say: display items [.ListCount-max. lines] to .ListCount)?

Thanks in advance!

Lightgun

For Each Item In Listbox...
Here is what im Trying to do:

Something like....

For Each Item in Listbox

MsgBox The Data of the item

Next

Its so simple, yet i havnt been able to figure it out =/

Listbox Item Taken Out
Hey, i also need to know how to take away an item from a list. so say i had lstMyList.additem myPerson.name

i would want to take away myPerson.name when i did a certain thing

does anyone know? thanks...Xtrava

Listbox Item
Is it possible to have some kind of short textstring shown with some information when you have the mousepointer over an item in a list box??

If I have the mouse of item 1 it might say "bla bla bla" and if I move it over item 2 "tada tada"

Add Item To ListBox
I'm trying to write a winsock program (but the actual problem doesn't have anything [at least I don't think] to do with Winsock, so I'm posting here). It is a LAN based IM system, and on the server side, it has a list box with connected users. What I'm trying to do is to add the user based on the index of the Winsock object, but I get an "Invalid Procedure Call or Argument" error on that line.

lstUsers.AddItem user(0), Index

user(0) is the user's name, and Index is the Index of the Winsock Object. When I comment out/take out the ", Index" part, the program rusn with no error. Where did I go wrong?

Listbox Value For An Item
I am populating a listibox with items. Is it possible to populate it like a combo in a html form?

I have a list of athlete's and when seleted I want to pull the ID for the athlete. I can already pull the text that is displayed but hoping I can add additional info like in a html combo and when selected display the other info.


VB Code:
...Do While adoRs.EOF = False            lstAvailable.AddItem adoRs.Fields.Item("ATHLETE_NAME").Value            adoRs.MoveNextLoop...


Update: Sorry, I said listview originally, I meant to say listbox.

Thanks for your help in advance.

ListBox Item
I have got a list box on a form, and I'm saving data into an Access Table like this, if 2 options are chosen, I place the first item in the field then I use a (comma), and then place the other option and so on.

Now I want to reverse it and do something like this, want to read that field and whenever it finds a comma , it should place the data in the next line. And I want to put the results in MsgBox and if I have these three items saved in the table: PS2, Newspaper, XBox...I would like them to appear in the MsgBox like This:
PS2
Newspaper
xBox

Any help on that?

Item From Listbox
Hi all,
I'm using a listbox which is containing around 100 items and the contents of listbox are changing after regular intervals. If a user selets an item from listbox, how can i get the name of the selected item?
Help me pls.
Anita.

Listbox ? How Much Item Can I Add ?
i m trying to add items to my listbox and i think that it has a limit of a 32767 items can that happen ?
10x

Each Item In A Listbox
I am trying to step through each item in a listbox, starting with the first item and making my way through each of them. I will be writing the contents of each item to a binary file (I've got all the code for that..). However, I can't seem to figure out how to step through each item in the list box and get its text value. Any suggestions? Thanks in advance!

For Each Item In Listbox...
In vb.net I have a listbox that contains the path to files. Then I used a For Each loop to add each file to the a zip archive. How can I do this in vb 6.0?

VB.net code:
For Each file In ListBox1.Items
'code
Next

Thanks for any help you can provide
Dave

Last Item In Listbox
I want to make it so that when the last item is selected in my listbox a message box is displayed. The amount of items in the listbox may vary so i dont know how many items will be in the list. Can someone please help.

Move ListBox Item Up Or Down
Just wanted to make a small contribution to the forum. I looked around for this but didn't find anything really to my liking, so here's my version...


Code:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Move Selected listbox item up or down
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Option Explicit
const UP as integer = -1
const DOWN as integer = 1

Private Sub btnUp_Click()

If Me.lstDisplayCols.ListCount > 1 Then
Call MoveListItem(UP, Me.lstDisplayCols)
End If

End Sub

Private Sub btnDown_Click()

If Me.lstDisplayCols.ListCount > 1 Then
Call MoveListItem(DOWN, Me.lstDisplayCols)
End If

End Sub

Private Sub MoveListItem(ByVal intDirection As Integer, _
ByRef lstListBox As ListBox)

Dim intNewPosition As Integer
Dim strTemp As String

intNewPosition = lstListBox.ListIndex + intDirection
strTemp = lstListBox.List(intNewPosition)

If intNewPosition > -1 _
And intNewPosition < lstListBox.ListCount Then

'Swap listbox items
lstListBox.List(intNewPosition) = lstListBox.Text
lstListBox.List(intNewPosition - intDirection) = strTemp
lstListBox.Selected(intNewPosition) = True

End If

End Sub

the lstDisplayCols listbox is a list of selected columns to be displayed for a search result list. Just put the name of your list box there...

How To Get The Text Of Item In A Listbox?
I am using a test tool that uses VBA as its back end. When I record the action the tool itself only recongnizes the NAME of the item selected in the list...in most cases this is best.

However, I really need it to select by text, but this does not seem to work. So I want to write a little VBA that will extract the text of the displayed selection in the listbox after my test tool plays back the selection.

Example:
the text displayed is "English"
the name of this item is "en-US"

I want:
textDisplayed = text.listbox, which will mean textDisplayed = "English"

I was wondering what the syntax for this is? rather new to VB.

Thanks in advance

Listbox Item Selection
Is there a way to select one item or a range of items in a listbox? Also, is there a way to deselect the currently selected items in the listbox?

Remove Item From Listbox
Hi

Please can someone help me, here is what i have a 1 textbox and 1 listbox, the listbox is populated from a field in the access database, all good so far. but i need to remove a specific item from the listbox, eg. the listbox is populated with table numbers "Table 1" to "Table 50" the textbox is connected to the database so if i move to "Table 5" in the textbox and click remove it is removed from the database but not from the listbox, so basicall i need to remove a table that i select from the textbox and the corresponding table number in the listbox must be removed, and cant quite figure it out, here is what i am trying.

Private Sub Command1_Click()
Dim MyTest As Integer
MyTest = Text1.Text
List1.RemoveItem MyTest
End Sub

Please can someone give some advise.

Many thanks in advance

Remove Item From Listbox
In the list box, I want to remove selected items and retain the other items in the same positions in which they existed before removal.
For example, consider a listbox having 10 items. Suppose I remove the 7th item, 8th, 9th & 10th items should remain in the same position. 8th to 10th items should not move up in the list. 7th item will not have any values.
How can this be done?

Removing An Item In A Listbox
When selecting an item in a listbox and clicking Go_click(), to remove that item, is the code just


Code:
Private Sub Go_Click()
List1.RemoveItem List1.ListIndex
End sub

It seems to work, but, should there be more?

Listbox+For Each Item+Pause
Ok, guys, i need help. I have one listbox, populated with irc #channels, and i want bot to come and enter in each channel in listbox, then to say some text (i use this for my irc server, for annoucments), and part that channel after saying a message.
I got how to do that, but i have a problem. It comes to "exces flood" and i am being disconected from server.
How can i eventually pause some events? U know, it joins to channel, than says a message, parts that channel, waits for a couple a seconds (for exam. 3 seconds) than joins other channel in list and so on??


Code:
On Error Resume Next
Dim i As Integer

For i = List1.ListCount - 1 To 0 Step -1
Winsock1.SendData "JOIN " + List1.list(i) + vbCrLf
Wait 5000 (its says to wait 5 seconds, than to do next)
Winsock1.SendData "PRIVMSG " + List1.list(i) + " :" + "xax" + vbCrLf
Wait 5000 (its says to wait 5 seconds, than to do next)
Winsock1.SendData "PART " + frmLISTAKANALA!List1.list(i) + vbCrLf

Next i
End sub
Greetings from Bora.

Formating A Listbox Item
I have created a listbox in VB. It lists all of the sheets in my current workbook. When I click on the name of one of the sheets, it switches to that sheet. It works really nicely. I am trying to figure out a way, when the listbox comes up, to BOLD the name of the active sheet.

I am not sure it is possible to format the text for a particular line in the listbox.

Listbox.item(0)=NADA
I know this has to be very simple, but I'm stumped. I've searched the forum using "blank listbox item", "empty item listbox", "fill listbox" and could not find my answer.

I am using the code below to populate a listbox, the problem is that the first item in listbox is always empty. If I check the length of the first record it comes out to 0 so I thought that telling it not to add items with a length of less than 1 would handle that, but it didn't.

Thanks in advance for your help.

Bart

Code:
Private Sub cmbExchange_Click()
Dim sTable As String
sTable = GetTable
OpenDB
sSQL = "SELECT DISTINCT [System] FROM [" & sTable & "] WHERE [System]<>NULL"
Set Rs = New ADODB.Recordset
Rs.Open sSQL, oCon, adOpenKeyset, adLockReadOnly
If Rs.RecordCount > 1 Then PopSlcList
CloseDB

End Sub


Private Function PopSlcList()
Dim i As Integer
i = 0

Rs.MoveFirst
Do While Not Rs.EOF
If Not IsNull(Rs!System) Or Len(Rs!System) > 1 Then
Debug.Print Rs!System

lstSLC.AddItem Rs!System, i
i = i + 1
Rs.MoveNext
End If
Loop

End Function

Listbox Selected Item
Hello again!

I was wondering if anyone knew how to make the selected item from a listbox appear in a text box.

For instance List1 as the list box and Text1 as the text.box? Is it just one of the properties because I have not be able to find it.

Thank you for all your help!

Listbox Item Movement
With a listbox, I need to check the first item's text but I'm not sure how to go about this...

I want to say something like...


Code:
If List1.text (0) = "" Then
'BLAH BLAH
End If
Obviously, this doesn't work, I just need it to check the text in the first index of the list...

THANKS!

Highlighting Item In Listbox
Does anybody know how to either :::

Change backround colour of item in a listbox
Foreground COlour of item in a listbox
Or Highlight an item as if i had clicked on
it.

Except im doing this through getting the
Mouse positions for the menu item and am
trying to get them highlighted in the
MouseMove event of the listbox

Selecting An Item In A Listbox
I was using this following code to select the item in the combobox I needed but now I need to just be able to specify the ID of the number and it select it in the combobox. Can anyone shed some light?


Code:
Sub LoadBillToList(ItemName, ItemID)
If ItemID = "" Then
ItemID = 0
End If
frmInvoices.txt_BillToID.Clear

If strDBOpen = 0 Then
OpenDatabase
End If
strSql = "SELECT ID, CompanyName "
strSql = strSql & "FROM BillTo "
strSql = strSql & "ORDER BY CompanyName asc"
Set rs = my_Conn.Execute(strSql)

If rs.EOF Or rs.BOF Then

Else

frmInvoices.txt_BillToID.AddItem ItemName
frmInvoices.txt_BillToID.ItemData(frmInvoices.txt_BillToID.NewIndex) = ItemID
strTempI = 2
Do Until rs.EOF Or rs.BOF
strBillID = rs("ID")
frmInvoices.txt_BillToID.AddItem rs("CompanyName")
frmInvoices.txt_BillToID.ItemData(frmInvoices.txt_BillToID.NewIndex) = rs("ID")
rs.MoveNext
strTempI = strTempI + 1
Loop
End If
rs.Close
Set rs = Nothing
CloseDatabase
End Sub

Selecting Item From A Listbox
Hi, I could never figure this out. How do i select something from a listbox and make it do something. I have a listbox with user accounts for my game. and i dunno what command i would use to select it. because. i cant assign any items with an itemdata because its consistently changing with autoupdated accounts etc. and with Inventory Items etc... Is there any way to select a listbox item without any Assigned Itemdata?? if so.. Can N e 1 help me? Thanks. I have tried pretty much everything i can think of. Thanks.

Getting Listbox To Highlight The Last Item
is this possible? As i do Additem it pushes the lines up..
i need it to be able to stay at the bottom.

(its for supplying logs for a synchronisation program)

Also is it easy to write this to a textfile ? so the list doesnt get too big?

How Do I Unselect An Item In Listbox?
I have two listboxes in my form, one contains a list of active users, the other a list of inactive users. I want to be able to select only one user (from either listbox) at a time. So say I click on listbox1, and then on listbox2, then the selection in the first one should go away. Am I making sense?
I tried to use listbox1.ListIndex=-1, but that doesn't unhighlight the item.
Thanks for your help

Listbox Item Text
Hello, i want to display the text in a listbox item.

list1.text will display for the selected text
however,
i want to obtain the text for a particular item in the list

ie: get list1 item 3's text

Copyright © 2005-08 www.BigResource.com, All rights reserved