Drop Down Query

Apr 3, 2007

Currently the database has a parameter query in which the query is entered via a pop up box, it would be preferred if the query could be selected from a list of criteria in a combo box and run via a command button.

Any ideas would be much appreciated.

Regards

View Replies


ADVERTISEMENT

General :: Any Way That Access Could Create A Drop Down Box Within A Drop Down Box?

Jul 24, 2012

Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?

View 1 Replies View Related

Drop Down's In Query

Feb 7, 2006

I have a Report in my database that pulls off a query. In the Form, you can select a value (say "TYPE") from a drop-down box. In the Query, I have to manually enter the "TYPE"...therefore in the Report, I also have to enter the "TYPE" before the Report pulls up. To avoid problems, I would rather run the Report and/or Query from a dropdown. Is that possible?

View 14 Replies View Related

General :: Drop Down Box Which Effects Another Drop Down Box?

Jun 18, 2013

I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc

View 2 Replies View Related

Drop Down List In A Query

May 25, 2006

Hello,

Ok, let me preface this with I'm a newbie at Access, and I'm currently using Access 2003. I'm just hoping someone can point me in the right direction. Right now I have multiple tables with set data in them that doesn't change linked to another table where I have a drop down menu (combo box I think it's called in Access) to easily select the given data from. I want to have a drop down box (combo box) to have a set of given variables I have in a table to put in the search criteria. That way a user doesn't have to type the exact criteria into a query. That way I can easily put in the variables I want to search from in the query with less chance of an error. I'm hoping this is possible.

Ideally if I could get help in how to make a form that would allow me to have the set of columns from the corresponding tables with combo boxes to select from and then be able to have a "subimt" button and have it organize the selected results into that form as well.

Thank you for taking time to read this.

View 2 Replies View Related

Drop-down Menu Query?

Sep 20, 2005

Hey guys,
Is it possible to create a drop-down menu Query, as opposed to the basic Parameter Query where the condition is typed in a dialog box? Just thinking it would be easier for the user in that it would eliminate mistakes due to spelling errors. Would it be possible?

View 4 Replies View Related

Drop Down Menu's In Query's

Oct 24, 2005

I'm a new access user and surrounded by 3 1000 page access books and I can't seem to find the answer to this seemingly simple question. I really have tried.

I have a query that prompts the user for specific criteria. How do I make this query prompt a drop down menu rather than just free text, where the user is forced to know and enter exactly what their options are for the criteria.

any help is much appreciated. Thanks in advance!

View 2 Replies View Related

Query With Drop Menu

Sep 6, 2006

Hello !

I am trying to build a query where you would select condition from drop menu. Is it possible at all ? Maybe in SQL ? :confused:
So far I have used this form [Choose proejct:] in condition. Can be this changed with above mentioned WISH ! :o

THNX !

Klopo

View 1 Replies View Related

How To Add A Drop Down List To A Query

Dec 7, 2006

Hi all,

I'd like to modify a query of mine a little ...

Currenlty, when I click on my query and have it begin ... I have it set up where I then enter three seperate pieces of distinct data so that the exact information I'm in need of, which is stored in 2 seperate tables, can then be pulled together and displayed into one final combined table ...

I'd like to modify this beginning point where ... once I click on the query to begin, I can then just choose from a Drop Down list which has all the various rows of information displayed via these 3 unique indentifiers ... I then just scroll through and pick what I need and it then populates the final combined table as before ...

How do I add the drop down effect at the start of the query?

thanks,
TIM

View 1 Replies View Related

Drop Down List In A Query Form...

May 31, 2006

I'll admit from the start that I'm a newbie at Access 2003 and I've tried looking in the help file and internet searches. But I've become stumped on how to create what I'm looking for.

I would like to create a form that performs a query that has drop down menus with info from each specific column in a table. That way I don't have to necessarily need to know off the top of my head what data is entered in that column, but can click the drop down menu and get all of the data listed in that particular column. Once have a particular set of info selected, then have a button like "submit" and then the query results appear in a form and click through each page or results.

Is this possible?

View 1 Replies View Related

Drop Down Menu Query Problem

Sep 5, 2005

Hi,
I have a drop down menu that is linked to a query

it goes

*table1* *Table 2(linked via area)*
Company no+Company name+Area+Zone+Roundtrip distance

Now the field that it stores is the company number (we deliver to the same company in differant area, so I cant use the company as the primary field sadly) and as such if you want to quickly enter the data to get the drop down menu to show the records to select, then you have to enter the company number.
I was wondering is there a way to start typing the company name, and have the drop down menu show all the entries of that company, but to have it still store the company number when I select a record from the menu?

View 2 Replies View Related

How Can I Link A Drop List To A Query?

Jul 27, 2005

I want to create a drop list, so I can do that:

I select an item from the drop list. I detect the ID of the item and, depending of this ID, I select some records from a table.

Can somebody help me?

View 4 Replies View Related

Add Drop Down List To Parameter Query

Dec 8, 2004

Is there a way to add a drop down list to the message box in a parameter query so that users can enter a value(s) from the list in prompt? Thanks.

View 2 Replies View Related

Forms :: Drop Down Box Show Query

Jan 15, 2014

I have a database with a drop down box that lists all of the contacts in the database. When I select someone in that drop down box it goes directly to their record.

What I want to do is be able to display different criteria in the drop down box based on some criteria. So one criterion might be everyone, another criterion might be only people with a certain product.

How would I do this?

I guess I would like something like, one drop down box selects the criteria (show all clients, or show all clients with a certain product), then another drop down box is based on that one which displays that which was select in the first drop down. Then the results in the form would display based on the second drop down.

View 5 Replies View Related

Queries :: Query Creation For Drop Down

Apr 17, 2013

I have an issue with designing a query.i have three tables (there is more but these should do for this)

Game Review
reviewer
Game

i need a query that will only select games that the reviewer has not reviewed.its to populate a box on a add review form so that when a reviewer has been selected, the next drop-down will only show games that have not been reviewed yet by that reviewer.

View 4 Replies View Related

Reports/query By User From Drop Down Menu

Mar 16, 2005

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for.

How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory!

Thanks in advance!

Regards

Peter

View 2 Replies View Related

Use Selection From Drop Down List As Parameter For Another Query.

Feb 4, 2005

I want to be able to choose an item from a drop down list (based on a query i.e. distinct products) and have the item chosen to be automatically used as a parameter in another query.

Thank you

View 7 Replies View Related

Forms :: Drop Down Box In A Form To Call A Query

Mar 14, 2013

I want to track which user has which phone and track issues with them.

I have all the relationships set up right.

I have tables:

DeviceStatus - for the drop down box, contains IT Stock, Faulty, With User and Retired
DeviceTypes - Contains model numbers for devices
Assets - Contains a link to DeviceTypes, a link to DeviceStatus and the serial number of a phone.

I have a query:

StockStatus - shows Assets.ID, DeviceStatus.Status, DeviceTypes.description and Assets.SerialNumber

What I want as an end result is a form with a drop down box that shows DeviceStatus.Status (which I have working at the moment) with a go button next to it which will call the query that only shows what was selected in that drop down box.

View 5 Replies View Related

Queries :: Possible To Sort A Table Drop Down Box By Date Within A Query?

Oct 3, 2013

Is it possible to sort a natural table drop down by date from within a query? What im doing:

1. making a query that has certain results displayed
2. within the query you can select one of the field boxes and it has a list of all the items in that table.
3. is it possible to sort this natural table listing from within the query. I have attached a screenshot. Same thing happens with the client ID listing from within the query. Want to know if it is possible or not to sort those. I cant see how.

View 1 Replies View Related

Reports :: Result Of Drop-down From Query Puts X In 1 Of 19 Boxes

Jul 15, 2014

I have a query which works perfectly fine, it's the report that I'm having issues with displaying correctly.

My report is a daily personnel accountability report that shows where everyone is for the day. Instead of having a cumbersome query like I did before, I have opted to just use the results of the selected drop-down option to move the X to the appropriate box of where so-and-so is for the day.

Using

Code:
If [marked_as] = 1 Then
Me.Morning.Value = "X"
ElseIf [marked_as] = 2 Then
Me.Afternoon.Value = "X"
ElseIf [marked_as] = 3 Then
Me.Evenings.Value = "X"
End If

I was unable to get it to work accurately outside of showing the three dummy names under the same column, even though the three dummy names were each placed in one of the three test categories.

I have this set as a private function called when the report loads, which is based on a query that filters down to the exact department or office (depending on the user's selection). Like I said, that part works fine, it's getting the code to accurately display in the correct column.

View 14 Replies View Related

Queries :: Drop Down - Query Not Combining And Filtering Values Based On A Form

Jul 22, 2014

I have a form (DropDown form) that has 3 drop down fields, you select your values from the drop downs and you would push a command button that runs an event procedure which runs a query (DropDown qry test). The user should have the option of picking any combination of fields to filter by. Or no combination, which would return all values in all fields. So I am basically using the form as parameter's for the query.

The problem I'm having is that my query is returning values for one field AND values for another field. Even if the other values selected are not in the same record. It's not combining the fields together to filter. For example: you pick a Project name and Supplier name, the query will return records that have the project name you selected but it will also return records with the supplier name you selected that have a different project name.

I've attached screen shots of the form and the design view of the query (the screen shot cut off the last column name. It is meant to say "Expr3: [Forms]![DropDown form]![Combo7]").

Using Windows 7,
Access 2010

Is there a way to select multiple values from the drop downs?

View 14 Replies View Related

Queries :: Parameter Query Failed Based On Selection From Drop Down List

Feb 23, 2014

When creating a query I have set up a parameter query as instructed (in this case searching for a name) but when I run the query it returns the error 'this expression is typed incorrectly etc.'

I have worked out that this must be due to the fact that the names are not typed in by a front-end user but need to be chosen from a dropdown list (which i have stored in a separate table) - So, the query seems to fail based on that.

View 10 Replies View Related

Forms :: DLookup - Using Two Fields (number And Drop Down Text) To Query Table For Data

May 29, 2015

DLookup function. (this is for a stamp collection database).

On my form ("InventoryInput") I have a text box called "Catalog" for a numeric entry and a text combo box for selecting a "Country" in drop down list.

I want to query a table called "CatNameList" to get the "StampName" of the item (based on the entries of Catalog and Country) and populate that name in the text box. The fields in this table are called "StampName", "CatNumb" & "CName" respectively.

I have successfully placed the following expression in the control source of that textbox and able to populate the StampName I need based solely on the catalog number alone.

That express is :
=DLookUp("StampName", "CatNameList", "CatNumb = Form![Catalog]")

So it will populate the "StampName" data to match the "Catalog" number entry just fine.

However, I need to add a second layer to incorporate the Country.

Example : There is a catalog "1" for "USA", and a catalog "1" for "Canada" but both have different "StampName".

I have been attempting to get that second piece added with no success. Here is the expression I have been trying to get to work :

=DLookUp("StampName", "CatNameList", "[CatNumb] = " & [Catalog] & " And CName = '" & [Country] & "'")

Right now, the text box is just blank with the above expression. I thought it may be because there was no match found, but I have triple checked to ensure I have the spelling correct on the country name in both places.

Basically, I just need the dlookup to take the "catalog" and "country" off the form and match it to the "CatNameList" table fields of "CatNumb" and "CName" to give me "StampName" field back on the form.

View 4 Replies View Related

DLookup - Using Two Form Fields (Number And Drop Down Text) To Query Table For Data

May 29, 2015

Having problems getting dlookup to work in the control source field of a text box.

My form has fields : Catalog # (numeric value) and Country (drop down text selection).

I would like to query a table CatNameList for a name (text) if the catalog # and country find a match on the table.
My field names on the CatNameList table are : Name, Number (to validate against the Catalog # entered on the form) and CName (to validate against the Country drop down on the form).

I am successfully able to populate the name from the CatNameList table on my form using lookup of the catalog # using this :

=DLookUp("Name","CatNameList","Number = Form![Catalog #]")

However, I will eventually have several catalog numbers that will be identical in the table CatNameList, thus why the country is important as the second criteria to be added into the dlookup.

I have tried for a few hours unsuccessfully to add the second portion to my dlookup.

This is what I have currently (not working) that I have been playing with, I'm sure I'm missing a quote mark, & or something simple.

=DLookUp("Name", "CatNameList", "Number = Form![Catalog #] And CName = ‘”& Form![Country] & ”’”)

View 14 Replies View Related

Drop Down Menu Inside Drop Down Menu

May 15, 2006

Ok, This is something I have long wanted to do, but cannot figure out.

I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.

What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.

I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.

Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.

Thanks in Advance!

:)

View 2 Replies View Related

Drop-down Box

Nov 15, 2005

A group of us are working on this database for a girl scout troop and we were asked to create drop-down boxes for the parent information and doing one for the bus information. We are a bit clueless right now so I was wondering if anyone could help us out. I have added database Its called project.mdb

This is the link for the database

https://s51.yousendit.com/d.aspx?id=0D6D0LHFP3X551Y4BT5GC5DK3T

This is my e-mail

absolut_producer@hotmail.com

View 1 Replies View Related







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