?
Solved

MS Access Search Function

Posted on 2006-04-27
5
Medium Priority
?
1,051 Views
Last Modified: 2011-10-03
Dear Experts:

I have a form name "customers", it have CusotmerID, CustomerName, BillingAddress ...
When I add a search function, it only search for CusotmerID, that's the primer key.
How can I change it to search other tables in the form? like search for CustomerName or Address?

Thank you.
0
Comment
Question by:kiirowei
  • 2
4 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 16558662
>When I add a search function...
Please describe how you set up your search function.

>like search for CustomerName or Address?
Give Access's built-in search feature a try ---
Right click on the field you want to search in and select "filter For"
Specify your criteria in the text box. You can type your criteria exactly, or use wild cards.
0
 

Author Comment

by:kiirowei
ID: 16565602
mbizup:
 
It works for other fields right now, all I have to do is select "csutomers search" from "Look In" drop down list.

Thank you for your help.

0
 
LVL 61

Expert Comment

by:mbizup
ID: 16573903
Hi  kiirowei,

If I'm reading your last comment correctly, you've found a working answer for your question.  If that is the case, you can post a note in Community Support asking them to close the question and refund the points.

0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16629038
Closed, 500 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

592 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question