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
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.
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 RelatedI 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 RelatedI 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 RelatedI 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 RelatedI'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
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
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
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
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
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 ?
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 :)
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 :)
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 RelatedHi, 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
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 RelatedHI
Is it possible to get more than 1 column per page in a continous form?
TIA
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.
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?
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 RelatedI 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 RelatedI 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?
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 RelatedI'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 RelatedI 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.