Using A Non Bound Column In A Combo Box

Nov 9, 2004

I have a combo box that has two columns, the second one is bound.

Is there any way to reference the 1st column (the unbound one).

What I actually want to do is have the 1st column show up as a status line message or as a quick help message when the combo text is mouse_overed. The problem is the combo box field is a date that is unique 99 % of the time but in that one percent the user needs to see the beginning of the 2nd column ( think of a persons doctors appointments, where one percent of the time a individual needs to visit the same doctor twice in one day , in which case the procedure and the date becomes the selection criteria (but I don't want to show the procedure and the date in the combo box because the procedure is so darn long.)

Confusing enough?

Any ideas?

Thanks

View Replies


ADVERTISEMENT

Combo Box And Bound Column Settings

Nov 21, 2013

I'm looking for a work around for getting the bound column setting for a combo box to work. I created a simple table with 2 fields that i have a combo box pointed to. My settings for the combo box are

Column count 2
Bound column 2

The first field is "Description"
The 2nd field is "ID"

I cannot figure out how to have column 2 to be the value that is left in the combo box once I have made my selection.

View 14 Replies View Related

Forms :: Filter Combo Box Value - ID Is Bound Column

Mar 15, 2014

There are 3 column in a combo box, ID is bound column

Part no ID Description
0040 1 class 40-1
0040 2 class 40-2
0040 3 class 40-3
0041 4 class 41-1
0042 5
0042 6

When key in part no 0040, 3 rows under 0040 will be listed out only, filter and match as value entered only. do not show others part no in the combo box selection.

View 1 Replies View Related

Combo Bound Column To Word Bookmark Conflict

Jul 6, 2005

Ok....Just when you think it's all running smoothly.... :(
I have a combo box, MDLastName, with a column count of 9, with column 2 displaying and all others hidden. The selection made with this combo populates 7 corresponding fields (first name, address, etc). It's working perfectly.

The first problem I encountered was with identical last names, but different corresponding data. When I selected Jones, for example, it would populate the first Dr. Jones and his info, listed in the table. However, if I selected the second Dr. Jones in the combo list, it was still populating only the first Dr. Jones' info. I resolved this by binding the fist column (ID, aka primary key), but still hiding all colums but column 2. First problem fixed..

Next, I have a Word Template document bookmarked to receive data from the form, frmDenial. I have all the coding working fine and dandy to insert the data from the fields on the form, save, and print. However, instead of inserting the text from the MDLastName, it is inserting the primary key (because it is the bound column in the combo box). Now, because of the first problem discussed above, I cannot change the bound column to column 2 (containing the data I need in the Word Template). How can I get the right info to appear in my template with the bookmarks?

View 1 Replies View Related

Forms :: Bound Column In A Combo Box - Transfer Two Values

Jul 9, 2014

In my form my combo box displays a list from a query called DORP-HDR that has 3 columns

DORP-ID | CODE | NAME

and displays them like that is the drop down list

The form field that the combo is bound to takes the numeric-id field as its value. In the combo control wizard i nominated that value, and in the properties pane bound column value is 1.

and in the properties pane the row source is:

SELECT [DORP HDR].[DORP-ID], [DORP HDR].[CODE], [DORP HDR].[NAME] FROM [DORP HDR] ORDER BY [NAME];

So far so good. I have created lots of combo boxes before like this.

But this time i want the second field in the list (CODE) ALSO bound to another field in my form . So I want the combo to transfer two values not one. How do i do this?

View 4 Replies View Related

Bound Column Passed To Textbox

Oct 29, 2006

I have a combo box that has 3 columns. What I am trying to do is get the third column to be passed as the value to another textbox after the combo box is selected.

combo box sample data: Male/John/NY
the 3rd Column which is state I would like to have it sent to the State Field...

View 2 Replies View Related

Listbox - Bound Column Text Field

Aug 10, 2005

Hi

I've created a listbox and am using the following code

stWhat1 = "": stCriteria1 = ","
For Each vItm1 In Me!LstArchive.ItemsSelected
stWhat1 = stWhat1 & Me![LstArchive].Column(0, vItm1)
stWhat1 = stWhat1 & stCriteria1
Next vItm1
Me!txtCriteria1 = CStr(Left$(stWhat1, Len(stWhat1) - Len(stCriteria1)))

The problem is that my bound column is a text field. I'm really struggling on where to put my quotations so that I get the following with the In function
In('00638','00639').

Any help or pointing in right direction would be very much appreciated
Carrie

View 3 Replies View Related

Modules & VBA :: Get Other Than Bound Column From Multi-select Listbox

Feb 6, 2015

I have two listboxes. One for Activities and the other for Organizations.

I set the Org listbox to be multi-select so I could run a loop on that listbox to join multiple Orgs to a single Activity. That part works well.

To do so, I am using the bound column (which is the pkey value) from the multi select listbox, and on the single select listbox I'm using the ListboxName.value to gather the pkey for the "1" side of this 1:Many series of inserts.

Now... I want to use one of the other-than-bound-column value from the multi-select listbox, but I don't know how. When setting a value I only know of the use of :

Code:
ListBoxOrganizations.ItemData(varItem)

and I don't know how to do the equivalent of

Code:
ListBoxOrganizations.ItemData(varItem's column(2).value)

yes, I just made that up, but I hope you get the point. Meaning, as the loop cruises the ItemsSelected on the multiselect I'd like to use other than the bound column when setting variables.

I've tried using the column property to then cruise to the proper record in the listbox, e.g. :

[code]
txtCollaborationDesc = "Collaborate " & ListBoxOrganizations.Column(2, varItem) & " with " & listboxActivities.Column(2)
[code]

But this seems to return the column(2) value of the first record loaded into the list box, as if the varItem piece is being ignored. I believe the loop is working properly, as when the inserts are happening correctly with the bound column of the multi-select list is correctly present as an Fkey in the resulting child records.

I just can't get any other column's value for some reason.

MS Access 2010 and this is an accdb.

View 3 Replies View Related

Tables :: MS Access Setting Relationship And Bound Column

Jun 14, 2013

I have three tables.

Table 1: Group

Field 1: Group Text field ( Primary key)
Field 2: Group Description Text field
Field 3: Uidgroup( Autonumber)

Table 2: Subgroup Text field

Field 1: Group ( I want to bound this column to Table 1's Group field that is column 1) I have set bound column property to 1 and column count 1 and the Subgroup table is showing group fields as input perfectly no issues in that )

Field 2: Subgroup, Text field( Primary Key )

Field 3: uidsubg( Autonumber)

Table 3: Email

Field 1: Group ( Bound to Table1's Group ; showing values in combo box, setted bound column property to 1 and showing group field perfectly, no issue in that )

Field 2: Subgroup (I want to bound Table2's subgroup field, which is column number 2, so I wrote 2 in bound column property and row source is table subgroup ; Here is some error comes up, values from subgroup field of subgroup table not being shown up in Email Table's subgroup field as combo box. )

Field 3: Email Text field

Field 4: uideml (Autonumber ) primary key

I want to prepare a Data entry form should have all these fields from all the tables. That should work in following way, first user selects Group then User selects Sub Group and write Email and save the record.

What relationship should I set, or shall I change the table structure.

View 1 Replies View Related

Forms :: Form Field - Setting Bound Column

Sep 2, 2013

I'm using Access 2007. I've created a table with two fields. "Novice and Recertification" as in combo box.

I put it on the form. Now the idea is when a user clicks Recertification, it shows up on the report. When the user clicks on Novice, it should be empty on report (Reason why I want to keep novice is so that we have a record of it.)

Now the challenge is I added another column, empty field for Novice and Recertification for Recertification. Thing is if I set the bound column, I select on an empty field on form and it will be empty on report. But I want the user to see Novice on the form and it must not show on the report.

View 3 Replies View Related

Auto-fill Based On A Field Other Than Bound Column?

Feb 9, 2015

Access 2010. The first table is called Clients.The Primary Key field for the Clients table is an AutoNumber field called ClientID.The other two relevant fields in this table are ClientFirstName and ClientLastName. The second table is called Contacts.In the Contacts table is a foreign key field, bound to the ClientID field from the Clients table, and also named ClientID.

On the Contacts table, the ClientID field properties are set on the Lookup tab as follows:

Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT clients.ClientID, clients.ClientFirstName, clients.ClientLastName
Bound Column: 1

Further, in the Row Source's Query Builder, ClientFirstName and Client LastName both have Ascending selected as Sort criteria.

Everything works as intended: When entering data into the the Contacts table (actually, the data is entered via a form built from the Contacts table) the data entry person can click the drop-down on the combo box for the ClientID field, scroll through ClientID records, and see unique ID numbers sorted by first and last names. And the actual data for the field is stored properly as the unique ClientID number.

When entering ClientID data into the Contacts table (or form), is it possible to enable autofill based on ClientFirstName and ClientLastName, rather than ClientID? For instance, let's say we have a few clients named Joe Smith. It would be great to just start typing "Joe Smith," and have the field autofill the ClientID number for the first client named Joe Smith. The intention is to make data entry a bit quicker.

View 3 Replies View Related

Referring To Bound Column In Multi Select Listbox

Dec 12, 2012

So I have a list box that lists organizations. I recently changed the list box type to extended multi select. On the same form, I have a button that opens a new form where the user can input contacts for each organization. When the list box was not multi select, the expression [forms]![media]!

[List30] made the default value of one of the fields in my contact form the bound column from the selection in the list box. However, now that the list box is multi select, the contact input form does not seem to be able to get the value from the bound column in the list box. When multi select is turned on, is the bound column stored differently.

To even get the contact input button to work, I had to change the code from:

Private Sub Command40_Click()
On Error GoTo Err_Command40_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Contactsqry"
stLinkCriteria = "[Organization ID]=" & Me.List30

[Code] .....

View 14 Replies View Related

Control Can't Be Edited; It's Bound To The Expression '[Form]!EmpList.Column(13)'

Aug 8, 2005

On my form, I currently have a combo box that updates text box data with each new selection. However, after these text boxes for FirstName, LastName, etc. are updated, they cannot be edited. Here is the error message that appears in the status bar:

Control can't be edited; it's bound to the expression '[Form]!EmpList.Column(13)'


I'm thinking it might be a result of the data source for the text boxes being a combo box expression.
Any suggestions on how to fix this?
Thanks. :)

View 2 Replies View Related

Table Field Properties - Bound Column Only Accept Numeric Value?

Oct 22, 2014

I try to put an expression for the property "bound column" so that my lookup values will be directly dependent on one of attribute's choice

I have got four options for my attribute. Each option will use a slightly different set of lookup values. I save all four sets in another table.

Then in my properties definition I refer directly to this table as lookup base. When I put bound column number equal to an expression so as to choose the right column of lookup values it refuses. It seems that it does notl ike anything other than a numeric value.

If that's a no-go, I am not sure how to achieve what I try to do then?

Essentially I have a table that 4 attributes: QID,itemID,CatType,Catchoice

CatType can have only 4 values. Each value will make Catchoice take on a different set of combo values

The problem I am having is that I am stuck at the Catchoice lookup definition because it is dependent on what kind of CatType the user picks.

View 1 Replies View Related

Changing Column Widths In Subform Bound To A Query Throws A Prompt

Aug 22, 2006

i have a subform on a form with Source Object="Query.myquery", my form is generating a sql string dynamically and assigning this sql string to the RecordSource property which works fine. But now if the user changes the width of the columns in the subform and close the form , a prompt is thrown asking if the "myquery" needs to be saved. I dont want to save the settings of "myquery" but at the same time avoid this modal dialog. If i use DoCmd.SetWarnings=False , i dont see the warning anymore BUT the query gets saved.

I am using "myquery" to just display column names in the subform when the forms loads and also without it i cant directly use RecordSource property in my code.

any suggestions?

View 1 Replies View Related

Adding (All) To A Bound Combo Box

May 24, 2005

Hello,

I have a bound combo box on a form. The selections alow a subform to refresh limiting records to the bound combo box. I have been on the web a lot looking for a way to enable multi list selection or all on a combo box. None of these have worked for me. The selection combo box is a simple Yes or No. I would like to add all and have it return both types of records.

This is the sytax I have in the row source property for my combo box.

SELECT [Sales Master].[Accounting Comp Flag] FROM [Sales Master] UNION Select "All" FROM [Sales Master] GROUP BY [Sales Master].[Accounting Comp Flag];

This code allows the combo box to have an all selection but it does not retrieve any records.

If someone can find my mistake that would be great! Thanks!

View 7 Replies View Related

Text Box Bound To A Combo Box

Jan 24, 2005

Hi,

This one is really confusing me!

I have a text box on a form that is bound to a field in a table that is populated by a combo box coded into the table whose data source is a select query.

Everything looks fine in the table, but when I display the data on the form it is displaying a different field of the source select query than the one displayed on the table.

Why is this, and how can I fix it?

View 1 Replies View Related

Bound Combo Box Query

Oct 13, 2006

If I want to be able to save new data to a field from a combo box, what code do I need.

I found the code below which said it was for an unbound combo box. Not sure what to change. I've set it as my event procedure for "On Not In List" and the query runs ok but nothing else seems to happen. Thats while I have nothing in the control source.

If I amend control source to be the field I want, (which is the same as what I already have in the row source, then it won't let me select anything from the combo box drop down at all.

Not sure what to do? Any ideas please??

Private Sub Combolook_NotInList(NewData As String, _
Response As Integer)
Dim ctl As Control

' Return Control object that points to combo box.
Set ctl = Me!Combolook
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbOKCancel) = vbOK Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string in NewData argument to row source.
ctl.RowSource = ctl.RowSource & ";" & NewData
Else
' If user chooses Cancel, suppress error message
' and undo changes.
Response = acDataErrContinue
ctl.Undo
End If
End Sub

View 2 Replies View Related

Forms :: Combo Box - Bound Option Not Available

Mar 28, 2013

I have tried creating a combo box in a form and as I have gone through the steps, the option to bind each choice that I created in my drop down box for the form is not an option, so how do I make each choice in my drop down box access the report I need?

View 1 Replies View Related

Bound Cascading Combo Boxes In Continous Forms

Jul 19, 2006

My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up. please help!!!


I have attached a copy of my database.

View 4 Replies View Related

Combo Column: SUM, IIf, Yes/No

Oct 6, 2005

I have a combo box with the following 4 columns:

ItemID, Item_Name, Item_Cost and Taxable.
The fields are Autonumbered, Text, Currency and Yes/No, respectively.

I am trying to SUM sales tax, in the form footer, based on the Yes/No settings. Some items are taxed and some are not.

So far, I am able to get tax calculations on everything, only.

With this code as Control Source for the footer control:
=Sum(IIf([Taxable]=0,([Item_Cost]*[Quantity])*0.0556,0))
I get tax calculated on every item, regardless of its taxable flag.
When I use:
=Sum(IIf([Taxable]=1,([Item_Cost]*[Quantity])*0.0556,0))
I get no tax calculated at all. Always comes out zero.

For some reason, the calculation isn't distinguishing the Yes/No values for each record, independently.

Can anyone assist me in fixing this?

View 11 Replies View Related

Use Value Of Column From Combo

Nov 16, 2004

I have a combo box with three columns bound to column 1.

I want an If statement to execute on the value of the contents of column 3 which contains text C or D.

How can I do this? I've tried

If Me.MyCombo.Column(3)="D" then
TakeSomeAction
Elseif
Me.MyCombo.Column(3)="C" then
DosomethingElse
end if

Thanks

View 1 Replies View Related

Stipulate Combo Column In SQL

Mar 24, 2008

My combo(cbxCombo1) has two columns - The code below is working on the ID - Bound Column in cbxCombo1 Where what I actually want is the second column(the bound column has to remain 2 in cbxCombo1 as I am inserting text and not an ID to the table...So what I actually need is to stipulate column1 in strSQL = "Select " & Me!cbxCombo1.


Private Sub cbxCombo1_AfterUpdate()
Dim strSQL As String
strSQL = "Select " & Me!cbxCombo1
strSQL = strSQL & " from tblModels"
Me!cbxCombo2.RowSourceType = "Table/Query"
Me!cbxCombo2.RowSource = strSQL
End Sub


Cheers
Andy

View 3 Replies View Related

Multi-column Combo Box

Sep 15, 2005

I have a combo box with 5 columns. When I click it I want to display columns 1 to 4, together with the headings. But after making my selection, I want column 5 stored in the field.

How can I do that? Currently it is storing column 1.

Thanks,

Dave

View 2 Replies View Related

Reading Combo.column(1)

Dec 24, 2006

on the audit trail modul

when the field is combo box I need to capture the combo's column(1) to my audit trail table

i used the code :

If TypeOf ctl Is ComboBox Then
rst("OldValue") = ctl.OldValue.Column(1)
End If

but it's not working

can any one help me with that

many thanks in advance

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







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