Running A Query Based On Item In Combo Box
Nov 12, 2004
I am trying to select the records I want displayed by what category is chosen in the combo box.
Say there are two fields in the combo box: Red / Blue
I want the query to only display the records associated with the Red Category.
If I set the criteria in the query to [Show only Red] and type in Red when the query is run I get blank lines.
Is there an issue when choosing a category from a combo box for the query to be specific on?
My other issue is.... does the problem originate because I am trying to run a query from a table that is being filled in by typing the
information into a form? I wouldn't think so, but I am not sure.
Thanks,
ChrisB37
View Replies
ADVERTISEMENT
Apr 6, 2012
how I can have a combo box on a form, and once a value is picked, return a query that displays all the data based on that value. I have tried using sub forms and the after update but I cant seem to figure it out.
View 2 Replies
View Related
May 1, 2013
How do I get only one item in a combo box when using the Table/Query option (ie No Duplicates). I want only one of each field with no duplicates.
View 2 Replies
View Related
Jun 13, 2006
Hi,
I have a query that I would like to run from a form. I have created the button and the query, but want to add in a clause that will use the user selected record / field as the criteria for the query when its run.
Got any examples of code I could have a play with
I am struggling here so need any help I can get!!
Cheers
Paul
View 1 Replies
View Related
May 1, 2015
I have a list box that is correctly listing resources from a table (tblResource). I would like to select one of the list box entry and run a query against the tblResource to show the information for that resource in a form. I have tried to use the lstindex with the control (lstResource) in the where clause of a query to accomplish this with no success.
View 5 Replies
View Related
Dec 10, 2007
I have a query that runs info selected from safety visits. I have made a form with an unbound combobox that selects the supervisors name and after the name is selected, I have a button to run the query. When a name is selected, the query comes up blank. When I do not select the name, the query is populated.
My criteria on the query is [forms]![personnel]![combo9]
Combo9 is the unbound dropdown menu with the supervisors name that is taken from a table of names.
Any help?
Thanks in advance.:(
View 1 Replies
View Related
Mar 14, 2008
Hello I have Supply order Database
I want to display combo box
after selecting the month the query will run
plz tell me how to do it.......
kindly reply
if any 1
thanks
View 3 Replies
View Related
Mar 19, 2008
Hello All,
I do hope somebody can help this newbie :)
Please except apologies if I sound a bit ignorant with this but I'm complete novice with Access...
Basically I have a table with the fields Name - Date - Location I need to extract info from the table based on the location field.
i.e. return Name if a specified location exists and another specified location does not. This was real pain in itself and in the end I had to run two seperate queries which returned NAmes where each of the chosen locations exist. I've then created an additional query which compares the two sub-queries and iliminates Names that appear in sub query 2.
I do hope this make's sense I'm starting to confuse myself.....
Anyway, my problem is with the date field... I have to specify a date in order to get the correct info as the results may change on a daily basis... i.e. somebody may use both locations one day, but just the one location the next. However the eventual report which I need to generate is based on criteria over the previous 7 days, although if I use this criteria in my query in completely messes up the results.
So, what I was hoping that I could do is somehow automate my query to run 7 times (once for each of the previous 7 days) and then to combine the results of the 7 queries into a single query or report...
Failing that, could anybody think of any simple way of achieving this... or will be a case of having settle for a seperate report for each day?
Any help would be hugely appreciated... once again apologies for the explaination... It porobably makes no sense at all.
Regards,
Andrew
View 2 Replies
View Related
Jan 9, 2014
I have a form which lets the user enter a contract ID and then a combo box that has a list of reports which run against whichever ID is entered.
What I want to know if I put the ID's in a table if theres a way to allow the user to select multiple ID's in one go and run the report against them the range rather than 1 at time?
I'm thinking about utilising the check/tick boxes would this be possible? or another way?
I'm using 2003 and have some VBA ability.
View 5 Replies
View Related
Apr 14, 2014
I have DB in access 2007. I have a report that is uses a select query to generate the information for the report. It has been working great, But however lately like maybe with in the last month, it has been causeing Access 2007 to crash. I am having the same issue with another DB that uses the same information but that information is imported in. both Databases have worked great up until two months ago. Microsoft states that it is because of the program. I have tried to repair the DB by using the Repair option. I am confused as to why this would be happening. I can create a new report and it seems to work. but I do not want to change all the DB on everyone's computer just for this reason. I also have two buttons on my report that utilize macros to close or print the report.
View 6 Replies
View Related
Dec 18, 2013
I am trying to run a query and display the results in a report (the report side of it is childs play and not a problem). The problem I am having is that I have a search form which should allow the user to search any one of 6 fields (text boxes) or a combination of each.
If the user enters something into a field then that search criteria must match. I wanted to have it so if all fields are left blank then it will show all entries in the database (but it isn't, it shows a blank report). I also wanted it to allow partial completion of boxes.
So for instance if I have 5 customers (Jones, Jonson, Jonus, jimjonkins, Janis) and I type "Jon" into the name field then I would like it to show the first 4 records as they all contain "jon" somewhere in their name but its not, its only allowing exact matches.
I currently have '[forms]![Search_Customer]![Search_Name]'.
View 2 Replies
View Related
Mar 20, 2013
I have a report that gets its data from a query. I need the query to run before the report based on criteria based from two combo boxes on a form.
View 3 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 20, 2014
What i am try to do is have specific text boxes or items appear on the form depending on the combobox item you have chosen.
For Example
Combobox
CAR
CAKE RECEIPE
CLOTHING
if car is chosen 2 text boxes appear example car manufacturer, Car name. If Cake recipe is chosen a larger text box appears, if Clothing is chosen another combo box appears and gives you more options.
View 5 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
Jun 22, 2006
Hi everyone,
I have a form with a field named TREATMENT with the following options :-
1 Cryotherapy
2 Radiotherapy
3 Chemotherapy
4 None
5 Other (specify)
If the 5th option (Other) is selected, the user is required to specify what 'Other' represents.
I have created a combo box with the first 4 options and in instances of 'Other' the user can enter specific treatment that is not in the list (1 to 4).
What I would like to do is whenever the user enters a value that is not on the list (1 to 4), I would like to insert the word OTHER in front of the value entered. In other words all values not on the list will be prefixed by 'OTHER'.
E.G. if 'Surgery' is entered, I would like the value 'OTHER : Surgery' to be stored in the Treatment field of the table.
This will help in the generation of statistics from the table.
Any suggestions??
Many thanks in advance.
Will
View 3 Replies
View Related
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
Apr 1, 2012
I've created a simple form with a combo box, using wizard, and I create this code. for to add items when isnotinlist event. After requery, old data are changed to primary id numbers.
E.g.
Nametxt, id=1
Surnamext, id=2
Agetxt id =3
When i add a new item, the first item nametxt, converts to 1. This is the id. Here is the code
Dim cnn1 As ADODB.Connection
Set cnn1 = CurrentProject.Connection
Dim rs As New ADODB.Recordset
rs.ActiveConnection = cnn1
rs.Open " SELECT * from affectiontbl ", cnn1, adOpenDynamic, adLockPessimistic
[Code] ....
View 12 Replies
View Related
Jun 10, 2014
I need to run a condition that compares 2 field quantities together based on the same item. If they both equal the same then i want it to run a code and change a property for that record.
I will have a OrderQty and a Total receivedQty when these 2 equal each other then it updates the items Status to Received. What is the best way to accomplish this? in vba or queries/sql?
View 4 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
Aug 24, 2006
Hi,
I am using a combo box in my form. It is a growing combo box allowing new entries to be entered to create a growing list.
When new entries are made to the combo box list they are only displayed when I quit the form and then return to it. Is there any way I could allow the combo box list to grow dynamically rather than having to get the user to quit the form and then return to it?
Many Thanks
Turbojohn
View 6 Replies
View Related
Dec 12, 2006
Hello,
Didnt know where to start or what direction to head in. I have a combo box on one of my forms. It works fine, but would am looking for an added feature.
I am looking to get the following started:
There are 5 items in the list of my combo box. If the user selects the item called "Lost Opportunity", then how do I get an additional combo box to show up underneath it with reasons the sales opportunity was lost.
Then the reasons why would be in the additional box and they would have to select one...my work wants it so that if they lose the sale, they must provide a reason for that loss of business.
Any help in a direction would be appreciated.
Thanks.
View 4 Replies
View Related
Oct 20, 2004
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:
A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).
Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.
Any Ideas?
View 7 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
