Solved

MS Access Search Function

Posted on 2006-04-27
5
998 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

815 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

8 Experts available now in Live!

Get 1:1 Help Now