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 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

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 :: 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

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

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

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

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 1 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

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

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

Columns In Forms!

Mar 31, 2005

HI

Is it possible to get more than 1 column per page in a continous form?

TIA

View 7 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

Forms :: Chart A Row In A Form Instead Of Columns

Dec 11, 2014

I'm a bit stuck on creating a chart in Access 2010. Not sure if I've set my table up right or not

Here's my table design

And the input form

My data is laid out like so

When I insert a chart though, I'm lost. It's like it's totally ignoring my data. The data isn't mine, it says east, north and west like a 'default preview chart'. The row source is

Code:
SELECT [student_id],Count(*) AS [Count] FROM [tblProgressLevels] GROUP BY [student_id];

Which means nothing to me I've managed to get most of the other stuff figured out, but these charts are confusing me.

Output??

What I want it to do is show how the student is progressing but I've got it all back to front I think. How could I lay my data out so I have a single English column, a single maths and a single science and they still go up in terms like my form shows; they're all in the same table at the moment laid out the same way as I set up the English tracking.

I also just realised I'm trying to chart alphanumeric values stupid boy... Can Access do a conversion where I make a lookup table so that 1c = 1, 1b = 2, 1a = 3, 2c = 4, 2b = 5 etc. or would a query work?

View 2 Replies View Related

Forms :: Autowidth For Columns In SubForm

Jul 10, 2014

I have developed an Access app, which has different navigational tabs which open up different forms. e.g. Tab A has Form A inside it and Form A has SubForm A1 inside it. For some reason, the following code is not working on any of the fields Me.YourFieldName.ColumnWidth = -2...some workaround so that all the fields in the subforms will have auto width adjustable to fit in the text.

View 8 Replies View Related

Forms :: Can't Get Columns On A Form To Resize

Apr 4, 2015

I can't get my columns on a form to resize and have the rest of the columns move along with it. So e.g. if I have a form with headers and under that a couple of records, I want to resize the middle of three columns. If I select the column and then select, with shift, also the column header, I can resize the column. But the column on the right side doesn't move along with it. So I have to reposition every column after the resized one.How can I get Access to pick up that I want to move the other columns too?

View 1 Replies View Related

Forms :: Formatting List Box Columns

Aug 13, 2013

I have a table of data (codes & amounts) which I want to display on a form via a list box (purely for information purposes; the list box will be locked / disabled). Basically, the list box will mimic a pivot table as it would appear in Excel, albeit without any of the filtering functionality.Codes can appear multiple times in the source table, each with a different value assigned to it.

The list box should have 3 columns :the unique code strings
the number of instances of that code string (i.e. Count)
the total value assigned to that code string (i.e. Sum)
In descending order based on the number of instances of each code

I have the following query set up to pull the data :

Quote:

SELECT tblData.Code AS Expr1, Count(*) AS CodeCount, Sum(tmp.Amount) AS CodeSum
FROM (SELECT Code, Amount FROM tblData) AS tmp
GROUP BY tblData.Code
ORDER BY Count(*) DESC;

I want the 3rd column of the listbox (the summed value) to appear as a formatted $ amount rather than a raw floating point. So "$10,000" rather than "10000.00". And, if at all possible, right aligned.But I have no way of formatting the columns of the list box (that I am aware of) either through the listbox properties directly or by VBA indirectly.Is there another way I can do this, either by applying the formatting to the query itself or any other trick to somehow apply the formatting as I need it?

View 1 Replies View Related

Forms :: How To Increase Width Of Columns In A List

Sep 10, 2014

I have created a list that has 5 column. Data is filled in list using a query. I know how to remove 2 columns, but I do not know how to increase the width of columns.

View 2 Replies View Related

Forms :: Drop Down Shows Both Columns When Selected

Jun 29, 2015

I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? First col is First Name, second col is Last Name.

View 3 Replies View Related

Forms :: Display Records As Columns Instead Of Rows

Sep 12, 2013

I think the answer to this question is going to be a flat 'No', but here we go.

I want to have something like a datasheet, except with with records shown as columns instead or rows.

For clarity, a datasheet displays records as rows, like this:

field 1 field 2
record 1 record 1
record 2 record 2

I'm wanting to present the data the other way around, like this:

field 1 record 1 record 2
field 2 record 1 record 2

Just to complicate matters, the number of records to be displayed is variable, so it should add more columns as required.

About the only option I can think of is to create a subform with fields stacked in a column without labels, and try to dynamically stack the forms as needed, hooking them up to the correct data on the fly.

Alternately, I wondered if I could dynamically generate a recordset with each record containing the field value of multiple records. I can see myself getting into trouble trying to update data this way however.

View 1 Replies View Related







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