Solved

MS Access Search Function

Posted on 2006-04-27
5
976 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
5 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
>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
Comment Utility
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
Comment Utility
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
Comment Utility
Closed, 500 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now