Queries :: Unable To Select Item From Combo Box
Feb 2, 2015
So I have this form with a combo box which successfully displays a range of items from which I would like to select from - but unfortunately I cannot. I cannot select anything from the combo box.
I have checked the form and table to ensure I have edit rights - which I do.
The form is based on a query - attached is a picture of the relationships within the query.
I assume I have created a non updateable query but this is only an assumption.
I am lost about the best course of action to take. Is there a way to identify the problem?
Do I just cut my loses and recreate the functionality somehow?
View Replies
ADVERTISEMENT
Oct 24, 2006
Have a subform:
Name: frmProjectSub1
Default View: Continuous Forms
A combo box within the subform:
Name: cboProjectName
Control Source: Nothing
Row Source Type: Table/Query
Row Source: SELECT ProjectName FROM tblProjects WHERE tblProjects.Status LIKE "*" ORDER BY ProjectName;
Column Count: 1
Bound Column: 1
Visible: Yes
Enabled: Yes
Locked: No
Allow AutoCorrect: Yes
Tab Stop: Yes
OnClick Event:
Private Sub cboProjectName_Click()
With Me.frmProjectSub1.Form
Me.RecordsetClone.FindFirst "[ProjectName] = " & Me.cboProjectName
If Me.RecordsetClone.NoMatch Then
MsgBox "Can't find task " & Me.cboProjectName
Else
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
End With
End Sub
Within the continous form, if I name the Control Source as ProjectName, and traverse through the records, the value in the combo box changes to the current selected row.
Problem: In the combo box, I do get the dropdown list of projects, when I click on a project - Nothing Happens! The listbox stays open on the item that I clicked on -- does not close-up and put the selected item in the combobox window. I'm stumped...
View 3 Replies
View Related
May 13, 2005
hi All..
I could set the Combobox.Value to one of the values in the combo box and combo box displays that value. But when I try to use Combobox.Value subsequently it does not have any value. I noticed that the value property is populated only when the combox box item is manually selected(highlighted).
How can I highlight the selection in a combo box?
Thanks in advance
View 1 Replies
View Related
Aug 12, 2005
Which event to allow to select the item from the Combo Box?
I try "click" and "change" events, but it do nothing?
Please help.
View 1 Replies
View Related
Jan 7, 2005
I have a combo box(drop down box), it uses a select statment to get data.
I want to assign each choices (item) from the combo box to a label's caption.
for exmaple the comobo box has these choices (item)
______________
|drop down box|
apples
pears
grapes
melons
I want to have 4 labels each label will have caption equal to each item in the drop down box so we now have
apples as label 1's caption
pears as labe' 2's caption
grapes as label 3's caption
melons as label 4's caption
how might I be able to do this in VBA?
IS there a way to select an item from a combo box and the set the label's caption equal to that?
Something like:
combobox.item1.value = string1
combobox.item2.value = string2
combobox.item3.value = string3
combobox.item4.value = string4
label1.caption = string1
label2.caption = string2
label3.caption = string3
label4.caption = string4
thanks for any help you might be able to offer
View 10 Replies
View Related
Jun 5, 2014
I have a combo box that won't allow me to select an item. The box is on a subform. When viewing only the subform, it works. When viewing the subform from the main form, it won't work.
View 8 Replies
View Related
Apr 23, 2015
I have a multi slect list box (simple) and I need to find and select an item using vba - e.g., the bound column is the ID field and I need to select a specific ID (which will be different each time) as opposed to selecting the 100th record for example. How do I do this?
View 2 Replies
View Related
Jan 7, 2008
I have a form that has a combo box that contains every query in my database. This worked fine until i started having to create cascading queries to return the data I want. How can i populate my combo box with only certain queries in my database.
This is the code I was using to put all queries into my combobox.
FROM MSysObjects
WHERE MSysObjects.Name NOT LIKE "~*" AND
MSysObjects.Type = 5
ORDER BY MSysObjects.Name;
Upon clicking a button or clickin the query in the list, I want the query to run......So the main question is how to I include certain queries in my combo box but not all of them? I do not know SQL or any programming, so as specific as possible will help immensely. Thank you everybody.
View 1 Replies
View Related
May 9, 2005
Hi Everyone!
I'm having problems and am frustrated as usual ;)
I'm trying to select a specific row in a listbox in the OnKeyDown event on my form. Basically, while in a subform, I want the enter key to move the focus to the list box, specifically to row After the last selected.
Here's an example of the code I thought would work:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Dim ItemNumber As Integer
ItemNumber = Forms![Product Inventory System]![InvList3] + 1
If KeyCode = vbKeyReturn Then
Forms![Product Inventory System]![InvList3].ItemData(ItemNumber).SetFocus
Else
End If
End Sub
I just started the Atkins diet today, so my sugar and caffiene levels are non-existant. (Seems like an easy excuse, right?)
Can anyone offer any insight into what I'm doing wrong?
Thank you so much!
Ben Bolduc
View 2 Replies
View Related
Jan 26, 2006
I have a combo box whose RowSource is set to
SELECT [Part Numbers].[Part Number], [Part Numbers].[Part Description], [Part Numbers].[Supplier Name] FROM [Part Numbers];
When I go to the Properties window and click on '...' to check the results of this query, I see exactly what I expect to. Likewise, clicking on the combo's drop-down arrow displays the data correctly.
However, when the combo box is displayed on it's Form, #Name? is always displayed and, while I can view the items in the list, I am unable to select any of them.
I've got a feeling this is going to be a simple correction, but I can't work out what's wrong and it's bl**dy infuriating.
Any suggestions gratefully received.
View 1 Replies
View Related
Jun 29, 2007
I would like to be able to create a recipe (saved in its own table) by pulling items from a multiselect list box (from the raw materials table) but which allows me to add the same ingredient more than once.
I work for a chemical manufacturing company and we need to track the cost of goods by recipe (final product), by linking the ingredients (where the cost of the raws are associated) to the final prodcut. Several of our products need to have chemicals added in the beginning, but then again at the end of the procedure unlike normal kitchen recipes.
(I sure hope I don't have to learn VBA . . . I'm totally new at Access!)
Thanks in advance for your help.
View 3 Replies
View Related
Dec 30, 2014
I want to select an item in a listbox that has a specified value when I open the form that contains this listbox. Most I've found describes selecting records based on their index value but I want to select an item according to the actual value that's displayed in the listbox. For example, the first number below is the index value, the 2nd is the number I'm interested in and the 3rd is another column in the listbox:
0 1 12345
1 2 33256
2 4 36280
I'm using the OpenArgs property to pass the value (a long integer primary key) to the opening form but I don't know the syntax or correct terminology for ensuring the specified row is selected in the listbox. At present, using the above example, if I want to select the row with the value 2, it's selecting the 3rd row rather than the 2nd.
View 8 Replies
View Related
Jul 29, 2013
At the moment I have a query that returns a result based on what's selected in a combobox.
SELECT ComponentT.ComponentType AS ComponentType
FROM ComponentT
WHERE (((ComponentT.TotalComponent) Like [Forms]![DeviceF]![D_ComponentNameCmb] & "*"));
Instead of this I want to rewrite the query to return a result based on what the user has selected in a list box of items. How would this query look. Would I need to increment it in a loop checking all entries into the list box as it can vary in size and if so how?
I tried changing the last line to WHERE (((ComponentT.TotalComponent) Like [Forms]![DeviceF]![D_OutputLsb].[ItemsSelected] & "*")); which returned a result just not the right one. Is there something wrong with the syntax?
View 4 Replies
View Related
Apr 11, 2013
I'm new user converting over from Lotus Approach. I'm using Access 2013.
I have a database with two tables being Suppliers and Products. This is a one to many type database with Suppliers being the one table.
Both tables have their own data entry forms.
In the Products table and data entry form is field named Category with a value list of about 20 different values. The query I need to create is to search on the field value from one of the listed values in the associated combo box.
I have set up the basic query using the Query wizard. To run This I have to entry the value I wish to search for in the Query in Design mode.
My problem is now I want to drive the query from a new form. On the new form I have created a combo box where the field list is the same as on the product data entry form.
I need to use this combo box to select the Category field value I need to search for and then click on the button to run the query. I seem to be stuck on the SQL code to achieve this...
View 2 Replies
View Related
Mar 19, 2015
I have a split form, populated with my DVD movies, with the datasheet on the left. On the right I have 3 fields. Title Movie Type and Movie Description. All are enabled. But, today I was unable to select the Description field. I would click in it but the cursor would not enter to field. I needed to select another field and the then I was able to select Description. I was able to select the field programmatically. I needed to find a form from a backup and replace it.
View 12 Replies
View Related
Feb 1, 2014
I have a contineous form with a combobox for each record and i have a button to select the first item in the combobox then to refresh the list in the combobox .I want to creat a one button to select the first item in the combobox then refresh the list then go to the next record and select the first item on the list
View 2 Replies
View Related
Sep 22, 2014
I have a combo box on my form that passes criteria to a simple select query. There are four possible selections to make from the combo box. For some reason, when I select the first option on the list the query runs perfectly. However, if I select the second, third or fourth option from the combo box, the query returns no records, even though I know there are records in my table which should be returned.
View 5 Replies
View Related
Apr 3, 2014
I'm wondering is it possible to create a multiple parameter query which will return results even if you leave some of the parameters blank ?. I'm trying to set up a Form which will allow users to select parameters using combo boxes but at the moment you need to fill them all in or you'll get no results...
View 10 Replies
View Related
Apr 14, 2014
I have validation on a checkbox on a sub form and after the validation fails and the cancel = true is executed in the before update event, I am unable to select the checkbox on the form. Access will not allow the selection. my subform is called frmContactType so hopefully I am referencing it correctly:
Me.frmContactType.Form.chkAssociate
View 4 Replies
View Related
Jan 8, 2015
I am attempting to create a Macro that will export the COMPLAINT table to an Excel Spreadsheet. However Excel does not open and I am prompted to select the Program I want to use. What am I doing wrong?
View 1 Replies
View Related
Jun 27, 2012
I'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.
At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.
I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails
the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.
What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.
View 7 Replies
View Related
Jun 4, 2014
In the form1 , I have a listbox1 with 2 columns. The values get added in the listbox using vba. Now I want to Edit the listbox values in case user enters something wrong. So when the user selects a listbox item and then EDIT button then form2 gets opened. And the textbox1 of it stores column1 of listbox1 value and textbox2 stores column 2 of listbox1 value. So the user canb make changes in the textbox values and then press SAVE button . Now I want the code that will make those changes in listbox1 of form1 and unload form2 then.
View 2 Replies
View Related
May 6, 2014
I have a subform containing a list of Funds and attributes such as Asset Type, Fund Manager, etc.
Currently, I have a textbox, where the the control source is set so that it will be updated with the Asset Type from the subform.
I also have an unbound combo box that contains a list of Asset Types queried from a table via row source, where user can select the Asset Type.
What I would like is when a record is selected from the subform, the Asset Type is selected on the combo box as a default value. User can select another Asset Type if required. How can I do this?
View 1 Replies
View Related
Sep 9, 2005
When a user enters an item manually into a Combo Box MS Access Help shows how to add it to the 'Value' list. I need the code to add it as a record to the underlying table.
Note: The table has only one column.
Thanks
View 2 Replies
View Related
Jun 5, 2005
Not sure what to search for so I thought Id write a new post:
I have a combo box which selects 3 items-
Primary key, Surname, Firstname
After an item is selected, the fields are populated according to the item.
Since there will be many records, it would be nice if the user can begin typing the surname and have predictive text, so the three items should then be-
Surname, Firstname, Primary key
So my question is, how do I get at the primary key if it is not selected?
myText = dlookup("myValue", "myTable", "primarykey = '" & ???? & "'")
If this does not make sense, what I am trying to say is:
The surname is selected, but I want to do a calculation based on the primary key so I get all the data associated with that user. I cant use the surname because there are duplicates.
Thank you
View 2 Replies
View Related
Feb 23, 2006
hi ,
i have a fro example menu and price database
that i entered Menu items and price of each other in it
and i linked this database to a order form that when i select for example capuchino it will give me 1 $ on price field
but the problem is here that when i whant to change the prices all of the past entered orders with last price will change to new one
how can i fix it ?
thanks
View 5 Replies
View Related
