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
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?
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!
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
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?
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!
:)
Hi there.
I work for an Internet Marketing company and my boss wants me to design a huge huge form in Access - requiring alot of Drop Down Menus. Alot of them are simply Yes/No questions, some, however, are not.
This is what I have done so far:
I have a field called Sector which I have selected as a Yes/No Field.
In the Form Design View I have selected:
Row Source Type = Field List
Row Source = Sector (this is a separate table in which I have put all the options)
In Format, instead of Yes/No, I have changed it to "-" - this is simply because when I view it Normal View the first thing in the Drop Down Menu is a Yes or a No.
This all seems to work fine until I try to select one of the options and I get this error:
"The Value you entered isn't valid for this field - For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permit"
I have gone back and forth into the Design View on the Form and the Table trying different things, but nothing I do seems to work.
I don't even know if I have gone about doing this Drop Down menu in the correct way to begin with.
I'm not an Access Expert so please if anyone has any ideas please let me know. It'll be much appreciated :)
Thankyou.
I have a database designed on court bookings in a racquet centre. On the court booking form i have a drop down menu of the courts and i want it so that when you click the "book" button at the bottom it removes the selected court from the list so you cant book it twice, any ideas?
View 7 Replies View Relatedi really need help inputing values into my drop down menu. unfortunately i don't know how to do it. i have created the drop down menu, but with no values.
please help
chocho
Hi guys
I am new to access and am finding it difficult to do some simple things.
I need to know how I can set the properties of some of the fields in a datasheet so when clicked on a drop down menu appears.
I have an add record form where on one field the user can select a number of options from a drop down menu and this is then added to the table, however on one of the following forms I have a datasheet in a subform that is set to allow edits. I want a drop down menu to appear when the user selects the field that also had a drop down menu on the add record form.
any ideas on how this can be done would be greatly appreciated lads?
cheers
Please have a look at the screenshot file below before u start reading this.
what i want to do is limit the "Cost Type" drop down list.
The limit on drop down is initiated by Placement Type
So if you selected Placement Type = "Consultant", the "Cost Type" should be limited to the following
1) Consultant Wages X 14%
2) Consultant Wages X 4.5%
3) Consultant Wages
and therefore if you select "Other "on the Placement Type drop down, Cost Type dropdown should only show Sign on Bonus and other
i hope this makes sense.
thanks much in advance.
I have a field that is:
Current length of continuous allocation of Care Co-ordinator. ( years and months )
Ideally I would like to have two drop down menus - one with years and one with months.
Would I have to have two fields in my table - one for years and one for months or can I have one?
Whats the best way?
Thanks.
Hi
New to the boards.
The database i have created needs data removing from it when certain criteria arent met. Basically, when the form is filled in and the person is under 25 i need one range of data to be removed from another table leaving the ranges available to that person. how would i initiate this?
any pointers or links to where i can find this out (anything, i am desperate!!! :) ) would be appreciated
Thanks
I have an MS Access problem I need some help with. I am trying open a form for input from selection in a drop down menu in an access database. Any ideas on how I should do this??:confused:
View 3 Replies View RelatedHi all,
This is a simple question i think, but how do i enable my drop down menu to work for a combo box. I have a search query bound to a form and the combo box bound to a field of that query. At present my query just display the first record for any search result from my query on the combo box.
Thanks in advance,
M-.
Co-worker asked me if there was a way to add a drop down selection menu to a parameter box. Seems like ACCESS can do a lot of neat things.
View 14 Replies View Related1. 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
How I can create my own Ribbon which include drop down menus?
View 3 Replies View RelatedJust 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 RelatedIn the Lesson 22 tutorial presented here: [URL] .....
They create form where the called Countries toward the end where:
The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.
However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?
I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?
If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.
I have a form with First name, Last name, Employee number, Information. The information box is a drop down menu with four options (contact, emergency, company, personal) I would like to be able to enter in search criteria for an employee using one of last name first name or employee number then choose an option from drop down box click a button to search and have it pull up just the info I needed.
I think I have two options but i am not sure which would be more efficient.
1. creating a query and using the criteria from design mode to have it filter the information. The only problem with this one is I do not know how to set it up with the drop down box from the form. Or would I need multiple querys for each option or just one with all of it?
2. writing code for the search button on the form that will bring up the appropriate query (I think I would then have to create a query for each drop down option)...
There is a field already that has a dropdown menu that a user selects from and there is a PDF on a fileserver that is associated with every selection possible.What I want is the PDF file to open automatically (or maybe a button to appear) once the user makes a selection from that dropdown menu.
So far what I have is a hyperlink field and a couple test links and a created button on the form with a sketchy macro I came up with (an if statement saying if the selection made = the selection field, look at the hyperlink and open it).
I created a form that has a drop down menu to select a name. I attempted to set it up so that once a name is selected, another form is opened with that person's information. I was able to get it set up so that the first form closes and the second form comes up, but I can't get it to filter the name. I tried using SetTempVar and then SearchForRecord, but got nothing. I tried using OpenForm and Where Condition equals the search, but just got the automation error. It is currently set up using SetTempVer, OpenForm, SearchForRecord.
View 3 Replies View RelatedI have a table with questions and answers. I want the answers to be selected from a drop down menu. The problem is that for each question the answer options are different. That means I need to prepare different drop down menus for each question.
I've attached the table as well.
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.
Hi I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.
I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either. Any pointers or code would be gratefully received.
Thanx loads Lervy :d