Drop Down Box In Alphabetical Order

Oct 23, 2006

I have created a form with a drop down box so that I can click on a client in the drop down box and it will pull the information from that clients record.. my question is :
Is there a way of having the clients names in the drop down box listed in alphabetical order without it changing the order in my table? My table is listed in order of project numbers not client names.

View Replies


ADVERTISEMENT

Drop Down Menu In Alphabetical Order?

Mar 14, 2015

Just starting off with access. Is there anyway of getting fields in a drop down menu to be displayed in alphabetical order?

View 1 Replies View Related

Alphabetical Order Query

Jun 15, 2007

The main form of our contacts database has its source in a query which places all contacts in alphabetical order by surname. How do I get the query to sort by surname and then by first name? Also, how can I get the query to run each time a new contact is added so they are put into alphabetical order when they are saved, rather than appearing at the end of the list?

View 2 Replies View Related

List Box Alphabetical Order

Sep 26, 2005

Hi can anybody tell me how i can make a list box alphabetical and it updates as new records are added

Thanks

View 3 Replies View Related

Forms :: Non Alphabetical Order Of X-Axis Label On A Chart

Jan 4, 2015

I have inserted a bar chart onto a form using a totals query. The query is grouped by days on stock, eg. '0-30', '30-60', '60-90' etc. which is therefore the labels on the x-axis.

The chart displays the correct data, however, the chart automatically displays the categories on the x-axis in alphabetical order... '0-30', '120-180', '30-60' etc.. Is there anyway to adjust this order to be eg. '0-30', '30-60', '60-90' etc?

View 1 Replies View Related

Forms :: Bound Form - Items Not Appearing In Alphabetical Order

Aug 2, 2013

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

View 2 Replies View Related

Forms :: Possible To Have Combo Box On Form With Fields Joined With Alphabetical Order On Surname

Aug 1, 2015

I have a Table with 6 fields, 2 are named Initial and Surname. Is it at all possible to have a combo box on a form with these to fields "joined" with the alphabetical order on the Surname. I understand that using a query will not work as the result is based on an expression

View 11 Replies View Related

How To Display "row Source" In Combo Box In Alphabetical Order

Mar 29, 2006

Hi all,

I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order.

can pls help me by teaching me How to display "row source" in combo box in alphabetical order??

thks alot

FT:)

View 3 Replies View Related

Forms :: Drop Down Menu In Order

Aug 6, 2015

1. I have a drop down menu with numbers 1 thru 15

How do I have the drop down menu go 1,2,3,4, etc.

Right now it goes 1,10,11,12,13,14,15,2

Also I have two fields where the user enters money

2. How do I set up the form so when the user types in 430 it is 430,000.00 and not 430.00

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

Alphabetical Sort Orders.

Sep 20, 2005

Hello.

How can I preserve the user-defined sort order in a column in a table?

Every time I exit the table, and go back, my items have been alphabetically sorted. This results in my Combo Box displaying the list in alphabetical order, rather than my custom order.

Thanks ahead.

View 2 Replies View Related

General :: String Function To Detect First Alphabetical Character?

Jul 18, 2014

I have a string where alphabetical and numerical characters are mixed up. I need a string function where I can find the index of the first non-numerical character. I tried with the mid function but could not get it to work.

View 13 Replies View Related

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

Allow More Than Order In ORDER Form

Apr 4, 2013

I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.

I have no clue how to do it.

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

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

How Do I Add A Drop Down List?

Dec 18, 2007

I am creating a table in Access 2003, and I need to add a drop down list to one of my columns. See the attached picture - I need to add a drop down list to the "Division" column that will allow the user to select from one of 5 choices. How do I do this?

I'm an Access beginner, BTW. :)

View 14 Replies View Related

Drop Down Lists

Apr 20, 2006

I am building a query for a university and the table i am working from has a column with every course run by the department.

How do i create a query that allows me to add a drop-down menu to the course instead of having to write out the course name everytime i want to query the number of pupils on a particular course.

View 1 Replies View Related







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