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 Replies


ADVERTISEMENT

Forms :: Displaying Tickmark For Each Record In One Of The Columns

Feb 14, 2014

I am attempting to display a tickmark (wingdings character 0252) . I have two columns with textbox controls. In each I display a -1 or Null, and the format is ; [Green] (corresponding to the 0252)

For each record, there can be a tickmark in one (and only one) of the columns, or no tickmark in any columns. The tickmark is set by clicking on the control. Unfortunately, the entire square occupied by the tickmark is selected, so it looks weird, so long as the cursor remains there. I want to get rid of that (it goes away by itself if I click on the other record).

I have tried to set the Txtbox.SelSTart=0 or Textbox.SelLength=0 , or change the value from -1 to 1 (that influences which position in the format is affected) ...but a postbox character keeps croppping up in theses instances.

View 2 Replies View Related

Forms :: Displaying One Field In Combobox In Multiple Columns

Jul 17, 2013

I have a multiple select combobox which shows up in many forms- SubCategories. The user can pick from a list of 154 SubCategories.

Everything is working properly however it is difficult for the user to scroll through the entire list.

My question: Is there a way to represent this ONE field in multiple columns in the combobox?

I know how to add columns for multiple fields to my combobox, but this is one field.

Maybe there is a better way to represent the data... a subform would have the same issue.

View 6 Replies View Related

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

Queries :: Joining 3 Queries And Displaying Results In Separate Columns

Jul 31, 2013

I have 3 queries named Mech Final Equipment 3 Mth, Mech Final Equipment 6 Mth, and Mech Historical Final Equipment.They all have two fields-Final equipment and Sum of Sum of Down (calculating the number of minutes each piece of equipment was down in the time period selected).

My ultimate goal is to join the three queries to display a pivot chart that uses the Final Equipment as the category field and 3 Mth, 6Mth, and Historical as seperate data fields.What I have is a join query (Which I have named Mech Final Equipment H63 Joined)

Using this SQL:

Code:

SELECT DISTINCTROW [Mech Final Equipment 3 Mth].[Final Equipment], Sum([Mech Final Equipment 3 Mth].[Sum Of Down]) AS Duration
FROM [Mech Final Equipment 3 Mth]
GROUP BY [Mech Final Equipment 3 Mth].[Final Equipment]
UNION

[code]...

Which returns a table that looks like this:

Final Equipment, Duration

Ancillary Equipment, 225
Ancillary Equipment, 401
Ancillary Equipment, 1787
Brush Unit , 1252
Brush Unit , 2519
Brush Unit , 8004

And so on.What I need the table to look like is this

Final Equipment, 3 Mth, 6 Mth, Historical

Ancillary Equipment, 225, 401, 1787
Brush Unit, 1252, 2519, 8004

And so on, like a cross tab.I tried to do a crosstab query but I don't have enough fields.

View 6 Replies View Related

Forms :: Displaying Combo Box Value

Jun 7, 2013

I have a DVD movie table and a lookup table for the movie genre. One selects the movie genre by opening a combo box which has the values. (Movie typeID which is a number and MovieType which is a text.The records are being displayed in a Access 2010 split form with the datasheet on the left. Any editing can be done on the right or the single record side.I would like to only display the genre for that movie as opposed to the combo box which can be edited and next to it have a command button to open a form in order to change or select the genre for the existing or new DVD.So, I guess what I'm asking is how do I display the genre fo that particular movie?

View 6 Replies View Related

Stop Drop Down From Displaying On A Combo

May 4, 2006

Hi all,

I was wondering if it is possible to prevent the drop down list from displaying on a combo box, and even better, to hide the drop down button. I know this just sounds like using change to and changing the combo to a text. However, as the text box doesn't have the same properties, it won't display the correct information and explaining how the combo box get its information is a little complicated. If there isn't a way, I'll try to explain in a reply. :)

Cheers,

Matt

View 3 Replies View Related

Displaying Records Dependant On Combo Box

Jun 8, 2006

Hi

Any ideas on how to autofill the rest of a form when i select from a combo box?

ie when i choose a name from the list i want the rest of the form to populate with the rest of the data relevant to the selection.

Cheers

View 2 Replies View Related

Forms :: Displaying 2nd Column In A Combo Box

Mar 26, 2013

I've created a form with a combo box to allow users to set the Manager of an employee. I've set the control source for the combo box to the Managers table that contains a primary key and the manager's name.

I've set the bound column to 1, the column count to 2, the column widths to 1;2 (I want to show both columns in the drop down because users can identify managers by either their name or Manager ID).After updating the combo box, the Manager ID shows rather than the Manager Name. Is there a way to have the Manager name show instead of the Manager ID without setting the column widths to 0;2?

View 5 Replies View Related

Forms :: Combo Box With 3 Items Not Displaying

May 7, 2013

I have two synchronised combo boxes that are working brilliantly except for 1 thing.

The two boxes are Site and Building. I find a site from the Site box dropdown and only the buildings for that site are shown in the Buildings box dropdown. Perfect!

However, I have got 3 fields showing in my Buildings dropdown.

Private Sub cboSite_AfterUpdate()
Me.cboBuilding.RowSource = "SELECT BuildingName, BuildingCode, Status FROM " & _
"BuildingT WHERE SiteID = " & _
Me.cboSite & _
" ORDER BY BuildingName"
Me.cboBuilding = Me.cboBuilding.ItemData(0)
End Sub

that is BuildingName, BuildingCode and Status.

All three show in the dropdown
BUT
only BuildingName shows in the actual Building Box and I would like all 3 to be visible once I have decided on the building name I need!!

Can this be done by changing

Me.cboBuilding = Me.cboBuilding.ItemData(0) (as above)
to
Me.cboBuilding = Me.cboBuilding.ItemData(0), Me.cboBuilding.ItemData(1), Me.cboBuilding.ItemData(2)
or something similar??

Or do I need to create 2 new boxes to return the other values?? I am so close to achieving what I want with this form!!

View 3 Replies View Related

Forms :: Displaying X Combo Boxes And Positioning Them

Mar 30, 2014

I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40.

On a datasheet, they are drawn as per the following image:

[URL]....

As you can see, the pin numbers run down the left hand side, then up the right hand side.

I have a table, tblPinouts. This has a text field called PinoutName and 40 number fields - Pin01 etc. It also has another number field - PinCount.

On a form - frmPinouts - the pin fields will be entered via combo boxes, which get their data from a table - tlkpSignals. However, I want the form to be visual, as per the picture. I've managed to draw a chip using boxes (as this seems preferable to using pictures), like this:

However, I want to adjust the 'drawing' accordingly for each chip. This means doing several things:
Extending the main rectangle downwards
Ensuring there are x small rectangles around the main rectangle at set points
Ensuring there are x labels inside the main rectangle at set points
Ensuring there are x combo boxes around the 'drawing' at set points

How can I ensure that only the first x combo boxes and small rectangles (x=PinCount) are present when a record is loaded, and that they are arranged correctly?

View 6 Replies View Related

Forms :: Cascading Combo Box Not Displaying Properly

Nov 18, 2013

I have a cascading combo box on a work order form that pulls the contacts from the customer selected in the main box.

It's working fine, values are printing fine on the reports, etc. however on the form itself - when you change from one record to another....the value is not displayed even though it's there if you click the report.

View 5 Replies View Related

Displaying Text Field Data For The Corresponding Combo Box Selction.

Nov 29, 2005

I am designing a database for my Bank.
But I have a problem, please give solution If you can help me.

I have a Table name "BranchName",purpose for entering Branches of Bank.
Fields are as below.
SrNo. (Auto Number)
BrName (Text)
BrCode (Number)
Region (Text)

Now I had made a Form "Branch".
On this there is one Combo box in which all "BrName" are shown.I made that.
Now I made another Text Field where I want to show the corresponding "Region" automatically appears for the selected "BrName" .

Now how I make this.Any Query or Code Builder Event ??????

View 1 Replies View Related

Forms :: Multiple Column Combo Box - Displaying Values?

Mar 4, 2015

I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly.

1 - Can I display the values from both columns after the selection has been made?

2 - If not, can I choose to display the second column (not the first) after the user has made a selection?

View 3 Replies View Related

Displaying Data From Combo And Text Boxes In A Single List

Feb 6, 2005

I have several combo boxes and textboxes showing quanity,productname,
size, and price. How can I pass all of this info in a single row that also calculates
the quanity and price. Also, multiple selections can be added, so several items can
can added in other rows. THe ability to cancel each row would be required as well.
Thanks

View 2 Replies View Related

Forms :: Displaying Initials In Combo Box When Option Selected From Drop Down

Oct 2, 2013

I have a Combo Box bound which gets its values from a table (T_Users).

The Combo Box displays the Users 'Initials' [Column 1], but the Bound Column [Column 2] is that of the Users 'ID' (which is used when a record is edited or a new record added).

What I want to be able to do is when the user clicks the Combo Box, and the drop down list 'drops down' the options, I want them to not only see the 'Initials' but also selected other columns - BUT - when the option is selected I just want the 'Initials' to be displayed in the Combo Box.

Code:
So, Normal > | ABC |

Dropped Down > | ABC |
--------------------------------------------
| ABC (Annabel Carcus, Big Company Ltd.) |
| JB (Joe Bloggs, Medium Company Ltd.) |
| FS (Fred Smith, Little Company Ltd.) |

Select JB, and > | JB |

View 6 Replies View Related

General :: Access 2010 / Combo Box Not Displaying The Correct Item?

Apr 28, 2013

Using ms access 2010, I created a table called all items contains the ID, item name, item code, item price.

Second table I created called orders, contains item1,Q1=quantity,Tot1=calculated field.

Then a form to fill the orders table with a combo box for Q1 (gets the value from a table called numbers), second combo box for item1 (gets the value item code and item price from the table all items), and a text box to calculate the total of the Q1-item1(item price) All working perfect except the combo box for item1 ends up displaying a different item code that's only if the items were at the same price, for example, I choose latte from the combo box gives me correct item price but the code is cappuccino, only happening with items with the same price.

If I set the property of the combo box Bound Column to 1, I get correct item code but calculation error, Bound Column to 2, I get correct calculations but wrong item code. how to get the combo box to display the correct item code?

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

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

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







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