Topics Search

Binding multiple columns in a combobox

Binding multiple columns in a combobox
Views: 37
Well, it is a pretty straight forward question. How do I bind each of the three columns in my combo box.
Sponsored Links:

More topics

 

ComboBox not listing multiple columns

Preview
I have a combo box based off a query. I want to add a second column to the combobox, so I went and added the field that I want added to the query that the combobox is based on. But when I went to go create a new ComboBox, it is not showing all the fields from the query it is based on! Why is this?
 

Lookup multiple columns in combo box

Preview
Is there a way to lookup information ina bound combo box based on either columns.

Here is a scenario I have a bound combobox with two columns Column(0), and Column(1) both visible. I want to search the combobox based on either value of both columns. In the words if Isearch ID it will lookup the value and if I search by name it will also lookup names.

Is there a sample VB script in the after update event of combo box that will accomplish that?
 

Lookup multiple columns in combo box

Preview
Is there a way to lookup information ina bound combo box based on either columns.

Here is a scenario I have a bound combobox with two columns Column(0), and Column(1) both visible. I want to search the combobox based on either value of both columns. In the words if I search ID it will lookup the value and if I search by name it will also lookup names.
 

display whole list of columns that comprise query in combobox

Preview
I created a combobox with the wizard. I have a query as the rowsource for the combobox. After I make a selection then it only displays one of the many columns in my query. It's important for me to display the whole list of columns as it is a person's full name
 

Add a value to a ComboBox where the first column width is 0cm.

Preview
I have a combobox with multiple columns. The first column is the bound column but it has a width of 0cm. The second column has a width greater than 0cm and thus is what is seen.

If I give this comboBox a value eg Me.cbo.value = "Text" it does not show up. I assume this is because it is adding it to the first column. But because "Text" is not in the list of items in the combobox there is nothing to show for the second column.

Thus is there a way to add a value directly to the second column which is not in the list of values for the comboBox.
 

RowSource question

Preview
I am using (2) combo boxes. The second is a requery from the first. I am getting "PartNumber" in the second combobox. I have several fields setup in the second combobox.

How do I get multiple fields to come out in the second combobox? Is there a way to add multiple fields to RowSource or do I need to do this differently?
 

How to use Access Columns Types in .NET

Preview
I need to know if there is way to figure out if a particular Column in an Access Table is of type "ComboBox" or "TextBox". For Example:

In Access I'm having a table "XYZ". This has 2 Columns "X" and "Y". In Access, I've assigned the "Display Control" tag (Open any Access Table->Go o to "Design View"-> Go to "Lookup" tab) as "Combobox" for Column "X" and as "TextBox" for Column "Y".

Is there a way that I can query this property in my C# code? i.e.

dc = DataTable.Columns[0];
if (dc.<To Figure Out>.ComboBox
 

Combobox display order

Preview
I have a table with a combobox in it. The records displayed in this combobox are in the same correct order as displayed in the source table. The problem is that when I select multiple values in the combobox they appear by default in alphabetical order in the table.
How do I get the selected data in the combobox to appear in the same order on the table as selected and not in alphabetical order? I think it may have something to do with the criteria section of the query that generates the combobox from the source table!
 

Combobox display order

Preview
I have a table with a combobox in it. The records displayed in this combobox are in the same correct order as displayed in the source table. The problem is that when I select multiple values in the combobox they appear by default in alphabetical order in the table.
How do I get the selected data in the combobox to appear in the same order on the table as selected and not in alphabetical order? I think it may have something to do with the criteriasection of the query that generates the combobox from the source table!
 

Multiple combo box search for multiple columns

Preview
A brief background. I am trying to build a genetic database for tracking the propagation of genes in a family.

This means a particular fish can contain 1+ genes at a given time. I have separated these genes into 4 columns for easy tracking. The problem is when it comes to building a search form.

A particular gene can be in one of the 4 columns. So I need to search for that gene in all 4 columns. There are also multiple genes to search so I will need to search all 4 columns based on how many genes there are.

genes contain a key so my original plan was to transfer keys to 1 new column and run
like "*#*" AND like "*#*"
to find the genes of interest.