MS ACCESS :: Search Form With "or" Input Search Posibility?

Multi Input Form Search ?
How do I do a form that I can enter
up to five items and then it will go
get me the information on those five
and display it on one form or popup
or something...(newb)

I have looked in the forums but, I am
still having trouble make one...heck...
I am even having trouble just getting
one to work...

I was hoping there was a way to type one
three, five or so items into a box and then
click a button and it would go find the info.

View Replies ! View Related

Input Mask, Validation Rule, Search Form
I have a form that acts as a filter/search engine -- it inputs criteria into a query, then opens a report based on the criteria/query. One of the criteria options is "Supplier Number", which is to be entered into an unbound text box.

All of our suppliers have 10 digits, usually in this format: A123400000 (i.e. First character is either a Letter or digit, followed by four or five digits, then followed by four or five zeros)

Our system works with ten digit numbers, while the people in the dept are used to just typing in "A1234" assuming the zeros are irrelevant.

How do I create a validation rule or input mask where a user can simply type "A1234", then it will return zeros for the remaining of the ten required characters?

I realize the usual response to these type of simple question is "Search the Threads", but I have done so already and still don't have an answer!

View Replies ! View Related

Input Box And Search Button
I have a form within a form and am trying to create a txt box for me to input the information i want from a main form and the search button to display the data in the sub form. I have a combo box which work fine but i don't like it to me its not looking professional.

Any help will be greatly appreciated.

thanks Ed

View Replies ! View Related

Search For Barcode With Scanner As Input
I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this?
The form basically holds a subform of textboxes that have barcodes. I want the user to be able to scan a barcode which will then find that barcode in the subform and assign it with a DateOut = Date() ...

View Replies ! View Related

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 ! View Related

Text Search Box To Search Access Database For Results
I am a one man show running my small business. I would like to create a text search box for my website. I would like for it to search the access database that I have just learned to create. The database contains part numbers, descriptions of my products, and quantities that I have in stock. I have no ASP experience and have no idea where to start. Can someone help me to create this text search box and a results page so that my website viewer can see the results from my database? I truly appreciate any help!

View Replies ! View Related

Using One Search Button To Search 4 Tables In A Database?
I have a database that uses four forms and each form has it's own table and each form has it's own search button to find a specific record within that table. I would like to use one search button that will look at all four tables and bring up the correct record when the request number is entered. Can I link all the tables to perform this or is code required? Can someone send me in the right direction for how to do this? Give me an example of code if it's required?
Thanks for any help I can get.

Laura Edmark

View Replies ! View Related

How To Search For Words Out Of Order In An Access Search
So basically, what I have is a bunch of words in one memo field, for example:

dog cat cowboy tree flower

To search it, this is the code I have now.

' Check for LIKE Last Name
If Me.txtLastName > "" Then
varWhere = varWhere & "[LastName] LIKE """ & Me.txtLastName & "*" * " AND "
End If

The only problem is what I search for needs to be "in order", for example, if I search for dog, I'll get the table. But, if I seach for tree, I won't because tree was not place first. Can you please help me? Thanks a lot!

View Replies ! View Related

Is There A Way To Change This Search To A Like Search Instead Of An Exact One?
Ok, i have a search query as follows

SELECT Table1.*, Table1.[Winning Contractor]
FROM Table1
WHERE (((Table1.[Winning Contractor])=[Who was the winning bidder?]));

This works well except if the user doesn't captialize a letter or doesn't type in the full company name. Is there a way to change this search to a like search instead of an exact one?

View Replies ! View Related

Search Button To Search Subform
Hello

I have a main form with a search command button in the header. This search facility looks for information in a subform. At the moment I can't seem to get it to work.

Main form called Building
Subform called LineTypeSub
Field its trying to search is called Line

Here's the code I have at the moment.

Private Sub cmdSearchLine_Click()

DoCmd.ShowAllRecords
DoCmd.GoToControl ("Line")
DoCmd.FindRecord Me!SearchLine

Line.SetFocus
SearchLine = Line.Text
SearchLine.SetFocus
strSearch = SearchLine.Text
End Sub

If anyone could help that would be great, thanks.

View Replies ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

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 ! View Related

Search Form
hi guys. i need help on doing a search on a database. i am using ms access 2003 and the form looks like this:

when the user will type in for example "EOT Corp." in the "Search for" field and will choose "Company Name" in the "Search by" combo box, the database will look for all the "EOT Corp." entries under the field of "Company Name" in a table. does anyone have a sample VBA code for this function? thank you very much. all your replies would mean so much.

View Replies ! View Related

Search Form (Come ON)
Now I have did a search and pulled up many threads about making a search forms and most of them are saying to do a search (LOL). Is there anyone that can provide an example of a search form so that an individual doesn't have to look at each and every record in a table? Im just need a search form to display the results of a specific name/SSN Search.

And one more thing I think it may be hard but is it possible to display the results in a form view instead of a datasheet view?

View Replies ! View Related