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?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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
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.
Refer To An Item In A Listbox For Another Form
I have one more question. I am working on a form that needs to keep in memory the first and last name of a student that is in a list box and once you move to another form whatever student you are clicked on will show up on the second form in a label box. Does anyone have any suggestions on how to populate this data into the other form?
Thanks,
Ryan Gagliano
Loading A Form When Item In Listbox Is Selected
Hi guys and gals.
I want to be able to select a specific name in a listbox that will load a form with a flexgrid on it, which will have data from a table loaded into it. Now I can do all this if I have just 1 name in the list. I want to be able to click on any name and load a form with that names personal table. Thanks in advance.
Daz
.: 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
How To Use Value Of Selected Item In Access 2000 Form Listbox
I have a listbox on a form in Access 2000. Using VBA, I run a search of files within a certain directory, and then display the results in the listbox. The items are added using the "Row Source" value in the listbox.
What I would like to do is enable the user to double-click one of the files in the list, and have the file open. I was trying to use the following code, but am unsure how to reference the selected file value:
-----
Dim strSelected As String
strSelected = ListBox1.???
Application.FollowHyperlink (strSelected)
-----
Any help would be appreciated!
Thanks in advance,
Malcolm
Pouplating The Fields Form An Item Chosen In A Listbox From An MDB.
Hi.
Here is the code i am using:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = OpenDatabase("PathAndFileName.mdb")
Set rs = db.OpenRecordset("TableName",dbOpenTable)
'now you are ready to go
rs.MoveFirst
Text1.Text = rs!Field1Name 'use your real field names here
Text2.Text = rs!Field2Name
In the given code the recordset is told to move to the first record and fill in the fields."rs.MoveFirst"
I need it to move to the recordset selected in a listbox. I Have 100 recordsets. THe listbox is filled with all items in field1. There are 15 fields. So what i need is for when i click on an item in the listbox(could be the 50th recordset) i need it to move to that recordset and then fill in the fields. Basicaly something like "rs.Move(List1.list(list1.listindex)) If you know what i mean.
Is there any way to figure out which recordset to go to if given the contents of the first field? And then have it move to that recordset?
Thanks for any help.
- Listbox - Default Item Selected On Form Load
Ok, sorry for having to ask another question. But I have to learn from somewhere.
I have a listbox(or two ;)) and when you load the form, I want it to select one of the lines in the listbox automatically.
I'm not sure how to do this. I just need a little help, a push in the right direction, or an example. Thanks!
Edited by - Do the hokey pokey on 8/18/2004 3:23:53 PM
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
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!
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.
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
Deselection Of Item In Listbox
Does anyone know how to deselect an item in one listbox if an item is selected in another listbox?
I'm setting the ListIndex to -1 for the listbox I want to unselect, but for some reason it doesn't quite select the other one, just sorta... makes an outline over it and doesn't do anything til u click it again
Any ideas?
|
TRACKER
