Modules & VBA :: Search Function With Drop Down Menu
Jan 5, 2015
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)...
View Replies
ADVERTISEMENT
May 6, 2014
I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...
I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.
View 2 Replies
View Related
Mar 17, 2005
Quick question.....I have a menu that links to 4 main forms displaying data from 4 different tables. I wanted to add the facility to quick search on the menu(i.e enter a record (the primary key) into a text box and click search. I would then want it to open the exising form at the relevant record or produce an error message stating no record present. I would have 4 quick searches on the main menu (one for each form)).
If anyone could help me on this i would greatly appreciate it, or if you could point me in the direction of an example it would also be great (although i have been looking and havent seen one i can get my head round)
Cheers,
Marky
View 2 Replies
View Related
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
Feb 22, 2005
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.
View 5 Replies
View Related
May 17, 2006
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 Related
May 30, 2006
i 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
View 1 Replies
View Related
Jun 16, 2006
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
View 5 Replies
View Related
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
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
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
Nov 8, 2004
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.
View 5 Replies
View Related
Dec 2, 2013
I have a form that I allow my users to view but not to change any of the records.
As the number of records has grown it's become necessary to add a search function.
My problem is that because the form is locked it cannot be searched.
View 7 Replies
View Related
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
Mar 13, 2006
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.
View 3 Replies
View Related
Mar 23, 2006
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
View 1 Replies
View Related
Nov 15, 2006
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 Related
Jan 26, 2005
Hi 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-.
View 10 Replies
View Related
May 15, 2013
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 Related
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
Jun 2, 2014
How I can create my own Ribbon which include drop down menus?
View 3 Replies
View Related
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
Aug 6, 2015
In 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.
View 4 Replies
View Related
Jul 18, 2013
Access 2007
I can't figure out how to replace a period that is in the middle of a string and end up with 10 digits. For example 55.5555 would be 5500005555. I can use replace() but the tricky part is I have to end up with 10 digits.
Ultimately what I'm trying to do is - when a user enters 55.5555, 555.5, 5.5 or any variation they will be able to find the corresponding record. So a wildcard for the search or the replacement of the "." with enough zeros for 10 digits.
Here is what I'm using now - i making them enter the full 10 digit number but would like to give them the ability to use the period in place of the zeros.
Function Search()
Dim lssql As String
Dim lsSn As Recordset
Dim db As Database
Dim lsMessage As String
Dim sMsg As String
Dim vRetVal As Variant
Set db = CurrentDb()
[Code] .....
View 2 Replies
View Related
Nov 3, 2014
I need a search function that will not just open files based on their names but also drill into the documents and search based on what's in it. The only way I can see now is to use the Window's search function (the one at the start button). Is it possible to call that function into access?how do I re-create the search style of the windows search bar for a specific folder? Something like streamreader
View 1 Replies
View Related
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
