Topic profile page for Combo box.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Combo box.
Topic "Combo box" was discussed 12,744 times on 518 sites in last 3 months
Started 14 hours, 58 minutes ago (2009-11-27 06:02:00)
by hsk
Combo Box - Always show the dropdown list On my userform I am having a combobox. The drop down list appears when user clicks on the dropdown button. It hides the list when when user presses the button again. Is there any way i can show this list always .... I don't want users to hide that list is this possible ?...
Started 15 hours, 42 minutes ago (2009-11-27 05:18:00)
by uniquo
protected worksheet and combo box code Hi, How to adjust this code when it is used in a locked worksheet? The data validation for the other cells work even when the sheet is protected, but the combos are unaccessible. Thanks '========================== Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ ...
Started 1 day, 1 hour ago (2009-11-26 19:22:00)
by Leo
I have a combo box that lists the option (limited to list) from a table called tblALLRECCS which has only one field called RECS. How do I write a code in Not In List event of the combo box so that any new entries that is not in the list will be added to the RECS in the tblALLRECCS, after prompting the user with a message box whether he...
Started 1 day, 1 hour ago (2009-11-26 19:02:00)
by Teddy
I want to create a form with a combo box that has 3 choices only. I would like the choices to be Exceptional, Very Good, and Good. In the table design I thought I was supposed to do the following. General tab / default value / "“Exceptional”; “Very Good”; “Good”" Lookup tab / display control / combo box Lookup ...
Started 1 day, 2 hours ago (2009-11-26 18:59:00)
by Leo
I have a combo box that lists the option (limited to list) from a table called tblALLRECCS which has only one field called RECS. How do I write a code in Not In List event of the combo box so that any new entries that is not in the list will be added to the RECS in the tblALLRECCS, after prompting the user with a message box whether he...
Started 1 day, 10 hours ago (2009-11-26 10:20:00)
by willif
I know this title doesn't really explain what I'm trying to do here, but I've been asked to help do some charting and data validation for a local school. So, here's the thing. School results actually are non-numeric unfortunately. They range from 1C (through 1B etc) up to 5B. There are actually 'numbers' behind these, but they don't mean anything to the school staff. So, what I was hoping to...
Started 1 day, 11 hours ago (2009-11-26 09:50:00)
by jammoca
active x combo box I have an active x combo box that is currently displaying the contents of column L4:L30 in sheet called "DropBox Sources". I would really like to display the contents of both columns L and M as well ( at the same time) .. ie L4:M30. so instead of showing ... MATHS_B_1 MATHS_B_2 MATHS_B_3 ...
Started 1 day, 14 hours ago (2009-11-26 06:39:00)
by yeleek
Hi, I've a Access 2007 database which I want to use a field keywords with. The keywords field in my main table is a look up field to another table (called tblkeyword) containing a list of words. The main form of the main table is configured such as to let me select multiple values from a combo box from the tblkeyword table, all working fine. I want though to be able to create a search ...
Started 1 day, 15 hours ago (2009-11-26 05:53:00)
by Kashmala
Hi, Can some one help me with the combo boxes in visual basic please. I have craeted a combo box in a user form but what i dont know is: How to stop users writing in the combo box and select only listed options e.g. I have a combo box with two options in it External & Internal. At the moment it allows users to write in the combo box and if i lock the combo box it wont display option for a ...
Started 4 days, 16 hours ago (2009-11-23 04:29:00)
by sarah
I have figured out how to creat cascading combo boxes, however once i update the second combo box it changes all records on the form. How do i get it so all records are independent from eachother? I am somewhat new to this - any help is appreciated!
Started 1 week, 1 day ago (2009-11-19 14:56:00)
by TiredAlison
Hi I have a spreadsheet with a combo box setup. I want it to display in the pull down dates in the format dd/mm/yy from todays date - 5 days to todays date + 30 days. I have searched the help and discussion post and found code to get it to pull down in the format mm/dd/yy from a specific date but I am not clever enough to alter ...
Started 3 days, 5 hours ago (2009-11-24 15:04:00)
by Pastor Del
I have 2 combo boxes on an unbound form. I want to fill the list of the second combo box based on the second column of the first combo box selection. I have successfully used [Forms]!MyForm]![MyCombo] in the row source of combos before and Forms !MyForm!MyCombo].Column(1) in code before, but the .Column(1) does not work for me in a ...
Started 2 days, 1 hour ago (2009-11-25 19:27:00)
by thevibe
Hi guys, I have a small issue that I would like to correct. What script can reset a combobox ? After the user submitted the form all the information needs to go. I found how to do it for the field text and the checkboxes but not how to reset the combobox. e.g. working; txtfirst.text = ""; workshop1_box.selected = false; combobox = ??? Thanks in advance !!!
Started 1 day, 18 hours ago (2009-11-26 02:18:00)
by thevibe
Hi guys, I have a small issue that I would like to correct. What script can reset a combobox ? After the user submitted the form all the information needs to go. I found how to do it for the field text and the checkboxes but not how to reset the combobox. e.g. working; txtfirst.text = ""; workshop1_box.selected = false; combobox = ??? Thanks in advance !!!
Started 3 days, 10 hours ago (2009-11-24 10:58:00)
by rudeboymcc
HI. I've got a combo box based on a table with ID as the first field. I know the ID I want, and want to set the combo box to that. I use Forms!Formname.cmbBoX = ID, and what this does is set the combo box to the record at the index = ID. So instead of trying to find a match for that ID, it uses the number as an index position and jumps to that index. I've also tried "'" & ...
Started 3 days, 8 hours ago (2009-11-24 12:42:00)
by Sam Landy
My combo box has 6 columns, and (right now) 11 rows. The Row Source is a very simple query. The Bound Column data looks like this: CustInfo BAOH01 BHIA01 BHNY06 GMAL01 IMC* MMMO02 MMMO04 NDC* OPT* PBI* PSS* The AfterUpdate event follows: Code: Private Sub cmbSelRebCust_AfterUpdate() Dim Filters As String, LI As Integer If Me....
Started 1 day, 22 hours ago (2009-11-25 22:28:00)
by thevibe
Hi guys, I have a small issue that I would like to correct. What script can reset a combobox ? After the user submitted the form all the information needs to go. I found how to do it for the field text and the checkboxes but not how to reset the combobox. e.g. working; txtfirst.text = ""; workshop1_box.selected = false; combobox = ??? Thanks in advance !!!
Started 1 week, 1 day ago (2009-11-19 15:23:00)
by EddyLLC
Can anybody help me populate a combo box in VB6 with data from an Access database. The issue I'm struggling with is the combo box must have multiple columns. Each record in the database has two fields and both fields must appear when the combo box pull down is activated. Thanks
