More Columns In 1 Combo Box

Jul 20, 2006

Hi All

I have to show two columns from one row from the same table into one combo bo. It should be One combo box with Name and Surname stored in one table.

If is there somebody?......

Thanks

View Replies


ADVERTISEMENT

Forms :: Fill Text Box Based On Combo Box (not Using Columns In Combo Box)

May 21, 2014

I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns being used to determine its own possibilities and other combo box possibilities.

I would really just like the text box to work like this, but im still kinda inexperienced in VBA...

If combo box is "F004-001", then text box is "237"
If combo box is "F004-003", then text box is "280"

I know how to add in an "after update" thing, but i do not know how to do If/then statements.

View 1 Replies View Related

Combo Box Columns

Jun 29, 2005

I hav a combo box that has three columns in it. I want the user to select an item and I want all three columns to show up in the combo box instead of just the one I am capturing. How can i do this? I tried to put the Bound Columns requirement in the the combo box's properties to 3 but it didn't do anything. Please Help.

thanks

View 3 Replies View Related

Combo Box With 2 Columns

Sep 15, 2006

i have a combo box reading in two fields from a table - id and name. Is it possible to have "autofill" pick up the name but when i make my selection, the id becomes selected.

i.e. if i have these:
ID NAME
1 Pete
2 Dave
3 Alan

and i type in "Dav" and press enter, the value in the combo box will be the id "2".

thanks

View 5 Replies View Related

Combo Columns

May 31, 2006

hi all

i have a drop down combo with 2 columns. the left column stores the value and the right column places a value in a text box uisng =[txtbox].column(1)

it works fine until i have a duplicate value in the left column. the right column makes the value unique. eg.

column0 column1
s1..............02
s1..............03

the problem ocurrs when choosing from the cbo with the same value. it always seems to slip back and choose the value with the lowest .column(1) value. in the above example, if I select s1 03, for some reason after the cbo drops back up, s1 02 is selected.... even though i didn't select it. weird!

Clearly i'm doing something access doesn't like.

Any ideas are much appreciated.

damon

View 4 Replies View Related

Referring To Columns In A Combo Box ?

Jan 26, 2006

Hello, I am using an IIF statement in my SQL criteria, and was wondering "if" it was still possible to reference a column within a combo box... here is one iif statement

Like IIf(IsNull([Forms]![fSampleSearch]![cboCustomerName]),"*",[Forms]![fSampleSearch]![cboCustomerName])

I want to refer to the third column of cboCustomerName... How would I do this ?

View 8 Replies View Related

Combo Box Based On 2 Columns

Feb 15, 2006

Hello everyone,
I have a combo box on a form tha displays information based on 2 columns from a table.What I want the combo to do is to allow the user to select the row he wants and for the field that is bound to the combo box to store the outcome of collumn1 + collumn2 (string values).
Is this at all possible and if so how can I do it cause I can't find a way.
Thanks for all your time and effort :)

View 3 Replies View Related

Combo Box Based On 2 Columns

Feb 15, 2006

Hello everyone,
I have a combo box on a form tha displays information based on 2 columns from a table.What I want the combo to do is to allow the user to select the row he wants and for the field that is bound to the combo box to store the outcome of collumn1 + collumn2 (string values).
Is this at all possible and if so how can I do it cause I can't find a way.
Thanks for all your time and effort :)

View 3 Replies View Related

Forms :: Combo Box Which Contains 2 Columns

Aug 20, 2013

I have a table with ProductName and QuantityAvailable...I have made a combo box which contains these 2 columns however there is no fieldname which I want.

View 1 Replies View Related

Forms :: Combo Box With Two Columns

Sep 21, 2014

I have a combo box with two columns. The first column has a drop down list of radiology studies (2view Cervical spine, 2view Lumbar spine etc.) the second column has the associated CPT code specific to that study. When I click on the drop down box on my form, the first column I can see both columns but when I pick one only one of them shows. Is there a way to see both columns or should I just add the CPT code to the first column?

View 2 Replies View Related

Forms :: Set Up Combo Box With 3 Columns

Jan 19, 2015

I am trying to set up a combo box that has 3 columns

The first column is the column I want to search on as I know the part number but it is the second column where I want the data to go into the combo box field

I cannot get the second column into the database

how do I set the combo box to do this

View 6 Replies View Related

Adding Combo Box To One Of Columns

Sep 26, 2011

I am extremely new to access. I am trying to add a combo box to one of my columns. Basically i have about ten columns of which a couple of them I want to have combo boxes so that the information that is in each of these columns is standardized. Currently all I have is my ten columns with headings set out.

View 3 Replies View Related

Displaying Columns In Combo Box Question

Nov 28, 2004

Hi, I have a combo with the following columns listed:

ProjectID
Project Number
Project Name

The width of the bound column (column 1) is 0, and Project Number and Project Name list properly in the combo box. However, on selection, only Project Number (Column 2) jumps into the box. Is there any way of getting the third column (Project Name) to also display after the selection has been made?

Many thanks

View 5 Replies View Related

Forms :: Searching All Columns In Combo Box?

Apr 17, 2014

I have a combo box with 2 columns, Item # and the Item Description. As of right now I have to type the Item # and it will autofill the text. I was wondering if there is a way if I don't have the Item # that I can search/type the description in the combo box field and it will autofill?

View 2 Replies View Related

Display Multiple Columns In A Combo Box After Selection

Feb 20, 2013

I have a combo box that takes its record source is a Query, this all works fine and when i click on the Combo box, I see 4 columns of data but when i select the record, only the first column displays, is there a way that I can display all 4 columns in the selected combo box, or will I have to have 1 combo box and 3 text boxes to display the data, is so how would I do that.

View 2 Replies View Related

Forms :: Selection From Combo Box - Show Values Of Columns

Jul 17, 2013

I have an unbound combo box with three columns, which get the values from a query. The first column is hidden. When I close the combo box after my selection, only the second column value is shown on the box. Is there any way that both the second and third column being shown on the box after selection?

View 3 Replies View Related

Forms :: How To Reorder Displayed Columns In Combo Box Dropdown List

Jan 10, 2015

I'm a newbie with Access, how to reorder the displaying of the columns in a Combo Box dropdown list of have in my Access 2007 application.

The columns that are being displayed are (in the current order):

Part Name
Unit Price
Parts.Web_Category

I want the order to be the following:

Parts.Web_Category
Part Name
Unit Price

View 13 Replies View Related

Modules & VBA :: Union All Query - Transposing Columns To Rows With Variable Columns?

Aug 8, 2013

I was able to use the UNION ALL qry. But, when I have another file (like original2) that does NOT have all the columns listed in the UNION ALL qry, I get a Parameter value box asking for the missing columns when I run the qry.

Example:

original1IDDateGroupChristianJohnnySteve 18/5/2013A1528/5/2013B338/5/2013C2348/5/2013D2358/5/2013E5

original 2IDDateGroupChristianJohnny18/6/2013A212528/6/2013B2338/6/2013C2248/6/2013D22

The UNION ALL qry includes all the possible resources ( includes all the possible column fields Christan, Johnny, and Steve).

When I run the UNION ALL qry with the original2 file, An "Enter Parameter Value" box is displayed with the mssing column name "Steve".

Is there a way to Map the original2 table into a working table with all the columns, or use VBA code to construct the UNION ALL qry to only include the existing columns? My data has variable columns and I'm trying to avoid the parameter popups.

View 2 Replies View Related

Queries :: Consolidate Multiple Columns Into Two Columns

May 14, 2014

I have a MS ACCESS 2010 database with a data table which i am trying to create a query from. I have 6 columns of data( one with an ID Field and 5 Name Fields). Below i have made examples of how it first appears as a simple query and the second will show you what i would like it to look like.

What the simple query looks like: [URL] ...

Second what I want the query to look like: [URL] ....

View 2 Replies View Related

How Do I: Sum Of Selected Columns & Linking Columns

Oct 30, 2007

Currently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table is for invoices.

In my invoices table, I wish to link the column for client reference (note: stored in the Clients table) to the column that precedes it. This column will list the clients’ names and is selected from a drop down list that is linked to the Clients table.

What I want to do (if its possible) is to have the respective client ref. automatically show up in the next cell once I've selected the client to whom the invoice relates?

Am I making sense? Is that possible? If so, how do I do it?

Secondly, how do I do a sum of selected columns for my “totals” column? Basically, I want to add the figures found in several cells that precede it?

View 4 Replies View Related

Totalling Columns & Rows Into Columns

Mar 22, 2007

I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here...

What I have is a database hat has column headers that look something like this:
Customer_Name, Order_Date, Qty_Ord, Unit_Price, Total_Price

What I'm trying to get is a query output that will have

Customer_Name, Total Orders (in Dollars) for January, Total Orders (in Dollars) for February, Total Orders (in Dollars) for March, etc.

I've been able to set it up to SUM for one month, but not multiples.

I know I'm totally lame (for proof read any of my previous posts) but you guys totally bailed me out the other time I asked a lame question.

Thanks in advance!

View 3 Replies View Related

Converting Rows To Columns And Columns To Rows

Jul 31, 2013

I am trying to convert a table that looks like the following...

Customer Name SumofSum of Bill Rate Reviewer
000462 John 500 Mike
000224 Mike 900 Jeff

I would like to covert it to....

Customer 000462 000224

Name John Bill
SumOfSum.. 500 900
Reviewer Mike Jeff

I don't think Access has any functions for this but I am not 100% sure. I know this can be done in a Module but I am not sure of how to code it.

View 12 Replies View Related

Forms :: Populate Combo Boxes With Values Depending On Selected Value In Previous Combo Box

Aug 5, 2013

I have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.

Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...

View 1 Replies View Related

Forms :: Change Record Source Of Combo Box On Form Based On Another Combo Box

Mar 31, 2014

I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.

So my questions are:

1) can this be done
2)If it can be done, how can I do it?

View 3 Replies View Related

Add Two Columns....

Feb 19, 2008

Hi All,
I have a Append query which has columns from two tables. Now i need to create a new column "Sum" in new table which should Add two of the Number columns .
That is : I have column A and Column B; I need to create a Column C which contains (A+B)
Please advise.

Thanks,
Kon

View 8 Replies View Related

Change Combo Contents Based On Previous Combo Selection

Oct 20, 2005

Hi everyone,

I have two combo boxes on the same form bound to a table. I want the contents of the next combo box to change based on the previous combo selection e.g

cboContinent cboCountry
Africa Zambia
Africa Congo
Africa South africa
Europe England
Europe Holland

If I choose Africa in cboContinent, I want to see only Zambia, South Africa and Congo under cboCountry and if I choose Europe I want to see only England and Holland

Thanks
Humphrey

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved