Complex Dropdown Menu Filtering

Jul 19, 2006

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?

View Replies


ADVERTISEMENT

Form Dropdown Menu

Nov 4, 2005

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

View 1 Replies View Related

Link Checkbox To Dropdown Menu

Jun 17, 2005

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?

View 1 Replies View Related

Filtering Dropdown By Value In Another Cell

Oct 23, 2013

I have a few tables. One of it is a matching table between a table with people information and a table with event information. Now it want to do something like that:

The first column is filled with the event name (reference to the event table is done so i can choose from the drop down list) ...
The second column should contain the company name of the persons who visited that event. (also done)
The third column now should contain the visitor name. but the drop down should be filter so that only the people working for the company chosen in column two selected.

In my visitorstable the company of the peoples is referenced so i have to check, when the drop down opens, is the company written in column two also found in the column in my visitors table.

View 1 Replies View Related

ID In Table When Selecting Text From Dropdown-menu

May 9, 2005

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.

View 2 Replies View Related

Complex Combo Box Filtering

Oct 21, 2004

Ok, so I invoke your help once again.

Here's the situation: I have a list of Crew Leaders. Each crew leader has the option of being the leader of up to three different types of crews, which is determined by checkboxes. In a separate form, I would like to do the following:

The first combo box contains a list of the three types of crews. Once an option is selected, I would like only the Crew Leaders' names corresponding to that selection to show up in a second combo box. However, they are not ONLY part of this selection, necessarily. They may also be a part of a different selection, as they may be the leaders of one, two, or all three types of crews. The third combo box I think I can figure out (the first box filters different services that the crew can provide, but it is irrespective of the name of the Crew Leader, so the services are crew TYPE specific, not CREW specific).

I've done it where the first box filters the second box, but only when the selection in the first determines an exclusive set in the second. What I'm trying to do is have the first box create a non-exclusive set in the second box.

Ex: Crew Type: A
Crew Leader (Selection pool): Joe, Bob, Jim, Jerry, Phil, Mark

Crew Type: B
Crew Leader (Selection pool): John, Bob, Jim, Mike, Barry, Dan, Mark

Crew Type: C
Crew Leader (Selection pool): Rob, Jack, Jim, Joe, John, Mark

Anyone have any ideas? So far you guys have been amazing helps.

Thanks in advance!
-Jason

View 14 Replies View Related

Filtering A Dropdown Selection Data Field?

Mar 1, 2005

I'm trying to filter my table so that i can make it a query. The data in the Facility is linked to another table with FacName and FacID. When i try to filter the data to create the query from the table, it says type mismatch. It's really bothersome....btw is there another way to create a filtered query?

View 2 Replies View Related

Forms :: Click Button To Open Dropdown To Open Record The Filters By Dropdown

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

Forms :: Using One Dropdown List Box To Display A Selecting In Another Dropdown List Box?

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

Dropdown Box Depends On Another Dropdown Box Value

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

General :: Dropdown List Dependent On Another Dropdown List

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

How To Show A Full Menu On The Menu Bar

Feb 19, 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!

View 2 Replies View Related

Dropdown List

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

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 14 Replies View Related

.dropdown Question

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

Dropdown Box In Form

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

Validating A Dropdown

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

Help With Code In Dropdown Box

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

Dropdown Has No Resultset?

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

Dropdown List

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

CombBox Dropdown

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

Dropdown List

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

Dropdown Filter Forms

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

ComboBox Dropdown Method

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

Query Criteria Dropdown

Mar 25, 2007

Is there a way to make the selection of a query criteria a dropdown list?

View 1 Replies View Related

SUBFORM - Dropdown Issues

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







Copyrights 2005-15 www.BigResource.com, All rights reserved