Combobox and listcount -
Is the Combobox.ListCount property an Integer? I'm populating a combo box with over 34,000 records (I know it's a lot, but necessary) and if I look at the listcount on the combo box, it shows something like -27020. Anyway to get the true number of items in a combobox other than with listcount?
I'm checking the value selected by the user to make sure that it is an item in the combobox. This is a generic function that I just pass the combobox into and then search for a string in the combobox using a for x=1 to ComboBox.ListCount for loop. If I have a large number of items in the combobox, the loop fails on the first pass and the function returns false, even though the item may be in the list.
Combobox and listcount -
Is the Combobox.ListCount property an Integer? I'm populating a combo box with over 34,000 records (I know it's a lot, but necessary) and if I look at the listcount on the combo box, it shows something like -27020. Anyway to get the true number of items in a combobox other than with
combobox loop and search -
okay here's the problem. I have a string called Name
When i get this string i want to loop through a combo box and find out if there are any matches of Name in it. If there is i want to delete it. How do i do that?
I'd imagine something like this:
Name as string
For i = 1 to
combobox change event -
Hi everyone. I have a question regarding the combobox change event. What changes have to happen in order for this event to kick in? The following code seems to do nothing in the change event procedure of the combobox:
text1.text = combo1.listcount
I am adding text to several text
Why is this making me NUTS (how do real programmers do it) -
Hi everybody,
This issue is making me nuts, and I'm 100% sure most of the members here have fixed their conflict. I hope you'll help me.
I have a comboBox that I fill from a City-Name table. Naturally, I hope to allow users to enter a city name if it doesn't exist, and then add t
Howto randomize List box items (please) -
I'm almost on the verge of figuring this out ... but, I could use some help (please). My brain is fried ... this is the extent of my Basic thinking abilities (kinda sad I guess)
Thanks for any help!
Dim ListCount As Integer
Dim Store_Old_List()
Dim Store_New_List_Count()
D
Combobox w/out Additem -
Hi everyone.
I am looking over someone else's code, and somehow they managed to put a list of entries into a combobox without using the Additem routine. I've done a search through all of the code, and couldn't find where they would do this. In fact, I can put a watch on the combob
Scroll to selected item in listbox -
Hi guys,
I'm in Access. I have a form with a listbox and a combobox with the same values. The user selects the value in combobox, clicks the button, and the same item gets selected in the listbox. The problem is that the listbox doesn't scroll to the selected item automatically. Her
SETDROPPEDWIDTH for a MsForms.ComboBox -
This code functions ok with the regular combo...
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Long) As Long
Private Const CB_SETDROPPEDWIDTH = &H160
Sub
combo box hell!!!! -
i want to remove items that apear in a table tblLoan from a combobox called VideoID. The .Text(i) isn't right, but i dont know how to refer to the value of the index in the combobox.
Set dbs = CurrentDb()
Set rs1 = dbs.openrecordset("tblLoan")
Do
With Forms!frmVi
[resolved] function returns combobox -
Hi,
On a form I have a combobox that I want to be filled with data.
I fill a different combobox with a dataset and the combobox datasource. I do this in a seperate class-file. Now I want to return this combobox to the combobox on the form. However this results in no data in the com
Autolength combobox -
i have a combobox. the length of the combobox is fixed.
i dont wnt to adjust the length as i want my form look neat so i want all combobox are in the same length.
but the problem arise when the data that loaded in the combobox is longer than the combobox length (like in the attachmen
ComboBox stuff -
Hi,
I am programming in access '97 and now I want to use a comboBox to do the following:
If I type a new value into my ComboBox that isn't in the list I want to Add it to the table where I created the list
However using the NotInList option I can add the new entry but somehow
Question about DataGridView ComboBox column -
I have a couple questions about a DGV combobox column:
1) Is there a way to type in your own text into a DGV combobox like you can with a standard combobox?
2) Is there an event to tell when an item from a DGV combobox has been selected?
Thanks...
VBA/Access ComboBox question.... -
I have a combobox on an access form, but when a user types key into the combobox, the text changes?! I just want them to be able to press like 'r' and it go to the R's in the combobox, not actually type 'r' into the combobox.
Thanks,
Justin Fox
Call data to Combobox using SQL from Access -
I would like to list out data from my table in Access into my combobox without using ADODB connection. Is it possible for me to do that ? At the moment i tried using SQL query but i could not list out the data in my ComboBox.
Below are my codes. Any advise or assistance would be ve
Combobox and API -
Ok, bet no one has this! Heh.
I need to know how to make a Combobox function like a Microsoft Access 97/2000 Combobox. I know how to do the DataBinding and all that stuff, I just can't get it to Display more than 1 Column.
Can anyone help me? Is there a way to SubClass into th
Combobox problem (super urgent) -
I have a combobox populated with data from the database.
I cant see some of the data when i select the combobox dropdown list.
Anyone got any idea??
Is there a limit on how many items the combobox can display at one time?
i tried typing the data in the editable region of the comb
[word] saving combobox data -
I have a userform that has a combobox in it. The combobox starts empty, then when a user types in a new string, that string is added to the combobox, up to 5 entries. I want the last 5 entries that were in the combox when I quit, to stay in the combobox when I open the document. Is
Combobox like the old Forms 2.0 combobox -
Hello everyone. I have a combobox that I bind data too. The users here want to be able to type in 2 or 3 characters and have the right vendor name come up in the combobox.
With the default combobox that comes with vb .net 2003, everytime they press a letter on their keyboard, the co
ComboBox! -
A VB6 Form has a ComboBox where items get listed dynamically. Before adding any item to the ComboBox, I want to first find out whether the item already exists in the ComboBox list or not. If yes, then don't add that item again to the ComboBox list but if not, add the item to the ComboB
autocomplete web form combobox -
Hi;
Hope someone would be able to help.
I manage to populate the the values from my database to a combobox. The problem is that there are about 1000s of records. My question is that is there a way for user to type in the combobox to search through my combobox record to display t
Combo Box - NewIndex - URGENT! -
Is there a way that, when a new row is added to a ComboBox, you can set focus to the ComboBox, and to the newly added row?
I've tried setting focus, and doing a <<cmbQuery.List (NewIndex)>> to cause the ComboBox to jump to the newest entry so that it is at the user's dis
Plz -
This will delete dupes:
Dim I As Long
Dim J As Long
With List1
For I = 0 To .ListCount - 1
For J = .ListCount To (I + 1) Step -1
If .List(J) = .List(I) Then
.RemoveItem J
End If
"comboBox text entry" problem -
Hi everybody,
I have two comboBox controls on a form, and one of these controls isn't behaving itself!
I believe I need to find and eliminate code that tells the control how to accept data. When I try enter a new item in this comboBox, all I will see in the comboBox is the last cha
DataGridView combobox -
Hello,
I have a datagridview with 2 comboboxes, what i want is when i change the value of the fist combobox, the list of the second combobox should change accordingly (this i know how to be done). My question is when i want to retreive the data rows from the database, how can i ass
Update the ComboBox at runtime -
Hi
I have tried to update my combobox with no luck. I add records to the table,
the combobox has as Datasource, but I don't know how to update the combobox.
I have tried updata the OleDBAdapter and the DataSet and set the datasource
to that dataset, but nothing happens. I can see
SSDBCombo -
How do I get the number of items and accessing an item in an SSDBCombo type combo box not a regular ComboBox (it would be ListCount and List(i) here) type. Thanks.
Muticolumn in ListBox, Combobox -
Hi,
In MS Access, Listbox and combobox can allow us to input the number of columns, and setup the width of each column.
In VB 2005 Express, we do not have these options of the Listbox and Combobox. I found that ListView has these option. But, I want to try to work multicolumn on
Locking Combobox ** Resolved** -
I want to be able to lock a combobox when I load a form based upon a specific criteria. I want to prevent the combobox from dropping down when the user clicks on the drop down arrow. I don't want to use the .Enabled property because I want to be able to change the fore color of the co
External App Combobox -
Fun Question!
Do you have code to search a combobox and do the following ( to a external application )?
1.)Pick External Form
2.)Pick Combobox
3.)Look through combobox for item
4.)Return handle ( hWnd?) to combobox item
5.)select item from combobox
Diplay day of into combobox -
Hi
(vb.net 2005)
I have a combobox which has a number of list in it
Mon
Tue
Wed
Thur
Fir
Sat
Sun
what i need to do is that on form load the combobox display the real day in it
if it is Monday the combobox should display Mon.
Need help using ComboBox -
How can I start from the top in the combobox and get the text from all the items in it.
Say i have 5 item in the combobox, how can i create a loop that gives me all 5 the text in the combobox.
for example if I where going to add all the items from the combobox to a listbox
Winsock: sending content of combobox from server to client -
Hey everyone. I'm new to this forum and I need some help with Winsock. Well theres a combobox on my client and a combobox on the server. Lets say the combobox on the server was filled. How can i send the same exact content of the server combobox to the combobox on my client ?? Thx in a
populating the combobox -
hi,
does the combobox in vb work the same as in access.
i mean in vb 6.0 i have a combobox ;i want to retrieve all values in a field from database using ado programming into combobox, based on the value i select in the combobox i want the corresponding values in the textbox.
i k
The registry and combobox -
I have combobox which will add the item (whatever) you type in itself. Now I want to save all the items in the combobox in registry so that I can retrieve them later.
How do I do that and how do I add them back to the combobox when my program starts?
Thanks
COMBOBOX + 2 fields... -
Hi,
I have a combobox which is loaded with a SQL query below.
SELECT [ID],[Name] from [Customer] ORDER BY [Name]
And I am loading the combobox with name field...Is there any way to associate the name with ID...
I mean when user chooses the name from the combobox and press O
combobox helpppp!!! -
i have a combobox which i manually filled in with items like...
1
2
3
4
5
6
7
8
9
10
11
12
that items are hours of the clock....
now the question... how can i save the user selected item unto the database without changing its real item?
ex....
Combobox ------
combobox in dropdown mode after setfocus -
if i do a 'setfocus' on a combobox, how can i display this combobox in the drop down mode (the same way like you clicked on the little arrow).
The purpose is the following: the user clicks on an arrow, i position the combobox and then i want it to expand, so that is seems that the a
[2005] Clear the text from a ComboBox -
Hi,
I am using Visual Basic 2005 Express Edition
I have in my form ComboBox:
ComboBox.DropDownStyle = ComboBoxStyle.DropDownList
I am trying to clear the text from the ComboBox:
ComboBox.Text = ""
It's not working
I don't want to clear all the items:
ComboBo
[2005] ComboBox -
How can I add items to the combobox?
Besides, once i click on certain item of the combobox,certain action would be taken. For example, once i add on second item of combobox, certain command would be sent to the serial port..
Looking forward to receiving feedback here in the forum