MS ACCESS :: Help- Create Search Form

I Need To Create A Search Form But I'm Lost
Hi,

I am a total newbie to access.

We have a small business and i do all the admin. I've created a database of all our contacts (name, address, phone number, fax number, etc) and i've managed to create a form that allows me to enter the data into that instead of directly into the database window.

The last thing i want to do is create a search form or add a button to my existing data entry form that will allow me to type in a contacts name, address, or any other thing about them i remember at the time, and be taken straight to that entry. Once this is done that is all i need to know for the moment.

I've tried an example i found on microsoft's site but can't get it to work properly.

Can anybody help. I'd imagine this is very very simple but i can not get the answer myself.

Thanks.

View Replies !

How To Create A Search Form In MsAccess?
I am using msAccess to develop a small application.
I have 2 tables, student and course, and
I need to create a form with 3 fields -
by_id, by_date, by_course_id

This form can generate a view only table according to the field the user entered.

Can anyone help me on this?
What's the step to do so?

Thnx

View Replies !

Linking Form To Search Or Create New Record
I have uploaded an example of my database

As you can see there are two tables and two forms.
What i want is for a user to view or enter data for a record on the first form.
And then when they are done they click the button to open up form2.
What i want to happen is for the company name/id from the record in form1 to be searched for when form2 opens and to display only the data for that record when opened. If no data exists for that record in form2/table2 then for it too create a record for that company when form2 is opened from form1

hope this makes sense and you can help

Please note this is just an example so if there is wrong naming conventions and such please ignore if there is as i just wanted to display quickly what i want to acheive

View Replies !

Create Pop-Up Search Dialog
Hi,

I have one table with 3 rows (title, genre, year) and one form (Continuous Forms). Is it possible to create button, when I click, to show pop-up window with option to search any word which I type from row - title and set filter to show only records with this word?

pls show example if is possible

View Replies !

Create A Search Button
I am new to access but have managed to put togther a nice DB for logging services completed on equipment. I now need to search the infromation by user name, location, serial number and date.

I have tried to generate a query but get completly lost in the process. Is there a way to search and have the results appear in a box below the serach form??:D

View Replies !

How To Create A Pop-up Search Field
I have an extremely large database which is in a continuous form format, and what I would like to happen is, instead of using the find button that would just find a word, I would like to have a pop-up search box that would yield actual texts throughout the DB (something like the search feature in Adobe Acrobat). In addition, I would like to use the "and" or "plus" together to search for additional data if needed. Please, unless there is a sample I could download and use in my db, please be specific in your instructions since I am new to all this.

Thanks!!

View Replies !

How To Create Dynamic Search Forms?
Hiya guys, I need to create a form that works exactly in the same way as a query works, so there's a criteria text box on the top of the form and a list box displaying all results. I know a query does this but i need a user friendly way of displaying this information.

The search is for customer names and i need to display this information in a user friendly way because my users will need to search the database before deciding whether the customer has been inputted into it or not.

I tried to create this using a query having the criteria as the form's text box value (as an expression) but when I input values into the text box the query does not update unless i reopen the query in edit mode and perform a search manually.

My email is aabaaiaaa@gmail.com if any of you guys have any ideas! Thanks

Jay x

View Replies !

Create MsgBox For Failed Search
I'm using Open Form, and setting the Where condition to a Parameter called search, so that a pop up asked for search parameter from user. If there users search fails to get any matches, a blank form is returned.

Can anyone suggest a better way to achieve this, so I can include a message to say no data found??

This is all my click event reads thus far...

DoCmd.OpenForm "FindLesseeForm", acNormal, "", "[Lessee]![LesseeName] Like [Search]", acReadOnly, acNormal

Thanks

View Replies !

Create A Multi Word Search Query
You guys are awsome!

Is there anyway to use Like in queries where the user could type in more than one word?

I have a text box (search title), on a form (Search).

On after update the text box, opens a query.

The criteria in the query for the Title field is:

Like "*" & [Forms]![Search]![search title] & "*"

this works great for one word or phrase.

I would like the user to be able to type in 2 words, and have the query find all the records where the first word is in the Title, and where the second word is in the Title. And so on with 3 words or more.

View Replies !

Can ASP Or ACCESS Create A Database Search Report?
Hey there, can anyone advise if the following is possible and if so how it might be done?

I have created a site using DWMX04, ASP & ACCESS.

I would like to be able to have some sort of report on what is being searched on the database.

Can this be done in ACCESS or by using ASP?

Any ideas or suggestions would be great.

Mally.

View Replies !

User Input To Search Database And Create Report
I have a database that I created that uses a form to fill out information about server builds. I contains information about who built it, the IP address, server name, etc. I want to be able to create a dailog box that allows the user to input a server name to query the database and create a report based on that input. And if the user input isn't found in the database, a dialog box comes up with some sort of error message. I am still pretty new to Access, so the more detail you can give me the better. Thank a lot.

View Replies !

Search Form With "or" Input Search Posibility?
HI!

I'm trying to figure out, how to make seach form with one text field, that will accept OR statements. I have one table with fields name, category, and description.
Is there any chance to make search like this:
User will put "part of the string" OR "part of the string2".
Result will be the list of the records that include these parts of the strings in any of the given above fields (name,category,description)
I hope i'm clear enough

Thank You in Advance
for any Advice

View Replies !

I Don't Know How To Create Coding For "search"
i've try all the coding example from the internet source...but my "search" still didn't work....

i've used search to textbox (search) - search by name and ID - input from user
textbox(search2) - hidden
then using listbox to display the searched record! and in the list box will display like in a table (tbluserdata)....

i don't know how to use (Like "*"[forms]![userdata]![Search2]&"*"......
how about my SQL....

my form didn't work if i'm using DOA.database as in coding....but if i didn't write it in my coding for search, my form work! but no completely as i want!

my coding as below....could someone detect the error on it!:

search textbox :

Private Sub Search_Change()
Dim vSearchString As String
vSearchString = Search.Text
Search2.Value = vSearchString
Me.QuickSearch.Requery
End Sub

listbox display search:
Private Sub Quicksearch_AfterUpdate()
Dim db as DAO.database
Dim rs as DAO.database
Set rs = Me.Recordset.Clone
rs.FindFirst "[IDNo] = " & Str(Me![QuickSearch])
Me.Bookmark = rs.Bookmark
End Sub

View Replies !

How To Search Sub Form Records From Main Form?
The situation is like this:

I am designing a db for a dental clinic. I created 3 tables as follows:

1.T_Patients (P_Code(PK) and other fields)
2.T_Diagnosis (P_Code(Fk), ToothRecId (PK) and 32 text fields for 32 tooth named (UR1 to UR8, UL1- UL8 for Upper left / right Arch and LR1 to LR8, LL1 to LL8 for Lower left / right Arch)
3.T_Pmts (P_Code (FK), PmtRecId(PK) and other fields

I created one main form based on T_Patients tbl and similarly another 2 forms from other 2 tables. In the main form I placed 1 sub-form and 2nd sub-form. Bothe the sub-forms are Master / Child relationship on form over P_Code field in the main form.

Single character length has used for all the 32 text fields in table T_Diagnosis. So only one single B, C, D, F, M could be entered.

Normally we search patient’s profile by patient’s code or by name that displays in the main form. But the client needs to search patient’s record by tooth criteria.

There may many tooth fields in the first sub-form that are null and only some of them with any one of the B, C, D, F, M character. Bcz there is very rare chances of damaging all 32 tooth of the patient.

Now my clients want to search based on the data which are B, C, D, F, M characters. Means once he types C (stands for Cavity) in a search text box then it should bring all the sub-form records that hold value C in any of the 32 fields.

1.How can I do this when the search based on SUB-FORM and not over the main form?
2.The entered criteria value might by in other field also. Like say if entered C then this value may be in any of the 32 fields. So how it would bring all records?

I am confused how to do it. I attached a pic of my form for your ready ref. :confused:

I would really appreciate if somebody could help me.

With kind regards,
Ashfaque

View Replies !

Search Form; Not One That Pops Up Another Form.
I want to put a search form (text box and listbox) on a form that has the records displayed.Can i please get some help with codes. Ive been searching your forums but the problem is that most of the search forms are linked to pop-ups.

Can someone PLEASE help me.

View Replies !

Form Search!
Hi,
I have 2 forms: the first form is the search form (frmSearch) and the second form for search results (frmResult). In the search form i have 2 textboxes and 3 comboboxes. In a combobox if the user is chosing a value another subform appears on the form containig another search criteria (some textboxes).
If anyone can help me i need a search algorithm: a search algorithm depending on those form controls e.g. the user is chosing the search criteria (enters a value in some textbox and the combobox has no value or the user chose a value from a combobox and the subform appears and is entering a value in the text box from the subform). The search result is displayed in the frmResult which contains a list with 6 rows (Files: Name, Date, Number,etc) and another list with Files details (4 rows with details e.g. file x has: Documents, Nr doc, Page nr, Total pages).

If anyone can help me with an algorithm i will appeciate it.
Thanks!

View Replies !

Form Search!
Hi
Can anyone can help me with a search algorithm?....
I have a form with multiple controls (textboxes and comboboxes). In one combobox i have 3 values: legal entity, employee and and individual. Basing this values another subform appear for the search: for the person a search can be by its name or ss#; for the employee the search can be for by its contract number and name, etc.
I have a button "search". I need a search algorithm based on the values entered in text or comboboxes. The result of the searc will be displayed in another form containing as list with 6 columns containing data about files e.g a file for a employee can have: name,number,data,status,etc and this values are displayed basing on the values entered in those controls.

View Replies !

Search In The Form
hey

i have a main form ( there is link to my forms and my reports).

in one of my forms , i have a id field.

i want to do a macro or something like these that will do this things :

1-go to the form

2-go to the id field

3-push ctrl+f (search in a specific field - the id field)

how can i do this ?

View Replies !

QBF Form And Search
Hello all:

I have a form that is attached to a query.

In my query, I have the following criteria:

[Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null

But it only allows me to search that particular field either when I put in a blank or when I put in something like: cad*

I want to be able to also search like this:
*cad*
not cad*
cad* or pdf*
*cad* or *pdf*

Is this possible?

Thanks for your help!

View Replies !

Help With Search Form
I am working/rebuilding an application for my employer, this db tracks mail we get, and I am trying to update some things. I have attached the db I'm working on. I've stripped out any data and when I do go live with this db I will be splitting it for a multi user environment. I hope I posted this in the correct forum.
Here's my problem(s):

1) When opening the search form, data is already showing in the subform, how do I get it to open with a blank subform ?
2) On the search form the user can choose to search on dates, date picker works great, the problem I'm having is that I would like to be able to search in the following manner:
a. choose starting date and click search and have all records with a date => than that date show up
b. choose starting and ending dates and have records show up between those dates
c. don’t choose any dates but populate other search fields and search on them
3) I have the ondblclick event set to bring up the main data entry form, so that after finding a record they can go into it and edit that record, the open form part works great, but it doesn’t ‘bring’ with it the record info I would like the user to be able to ‘work’ on.
4) I would like to be able to shut off the mouse wheel scrolling, but haven’t been able to get that into this application, not a must have, just something nice to have

I’m sure I will have more ‘issues’ as I go along

Thanks for your help

View Replies !

Need Search Form Help?????
Hi All!!

I am very new to this access coding stuff, please bare with me. I am looking for someone to help me with a small project I am working on. I have the tables and forms already laid out. I need help with the coding part of it. Basically, the header part is where I would enter a search criteria to look up a street address. I have four text boxes and a search button to the right. and hit the search button and it would search and put the results in the "detail" text boxes.

In the Detail part of my form I have several more text boxes I am using for the search results. If anyone has the time to look at it and can give me some feedback on it I would appreciate it. I have attached the file, it is access 2002. Again anyone that can help with this, I would be deeply thankful.

View Replies !

Search Form
Hi Everyone!

My question is: how can I automatically switch to filter design mode on a form using vba? I'm designing a form which will be used initially for searching, and I don't want my users to have to click on the "filter by form" button. Is it possible to automate this? Can the apply filter be automated as well?

Thank you for your help

Simon

View Replies !

Search Form
OK so ive got my search form working. But I need to refine my querry, at present it reads

Like "*" & [Forms]![Search]![Box No] & "*"

So if I put in E1 it will return E1, E11, E12, E13 i.e anything with E and 1 in it.

Can it be refined to only give what I ask i.e if I ask for E1 then all I get is E1. I'm sure this is really simple, but!

View Replies !

Search Form
Could some kind sole please take a look at my DB and tell me why the search engine only searches by date. I'm at the end of my patiance with it and I know it's going to be something simple!

View Replies !

Search Form Help
I have a search form based on a query. the form works. i would like the form to be empty when i open it, how can this be done?

Thanks in advance!
Tim

View Replies !

Search Form Help
hi,

i need help with a search form i am trying to make.

i've looked at the sample search db on this site and i want to achieve something very similar to that..but i don't know how to do it :confused:

i have 2 tables:
employee
department

i want to be able to search a field(employeename) using a textbox - then when i click search button, the names that i have searched should appear in a listbox and all other info related to that name should appear in a query...

its very similar to the sample search db but i dont know how to relate the textfield to the list :p

any advice is appreciated, thanks.:)

View Replies !

Oh No...Form Search!
I looked at Gromit's example
http://www.access-programmers.co.uk/forums/showthread.php?t=99353&highlight=search
, on this forum, and I'm combining it with my own database. So, what I have no is a wierd hybrid between both databases. I'm sure it's a very easy problem, except I'm new to access.

So here's what I'm trying to do.

When you open up tblClients(this is gromit's), you'll see the first name, last name things. I'm trying to replace it with mine. So, instead of 1st name, it would be Title(of the book), Last name would be tags, and colors would be catagories. And I want to leave the colors things like that(clickable to search), so I can do that with my catagories.

All the things from my current database can be found in the records table.

I really appreciate you help!

View Replies !

Search Form
I'm making a form for searching which opened from a main form, displays results in a listbox and repositions the record of the main form accordingly.

I have the listbox displaying all the results and everything, but I've run into a problem repositioning the main forms record. The results consist of an ID which is the primary key of the main forms datasource.

Is there a way to return a value from a form?

I'm opening the form with the docmd.openform method.

View Replies !

Search Form
Hi I tried to adapt an example of a search form and Im getting a Syntax error. Ive attached the file so that hopefully someone can point me in the right direction. To get to the error open the file select 'SEARCH' write any letter in the 'EXERCISE NAME' field. then press search then it gives a Syntax error. All help gratfully received. I realise I need to set it up to search all the other criteria but I was trying to get one working first. Thanks!

View Replies !

Search Within A Form
Hello everyone,

I have this database with a huge ammount of specs (lots of tables). I had to build a form with two subforms, so I could display ALL the specs. Now I would like to add a command button, so that the user can search among the specs. For example, if he or she is looking for the resistance of the circuit and he or she cannot see it, she or he can click the command, type in "resistance" and find it, highlighted or something.

I really do not know what to do, I just started using Access with this one project.

THANKS:) eme126@psu.edu

View Replies !

Search Form
Iv'e been struggling with this for a while now, and this is the just about the final piece in the jigsaw so to speak. I have a search engine that works well after much help by the guys on the forum. I now need to be able to search between two dates as well, my problem is that I'm having trouble implementing that. I have attached the search engine part of my DB so people can have a look. Obviousley not all of the buttons are working at present, due to the fact that I have stripped lots out for posting. Any help gratfully received!

View Replies !

Need Help With Search Form
I am pretty sure there is a better way to accomplish my search than whar I am currently using. I have database with about 100,000 names soon to be 160,000 names. I had a form that had a simple search button that would search on the highlighted field that I defaulted to be the last name. The button popped up a search box that is the basic search box in Access. It would search to the first match of the last name and then you would just have to scroll through the individual records until you got to the exact person you where looking for (they are in Lastname, Firstname order). I wanted to get some sort of filter/search pop up that would be populated with a all matches to the last name or even something that would search by lastname and then firstname. I am just looking for a point to a tutorial because I just can't seem to figure out what to call it. Any other suggestion would be helpful as well.

View Replies !

Search By Form: Yes / No / Both
Hello,

Considering the search function will not allow searching for 'yes' 'no' '0' or '-1' because they are too short, I have to ask here:

1st Question:
If providing query criteria by form, how do I set a query to show all records if the search/criteria source is null? This relates directly to the Yes/No problem, if I provide a checkbox to search for items sold, for example, it will only show items sold when clicked, if it is not clicked, it returns zero results.

Is this better handle by an option group on the form? Say Yes (value is -1), No (value is 0), and Both (value Is Null?). If someone could give me direction in both this specific issue, as well as how to best handle Is Null in a search query by form I oul REALLY appreciate it!!!

2nd Question:
How do you set up queries / forms to handle this?

Thank you!!!!

View Replies !

Search Form
Can someone please look at my database and sort out my search form for me............

it might b sumat simple....................

the search textbox works (it succesfully searches for the provider or site) from the listbox....

BUT the subform underneath the listbox doesnt work.................

i click on the record in the listbox but it shows the wrong info in the subform...... y?

can someone sort it out? thanks

View Replies !

Search Or Look-up Form
I have a pretty large database (almost 11,000 records) and I am trying to devise a method to look up and display individual records. I want to be able to search the database by any one of four fields: our account number, the original account number, customer name and/or social security number. I would like to create a form that has four blank boxes, each related to one of the specified fields and be able to type in the criteria for the search, and have a "Search" button that I can click in order to display the record or records. Typically this will be used to display only one record. I don't care if it displays in another form or as a report, but I need to see all related data in the entire record. I have tried playing with queries and filters, but I'm bumping my head against the wall. Can anyone help me with the correct way to do this?

View Replies !

Search Form
I am trying to create a search form, with 5 different fields. I would like users to be able to input data into one or more of the five fields and have the search kick out another form displaying all results.

I have already setup a query that contains all the pertanant information that I would like returned, including the information the 5 fields contain.

My question is this:
What is the most effective way to go about setting this up? The query that I would be running this search against contains 80,000 records, so I am already prepared for this to be a slow search.

View Replies !

Search Form
Hi all, I want to set up a search form within my database that has a search box at the top and down below a table that displays the appropriate results. I want the search criteria to have the flexibility to be partially entered and return all dealer names starting with/containing the said phrase. I had one set-up for me but then it collapsed and i lost the file. Bummer . But anyways, thank you for any help on this problem.

Rob

View Replies !