Query Criteria Dropdown
Mar 25, 2007Is there a way to make the selection of a query criteria a dropdown list?
View RepliesIs there a way to make the selection of a query criteria a dropdown list?
View RepliesI'm working with a form in Access 2013 that uses the navigation buttons. I'm trying to have my criteria for a query link to a dropdown box on the form. I had no problems doing this in Access 2010 with normal forms, but I can't link the criteria, in the query to the Navigation buttons form box. I'm tried using
[Forms]![TheNavigationTab]![NavigationSubform].[Form]![Field]
And various forms of the above... but i still can't see to tell the query to find the critiera at this location...
Good afternoon,
I need to use a selection from a drop down list to change the criteria in a query as opposed to typing text in a parameter box. This is to allow the user to choose from a list and then click on a command button to move to the next query. There are 20,000 records in the table. The series of queries will take the user to 1 or 2 records in 3 or 4 mouse clicks.
Thanks
I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.
View 1 Replies View RelatedI have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold
The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.
I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".
When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.
They other status the user will choose them self and do not need to be linked to each other.
In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.
If Me.Transaction_Type.Value = "Created" Then
Me.Product_Status.Value = "Unallocated"
End If
If Me.Transaction_Type.Value = "Allocated" Then
Me.Product_Status.Value = "Allocated"
End If
Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"
(in using access 2007)
I am currently developing an app with MS-access. I need two drop boxs on the same form. First is states and second is cities. When user selects one state from the first dropdown box, the second dropdown box will only display the cities that in the selected state. Is that possible by using ms-access??
Tanks
In my form I have a dropdown box. There are 7 values and based on the value it will run that query in sql server. I would like to have the query open in the form instead of opening up on a different tab. Currently on the command button click there are a bunch of if statements depending on what is selected on the combo box. Each value has a query associated with it because there are 7 different sql server DB's. The code is slightly different with each query.
View 2 Replies View RelatedI must create a database for the company that I work for that covers the maintenance history of our stone crusher plant. In this database I have two dropdown lists. The first one is for the equipment and the second one is for the different types of parts that has to be replaced or fixed.
Not all of the equipment uses all of the listed parts, but some parts are used on more than one type of equipment.
I have already created a database that lists all the equipment and another one that lists all the parts.
What I want to do now is create a Yes/No box for each type of equipment so I can mark which parts is used by which equipment.
Then you must be able to select the type of equipment from a dropdown list and then select from a dropdown list that only has the parts that is used by the piece of equipment.
I am using Access 2007
I have set up a database that stores actions (i.e jobs). In the table; two of the fields are...'required completion date' and 'actual completion date'. I wish to lookup, by using a query, all of the open actions (those which havent yet been complete (i.e the 'actual completion date' is null)) and then later on all those which are overdue (i.e the 'actual completion date' is null And the 'required completion date' <today....this being the criteria for an overdue action).
However, I have used a form which has a combo box which contains the values open and overdue. When a selection has been made I want a form to display with the results depending on the selection that has been made. I am capable of creating a form based on a query, but am unsure of how to construct the query with the correct criteria based on the option that is selected from the form.
Any help would gratefully be appreciated. Thanks
I have data for hundreds of stores. The data was pulled for the top 15 items by store, so I cannot obtain only the top 5 items that I need. How can I query this data to extract only the top (or bottom) 5 Subjects, by store, based on the percentage column?
StoreSubjectSalesSales %
1516Fiction56431.5-24.15%
1516Audio Unabridged1650.8-231.04%
1516History / Military History10081.1-29.99%
1516Role Playing / Graphic Novels14773.9-20.27%
1516Mystery13152.6-19.84%
1516Audio Abridged1785.9-141.84%
1516SciFi / Fantasy27535.3-7.93%
1516Juv Audio/Video1580.6-100.13%
1516Biography8103.6-15.89%
1516Sports7910.8-15.64%
1516Current Affairs / Law8141.9-14.34%
1516Reference7183-16.22%
1516Juv Non-Bk4585.9-25.02%
1516Science / Tech2961.4-33.98%
1516Movies / TV / Music / Dance3395.3-29.46%
1872Fiction307344.3-7.49%
1872Business134307.5-13.48%
1872Psych / Self Improvement100650.4-10.05%
1872Audio Unabridged29165.9-27.32%
1872Cookbooks57463.3-13.56%
1872Computers59235.7-12.37%
1872Regional59883.4-11.22%
1872Health & Fitness64713.8-10.29%
1872Maps19358.4-27.66%
1872Current Affairs / Law47927.1-11.08%
1872Travel Foreign42583.7-12.27%
1872Religion / Bibles80255.6-6.07%
1872SciFi / Fantasy67641.4-6.49%
1872Study Aids / Notes38299-11.24%
1872Games41745.1-9.79%
Hi all,
I am very new to Microsoft Access, and hope somebody can help me. Apologies for what I am sure is an easy subject - but I dont know what keywords to search on!
Basically, I need to have a drop list of say 5 different products. Now depending on the product will lead to different field boxes (say each product has 15 fields, 10 which are the same, but 5 which are unique to each product). I basically want the form to change dependent upon the product type. As I say I am very sketchy on this, so feel free to treat my like an idiot! If anyone could give me a hint as to what help topic this relates to, or give me a brief overview of what to do, that would be very much appreciated. The information will be downloaded from an ODBC if that makes any difference.
Many thanks in advance
Mike
I'm pulling my hair out. I'm making a seemingly simple tex book database.
I have 2 tables. AuctionItems and AuctionBidders. I have three forms. One to enter AuctionItems, one to enter AuctionBidders, and one to enter Transactions. The AuctionItem Table has a column for the winning bidders ID WinningBidderID.
On the Transaction form I list the acution item data and also want to put a listbox that allows the user to choosed the AuctionBidder that won this auction.
I cant figure out how to make this listbox. IIn the listbox dropdown, I want it to show the Bidders last name, first name, etc in the listbox, but then store only that persons BidderID in the AuctionItems table field WinningBidderID. I also want to display the bidders information on this form once selected. I cant figure this these things! Its driving me crazy.
Can someone give me some help or link me to an example database?
Thanks!:eek: :eek:
I am having a small issue with using the .dropdown command. I am using a combobox as a search tool with the code Me.combo107.dropdown in the On Change Event. I am using the Not In list property set to yes to trigger a custom message box stating that the number is not a valid project. If the project is on the list and you hit the enter key, code in the after update event sets the focus to another field on a seperate tabbed page.This works fine if you hit enter to select the project. The problem I am having is when a project that is on the list is selected using the mouse click instead of hitting enter, the focus is set properly to the next page, but I get the following error: Run time error '2185' . You can't reference a property or method for acontrol unless the control has the focus.
I was able to get it wo work better by putting the me.combo107.dropdown code on the Keypress event. The problem I have with this method is that if the code is not on the list, the dropdown box covers the custome error message that is triggered in the not in list event. I tired doing some setfocus code before the message box triggers, but it doesn't seem to want to move. Any help would be much appreciated.
Hey all,
Here is my contact Form and Table:
Form "contacts":
Contact Name ___________
Phone _______________
Address _______________
Town/City ______________
State _____________
Post Code ____________
From the form the data is entered into Table "contacts":
id contact phone address town state pcode
__________________________________________________ _____
| | | | | | | |
| | | | | | | |
| | | | | | | |
And here is the Invoice Form:
Okay this is the bit where i get lost:
Form "invoice data"
Contact Name ___________
Phone _______________
Address _______________
Town/City ______________
State _____________
Post Code ____________
Job Date _______________
Due Date ____________
Description ____________
Amount _______________
GST _______________
Total Inc GST ___________
Invoice Number ________________
Notice that the first 6 fields (contact name, phone, address, town, etc) are the same as the fields in the previous table.
What i want is to be able to make the field "contact name" a drop down box, which when a contact is selected it changes all the other fields (phone, address, town, etc) to correspond with that contact.
I know that all that may have sounded a bit comlicated, but that is the easiest way for me to put it. Im sure this is really easy for you pro's.
Thanks heaps :)
ps. if unsure of anything i wrote plzzz ask :)
Question I am looking at some annoying Access database for a charity and got stuck on trying to make something work that they believe used to
Two Tables
Venues
pK Venue ID
Venue Name
Venue Capacity
Booking
pK
Venue
Name
Addr1
Addr2
Addr3
Ect
They have a query call capacity check which does the following
Count Occurrences of Venues then takes this away from venue capacity
Essentially they have a standard access form of the Booking table with a drop down box and want it to only validate if seats are still free at a venue eg if the current count for venue is less than the venue capacity.
Any ideas ?
I have a dropdown box called Status on my form. I want to be able to limit what people can move an item to a specific status. In this case, I only want a PM or Developer to be able to move to the "Development" status. There are only 2 IDs to check for and if their ID comes up, it will let it move to that status, but if not, it will pop up with a message box. I have the code in the "On Change" event of the field. The code works great if I just have one ID, but if I try to do an "OR" and put the other ID, it won't work. Here is my code that works (user1 and user2 in the examples are the developers):
If Status = 7 And cu <> "user1" Then
MsgBox "Only PM or Developer can move to this status. This item will be moved to the status Out For Estimates. Please notify developer.", vbOKOnly
Status = 6
End If
However, if I change to this:
If Status = 7 And cu <> "user1" Or cu <> "user2" Then
MsgBox "Only PM or Developer can move to this status. This item will be moved to the status Out For Estimates. Please notify developer.", vbOKOnly
Status = 6
End If
Then even if your user ID is "user1" or "user2", it gives you the msgbox and it shouldn't. Any ideas? I even tried just using "Or" between the two userIDs and then got a datatype mismatch error.
Any help would be greatly appreciated!
We've created an Access 2000 form with dropdown boxes. The RowSource Tpe is Table/Query and Row Source is a SELECT query pulling results from a single table and the overall form is pulling from a complicated query.
When we display the form everything is as it should be. We click the Field 1 dropwdown box and it displays the correct resultset. We then scroll to the bottom of the displlay to add a new record -- clicking the Field 1 dropdown for the new record area reveals the same result sets. This is correct. Now closing the form and reopening, we skip clicking the first record's field 1 and go directly to the bottom of the form to add a new record -- the dropdown is empty. Scrolling back to the top of the form and clicking the first records field 1 also shows it empty. Odd.
Why does Access not reveal the dropdown result set if i access the "new record" area first?
Hi,
I create a dropdown list, which has 3 columns with column heads.
Can we set Bold format on the column heads?
Thanks.
Is there a way to have a combobox dropdown automatically so the user ddoes not need to hit the arrow to open it?
Thanks - John
Hi,
I want to create the dropdown list on the form, the dropdownlist will have 5 values, I want to give out description of each value when the user move the mouse on the value. Does the dropdownlist control have this option?
Dropdown Filter Forms
I’m working on building a form that has the ability to create and print a report based on the filter’s you pick.
Example:
Say you have a form with five dropdown boxes
Dropdown 1: VP’s Name
Dropdown 2: Manage <-at this drop down you will only see the Managers who report to the VP that was picked.
Dropdown 3: Supervisor at this drop down you will only see the Supervisors who report to the Manager that was picked.
If someone could direct me to the best place or help me understand how to do what I asked about that would be great.
Thanks
Corey
i have set the dropdown method of a combobox in the onfocus event
if then on the click event or exit event for the combobox i validate the entry and find error and move the focus back to the combobox the dropdown method does not appear to work.The focus has clearly been moved away from the combobox but when it returns the dropdown list does not appear
yet it always works the first time you enter the combobox within a form
has anybody else come across this problem!
any solutions
Little help please… I have done this before but must be missing something small… you will need to download the db attached…too much to describe.
Please open the db. There will be a start form. Click on the first button tittled:
‘Client Form’
This will launch a main form with two subforms. All coming from the same query. I want one main drop-down with the ‘client name’ and when that name is selected then the fields within the subform to be populated with the corresponding information.
Right now if you open the form there is already information & when you select a clie t name from the drop-down the subfield does not even change.
What am I missing all???
Thanks
hi everybody,
i am making an access database based on a mysql/web project. in the database, there are a lot of fields which answer yes/no questions and are stored as 0/1 in the database. i would like my dropdown to to have a yes/no option, and then insert 0 or 1 into the database accordingly. i would also like the existing value to be pre-selected in the dropdown. i am used to doing this in web forms, and not sure how to implement using access forms.
what is the best way to do this with access?
thanks,
harry
Quick question, (and hopefully a quick and easy answer).
I have a check box and a combo box. If the check box is not checked and a user clicks on the combo box, I have a message box that pop ups and informs the user that he/she must click the check box first. However, after they ok the message box, my combo box shows it's dropdown list.
Is there a way to stop the dropdown from occurring when they click on the combo box?
Thanks in advance.
Is there a way that I can get an "automatic dropdown" when I start to type in my selection?
I have a combo box that works fine but I don't want the user to have to click on the dropdown arrow to expand the list.
Thanks