Topics Search

Show multiple columns from a drop-down list

Show multiple columns from a drop-down list
Views: 62
I have a column in a table that is populated by a drop-down list / look-up table. The look-up table has 3 columns - autonumber, ID ref, and name. I need the column in the main table to show the contents of the ID ref and name column.

Is this possible? At the moment, when I click into the main column, the drop-down list shows the contents of the two columns (ID ref & name), but when I choose from the list, it only shows the contents of the ID ref.

If it isn't possible, can I change it so both columns are shown in the drop-down, but the contents of the name column are displayed in the table.
Sponsored Links:

More topics

 

Use arrow key in drop-down list

Preview
I have a form with multiple drop-down lists. Currently, when I go to each field, I still to use the mouse to click the "inverted triangle" to show the options in the list. I would like to just use the the arrow down key (instead of the mouse) to show the list. How do I go about that?
 

Sending multiple selections from a 'drop down' list in a Form to an append query

Preview
In Access I have a form with a drop-down list. I have set the form to 'multiple select' so I can select more than 1 item at once. At the end of the form is a button that runs an append query.

How do I get an 'append query' to insert all the items I have selected? If I have a drop-down that only allows me to select 1 item it works fine, but when doing multiple selections it just returns a blank. Screenshot below to show multiple selection.
 

Reports and changing the names

Preview
I am using Access 2010. I used a template called calltracker from Microsoft. I have adapted it to my use. Instead of tracking calls it is tracking follow ups. On one form there is a drop down list of reports that came with the template. I have modified the reports structure to fit my needs but in the drop down list they still show the names that came with the template. How can I change the names of the reports that show in the drop down list. How can I add additional reports I created to show in this drop down list
 

Issue with query when selecting from a drop-down list on a form

Preview
I have created a form in Access where the user selects a name from a drop-down list. The list has been derived from a table that already exists in Access. The form then executes a query to only show records that match the selection made from the drop-down list.

The problem that I have is it returns no records. If I change the drop-down list to a standard text box and type the name in manually, it brings back the records I want.

Why is my drop-down list not working? The query that is being run uses the table that contains the names so it can't be anything to do with additional spaces etc.
 

Selective Display of a List of items into A Combo Box

Preview
I have a table with multiple columns. Columns 1,3,5, etc are lists of names that I want to be used to display in combo boxes. The rest of the columns are corresponding columns to 1,3,5 which are of type Yes/No selection to determine if I want the name hidden or not.

Is there a way that I can get names from this list to display in a combo box, but make sure the ones that have the Yes/No box checked to be hidden?

So far I've been able to list the names in a combo box from a single column,
list the names in a combo box from multiple columns,
list the names in a combo box from a single column and hiding some of the options by using a query,
But when I try to list the names from all columns, it doesn't do what I want.

What should I do? I'm kinda
 

Lookup wizard/drop down list problem

Preview
I can't get the lookup wizard/drop down list to work properly. I have two fields that need a drop down list. the first works - it shows two columns, name and account; and populates the field with the account.

the second doesn't work - it shows two columns, name and item number; and populates the field with the name. what am I overlooking that is making it use the nameinstead of the account?
 

updating a drop down list

Preview
I have a form where you pick a course name from a drop down list. Next to it I created a button that opens for a form with courses names where you can add a new one. Then I save the new course name and close the form.

The thing is - the new name doesn't show on the original drop down list until I reopen the form. Is it possible to do something that it actually appearsstraight away?
 

updating a drop down list

Preview
I have a form where you pick a course name from a drop down list. Next to it I created a button that opens for a form with courses names where you can add a new one. Then I save the new course name and close the form. The thing is - the new name doesn't show on the original drop down list until I reopen the form. Is it possible to do something that it actually appears straight away
 

Get multiple columns with same value

Preview
I've got multiple columns for the CFName on each tbl. My question is how can I create a query which will list all the customers with supplier id SP102.
 

Sorting Columns in a Microsoft Access Listbox

Preview
When using a Microsoft Access Listbox, there may be times when the list is long and the data in this list is not sorted as you would like.
Obviously the list can be sorted in the first case, by basing the list on a query or SQL row source and setting a sort order on one of the columns in Ascending or Descending order. This list may, however, contain multiple columns that the user may wish to sort on and this is what we will describe in this article.