I was wondering if you knew how to link a checkbox/radio button to a drop down menu? Or if it's even possible in Access.
For example, the form provides two checkboxes/radio button: student or faculty. If someone chooses either one, a drop down menu would appear with the names of the associated members. They can then select the corresponding name. Is this possible in Access? Do you have any other ideas on how I can implement this in Access?
In an Access Project I have a form with a drop down menu linked to a parameter query. How would I set the query parameter to Environ("userName")? Any help would be appreciated.
Thank you
Hello,
I have a form which gets it's records from qryCompleted.
The form shows all records with selected fields in a list.
Each title of the fields is a drop down box which need to update everytime any of the other drop down boxes are updated.
For example, if cmbCompanyName was updated, then all other drop down boxes need to have "select [field] From qry Where [company name] = cmbcompany name".
If cmbcompanyname and cmbregionname is updated, all other boxes need to have "select [field] From qry Where [company name] = cmbcompany name and [region name]=cmbregionname".
and so on and so on.
There's 6 fields that need to have filters on, which i quickly calculated at about "A shitload" of 'if-then-else' statements.
Is there an easier way?
Here's my problem:
I got a Table which contains software:
TblSoft:
ID |Software
-------------
1 |Office
2 |Winzip
3 |Etc.
I made a form with a dropdown-menu in which I can select the software and it stores it in another Table named TblPC.
It stores something allright. but not the text. It stores the ID Nr.
How do I get this to work that it puts the text inside the table instead off te ID nr?
I allready tried changing the properties off the listbox but it wouldn't help.
This form is bound to another table. Now i want to include a checkbox on this form that will be bound to an entirely different (small) table. How do i do this? :)
View 14 Replies View RelatedI 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
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
Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!
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
Is there a way to make the selection of a query criteria a dropdown list?
View 1 Replies View RelatedLittle 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.