Topics Search

Binding multiple columns in a combobox

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

Similar posts...

 

ComboBox not listing multiple columns

ComboBox not listing multiple columns Icon
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

Lookup multiple columns in combo box Icon
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?
 

display whole list of columns that comprise query in combobox

display whole list of columns that comprise query in combobox Icon
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.

Add a value to a ComboBox where the first column width is 0cm. Icon
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

RowSource question Icon
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

How to use Access Columns Types in .NET Icon
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

Combobox display order Icon
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!
 

Multiple combo box search for multiple columns

Multiple combo box search for multiple columns Icon
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.
 

Validation of ComboBox values

Validation of ComboBox values Icon
Using Access 2003. I have 2 tables (t_Data and t_Standards). I have 1 form (f_DataInputTemp). The form is based on t_Data with a combobox that selects records from the t_Standards table.

This Combobox lists 5 columns; ID, DuroLow, DuroHigh, PostLow, and PostHigh (these names are shortened here)
On the form there are 2 fields where data can be input that must be validated as being between the appropriate highs and lows.
 

Trying to sort data into multiple columns on the report.

Trying to sort data into multiple columns on the report. Icon
Access 2007 I have 1 data column that I want to get on a report, but I want it to break into two/three columns like so and have some space inbetween the columns:

1 | 7 | 13
2 | 8 | 14
3 | 9 | 15
4 | 10 | 16
5 | 11 | 17
6 | 12 | 18

The reason is this is a single checklist for people to fill out and multiple pages is unacceptable. The list will be printed.