Listbox Dropdown
Apr 22, 2006
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:
View Replies
ADVERTISEMENT
Jul 28, 2014
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 Related
Aug 4, 2014
I 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)
View 14 Replies
View Related
Dec 8, 2004
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
View 7 Replies
View Related
Jun 11, 2012
I 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
View 4 Replies
View Related
Apr 21, 2006
Hi, I'm new here, so I hope I'm posting this in the correct place. I've searched the forum to see if there are any existing threads that might help me, but I've not found anything that does...
(I think this thread ( http://www.access-programmers.co.uk/forums/showthread.php?t=93444&highlight=Copying+data )may be trying to achieve something similar to me, but I'm a beginner and don't really understand it)
I shall stop waffling! I'm not entirely sure that what I'm trying to achieve is possible, I expect it probably is!
Right, I have a form (frmGroupRegister, which contains exactly the same fields as the table it comes from, tblGroupRegister), which consists of three things:
-GroupDate - The date a group took place on. It is my primary key, as no more than one group occurs on a specific date.
-ParentList (A listbox which contains a query showing the ID number, forename and surname of everyone in a table, tblParentDetails)
-ParentsAttending (A blank listbox)
I would like to place buttons in between the ParentList and ParentsAttending, which would allow users to conduct a 'register' of attendance by copying individual/multiple details from ParentList into ParentsAttending (much like you get when choosing which fields to include in a form when using a wizard for example). I would also like them to be able to remove people from ParentsAttending by using a button in case of accidentally adding the wrong person into the ParentsAttending box.
I'm aware that another, probably simpler way of achieving this would be to use a tick-box system, but I feel that visually, the first method would both look better and demonstrate who is present more clearly.
Any help would be much appreciated, but my Access skills are quite basic and things will probably need to be spelled out for me.
I'm using Access 2000 and Windows XP.
Thanks for your help,
Alice :)
View 1 Replies
View Related
Jun 10, 2015
I am using the selections made of the form to generate a query for the user.
I have a CITIES listbox that is populated with values from a stored query.
I would like to make it multi-select and populate a LOCATIONS list box and a NAMES list box based upon the CITIES that are selected.
I have the locations currently populated from a stored query that reads the City selection from the Form. It looks like this
Code:
SELECT DISTINCT (t_location.LOCATION) AS Expr1
FROM t_location INNER JOIN t_asset_master ON t_location.LOCATION_PHY_ID = t_asset_master.LOCATION
WHERE (((t_location.CITY)=[Forms]![MasterQueryGenerator]![CityList]));
I also want multi-select so that is you can un-select all and get the results for all cities.
Here is my half thought approach.
Code:
Private Sub CityList_AfterUpdate()
'Dim LocQryStr As String
'Dim r As Integer
'Dim ctl9 As Control
'LocQryStr = "SELECT DISTINCT (t_location.LOCATION) " & _
[Code] ...
I intended to have the variable LocQryStr as the row source but I abandoned the idea of having multi-select when I saw that .Selected(I) never returned true. Its like the values aren't read in this subroutine.
View 5 Replies
View Related
Sep 9, 2013
I have a list box called "product list box" based on a query called "searchqry", i also have another listbox called "type list box" , how do i get the type list box to only show "types" based on the section in products list box?
View 1 Replies
View Related
Dec 14, 2014
Using a popup form
1. On my main form, I have a listbox, I would like to edit the values of the listbox.
To do this, I have a popup form with 2 listboxes, one to have the values of the listbox on the main form, and the other listbox with option values for the 1st
1) how to i pass the rowsource sql of the listbox on the main form to the listbox on the popup form
2) how on closing the popup form, do i update the rowsource sql listbox on the main form from the changed value of the popup form listbox rowsource sql
View 3 Replies
View Related
Oct 23, 2013
Okay then, after much trouble and confusion, I finally realized I need to use an Extended listbox in order to allow for multiple items to be selected from a list on my form (rather than the evil multiple selection combobox!).
However, now I am trying to figure out how to make one listbox (IndustryClassification) only be visible if the item "Industry" is selected in another listbox (TypeOfBusiness). Coding I can use for this in the AfterUpdate event of the listbox?
View 7 Replies
View Related
Jan 23, 2006
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
View 2 Replies
View Related
Apr 18, 2007
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.
View 2 Replies
View Related
Feb 22, 2005
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 :)
View 1 Replies
View Related
Oct 25, 2005
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 ?
View 2 Replies
View Related
Dec 16, 2005
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!
View 3 Replies
View Related
Sep 5, 2006
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?
View 14 Replies
View Related
Dec 3, 2006
Hi,
I create a dropdown list, which has 3 columns with column heads.
Can we set Bold format on the column heads?
Thanks.
View 1 Replies
View Related
Sep 2, 2004
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
View 2 Replies
View Related
Jun 26, 2007
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?
View 1 Replies
View Related
Apr 14, 2006
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
View 1 Replies
View Related
Jun 30, 2006
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
View 1 Replies
View Related
Mar 25, 2007
Is there a way to make the selection of a query criteria a dropdown list?
View 1 Replies
View Related
Mar 8, 2005
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
View 2 Replies
View Related
Apr 5, 2006
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
View 2 Replies
View Related
Jan 4, 2005
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.
View 9 Replies
View Related
Mar 27, 2008
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
View 2 Replies
View Related
