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 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

General :: Organizing A Drop Down A To Z

May 11, 2015

I have a query that organizes a drop down A-Z. I am looking for a way to organize it A-Z AND Smallest to Largest.

Code:
SELECT tblPartNum.PartNumberID, PartNum & ' - ' & PartDesc AS Expr, tblPartNum.Deleted FROM tblPartNum WHERE (((tblPartNum.Deleted)=False)) ORDER BY PartNum & ' - ' & PartDesc;

I need it to sort it out like this

4 digit #'s Ascending
5 digit #'s Ascending
6 digit #'s Ascending
So the list would look like this
1111
1112
1113
11111
11112
11113
111112
111113
111114

View 6 Replies View Related

General :: Drag And Drop Between Databases

Sep 10, 2012

I've been developing several databases. Some elements that were experimental are now going "live". My development environment is Access 2010 on Windows 7 Pro. The "live" environment is also Access 2010 but running on Windows Vista SP2.

In development, I can drag tables, queries, etc. from one database to another by dropping them in the navigation column. When I try that on the "live" environment, it doesn't seem to work.

Is this a knownh difference between Windows 7 and Vista? Is this some sort of "trusted database" issue?

It is lots easier to drag and drop than using the Import External Data process so I'd like it to work.

View 2 Replies View Related

General :: Country Drop-down List?

Dec 13, 2012

I have a form (Create Guest). Employees can add guests and fill in the details. There is a label Country that Employees can fill in manually.

The problem now is that this is very fault sensitive (people type: "The Netherlands", "Holland" or "Netherlands" for example while this is one country).

How do I create a country drop-down list so that employees won't have to type the country in manually. I don't think adding all the countries in the world in my table is a good solution.

View 10 Replies View Related

General :: Drop Down Not Showing All Options

Jun 16, 2015

I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to edit the list. When I select edit the list, it shows all of them.

View 2 Replies View Related

General :: Drop Down List With New Entry Item

Aug 7, 2012

Drop down list equipped with new item input provided. My application now use a drop down list to access/display a form with certain item selected, but I want to entry new item using drop down list which equipped with "entry new item" then I hope the form can be accessed belongs to new item.

View 1 Replies View Related

General :: Drop Down Menus - Linked List

Jan 31, 2014

I have a number of drop down menus to select Building Name, Building Number and then Equipment Name and Equipment Number. I want the list to be linked so that when you select the building name the building number is picked up. Also I want the Equipment List's with to change so that once the building has been selected only the equipment available in that building is available to be selected. Is there a way I can do this?

View 3 Replies View Related

General :: Importing Data From Excel With Drop-down List

May 15, 2013

I have a Access DB created. I have a field, which is a dropdown list. The users can go in to a form and manually create a record into the table etc.

However, i've some data that I'd like to import into the DB.

This data is in Excel.

When i import the data, everything is fine but the column that has the information for the dropdown field does not import.

so to clarifiy, the field in the DB is a dropdown list.

the field in the Excel data is just a plain text entry.

is there somehow i can import this data?

View 4 Replies View Related

General :: Lookup Wizard - Two Fields In Drop Down List?

Oct 14, 2014

I've managed to use the lookup wizard to show me two fields in the drop down list, first name and last name, but when i select a record I can only see the first name in the cell, not both.

Is there a way to display them both together?

View 1 Replies View Related

General :: How To Filter Subform By Drop Down In Main Form

Mar 19, 2014

I am self thought and fairly new to access (quite fun )

It is a simple setup: I have a main form called "customer_information_display_form" within that form is a sub-form called "customer_information_form" in addition there is one combo box drop down menu

I would like to filter the information presented in the sub-form by company name located in the drop down menu.

View 3 Replies View Related

General :: Select Item Number From Drop Down Box To Create A Report

Jun 27, 2012

I'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.

At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.

I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails

the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.

What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.

View 7 Replies View Related

General :: Use Drop Down Control In Service Order To Select Customer

Mar 1, 2014

I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)

I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.

This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.

View 14 Replies View Related

General :: Drop Down Box - Field Is Too Small To Accept Amount Of Data

Sep 17, 2014

I currently have a drop down box with four options in there and the options are:

Low
Minimum
Medium
High

However when i change the options in the table to:

Low
Moderate
Significant
High

it comes up with the error message: the field is too small the accept the amount of data you attemtpted to add. Try inserting or pasting less data.

I do not understand what is wrong with the second option of words? The maximum for characters is set to 255 so i am not sure why it is coming up with that error message.

View 4 Replies View Related

General :: Display Selected Form Using Drop Down On Opening Database

Jun 23, 2015

I have created a Db in MS Access 2010 and under Options > Current Database I have done the following:

- Used drop down to select a form I want to display on opening
- Unchecked display navigation pane
- Unchecked allow full menus

This works how I want it to, perfectly. I then send it to a client who also has MS Access 2010 and when they open the file the form I have told it to open doesn't open, the navigation bar is displayed (with the form I want to open highlighted) and the full menus show but are locked.

What's going on? Is it some security setting the client has that isn't letting the opening procedure execute properly?

View 1 Replies View Related

General :: Control Source - Creating Image Based Off Drop Down Result

Feb 3, 2015

I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.

What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.

what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?

View 3 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

General :: Shape Effects And Conditional Formatting

Oct 25, 2013

Having recently upgraded to Access 2013 I've noticed when designing forms or reports the Shape Effect button is greyed out. Also, when I click Conditional Formatting no dialogue box pops up. This is happening on all old Databases and new ones created with 2013. (Windows 7 64 bit)...

View 6 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

Drop Down Box

Mar 1, 2005

I have a form with some drop down boxes
The form is based on a table
One field is lastname and one is firstname

The row source is based on table/query

The lastname field works fine but the firstname brings in the lastnames
What am I doing wrong

View 1 Replies View Related

Drop Down Box

May 30, 2005

Hi Guys,

I have a combo box on one of my forms that on clicking the arrow the user has the option to either input yes/no. However i have just noticed that the user doesn't have to input yes or no and can actually put whatever they want in it (which sort of defeats the object of the combo box!!)

Any ideas guys/gals??

regards,

Lee

View 2 Replies View Related

Drop Down Help

Dec 26, 2005

My database is set up with a sub form showing:

Mfg, Model, Serial#, and Type. When I drop down and choose the Mfg, I then go to the next drop down (Model)and the only choices I have are those associated with the Mfg I just selected from the previous drop down. On my Enter Repair Data form, I want to be able to drop down a box for Part Number and then have a drop down field for the Part Description to match the part number that i just selected. Then I would like to have the next drop down to show a unit price for the Part Number and Description fields that I just entered. Is it possible to accomplish this with an existing Data Base? My data base is 1.61M so it's too large to upload here, but if someone can help me my ICQ # is 65-489-369, e-mail is huntiir@bellsouth.net. I can upload a copy of my database if needed.

I also need to have a field added to another report in my data base sowing the total labor for units shipped on a particular date to a particular customer. The report already totals parts used in the repair of the units for that date. I just can't seem to get the total labor to show up.

I was also trying to set up an inventory Report on parts used for my repairs where it will calculate the number of parts in stock in the form of:
RR#, Part#, Description, Unit Cost, and Total Units in Stock. You can see that I am somewhat complicated and ignorant to the use of Access.
Can you help me out please?

View 3 Replies View Related

Drag Ans Drop ?

Nov 23, 2006

Hello,
How to do drag & drop in a form ?
I would like user click a field on a listbox and place it with the mouse in a field of the form as you can see in windows explorer to move a file from a place to an other.
I tried with mouse events but i don't obtain exactly what i want.
I this possible to do that ?
Thanks in advance.

View 4 Replies View Related

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

Drop Box Filtering

Jan 6, 2006

Hello Everyone. I'm not all that new to access however my problem does exceed my experience and I'm hopeing someone out there maybe able to help me.

A while back I began to build a database to keep track of post production activites such as what items were being produced on a perticular production line. Its my job to book all these items in according to date, line, item, order and qty.

This was all good and simple until it was decided that I had to assign a category to each item. Their are multiple models to one perticular category and to make things even more difficult the same item could be produced on more than one production line.

I work within a Pool company where their are 7 production lines, each with their own purpose and facilites of making certain products until you come to other products that could be produced on any of 3 or more lines.

So, I made a table 'Category' which lists the different types/acronyms for products and the lines in which it could be produced on.
I than created a new column within my Post Production table called 'category' and chose to use a drop box so I may select which category to assign the item. The drop box shows both columns 'Catefory','Line'.

The problem I have is that theres 40+ rows within the Category drop box and because the same name of the category may appear more than once simply beginning to type in the category name isn't good enough.

Is there a way to filter out which categories is listed within the drop box according to which line it maybe coming off once I've already selected which line within the same row?

I've tried selecting a relationship and createing a query both failed.

WarrenG.

View 5 Replies View Related

Drop Constraint Help

Sep 3, 2007

I have an Access 2002 database with a relationship between 2 tables I want to delete using VB code. I setup the relationship from within Access. Is there a way to find out the name of the relationship, if there is such a thing. The tables are: TableA.Id linking to TableB.BankAcctId with both cascade functions. What would the VB code look like? Something like ALTER TableB DROP CONSTRAINT ...
Thanks

View 4 Replies View Related







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