Search the web
Sign In
New User? Sign Up
MS_Access_Professionals · MS Access Professionals
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Calendar
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
Keyword search in MS Access   Message List  
Reply | Forward Message #68928 of 76930 |
I've a database with 15 fields with about 5000 records; I want to add
a Keyword search button with a text box to my form which would search
all of 5000 records for the typed-in keyword in 2 of the fields. The
result should be displayed in a report.
Please give me the code to incorporate the keyword search button!

Thank you in advance!

Irving Guy
Mon Jan 12, 2009 10:01 pm

Show Message Option
irving_guy2000
Offline Offline
Send Email Send Email

Forward 		Message #68928 of 76930 |
Expand Messages Author Sort by Date

I've a database with 15 fields with about 5000 records; I want to add a Keyword search button with a text box to my form which would search all of 5000 records... 		irving_guy2000
Offline Send Email 		Jan 12, 2009
10:01 pm

Hi Irving, Please provide us with the following so we can help you. Your Version of Access. Your Table Name. The names of the two fields you want to search. ...
Patrick Wood
hunterpaw
Offline Send Email 		Jan 12, 2009
10:30 pm

Hi Pat, Thanks for your interest in solving this problem! 1) Ver: 2003 2) PRDChgMgmtTbl 3) Two field names: EquipTagNo & ChangeDescription 4) Command button:...
irving_guy2000
Offline Send Email 		Jan 14, 2009
7:53 pm

Irving- It would seem that you need a filter something like: Field1 LIKE "*" & Me.txtSearch & "*" OR Field2 LIKE "*" & Me.txtSearch & "*" John Viescas, author ...
John Viescas
jlviescas
Offline Send Email 		Jan 13, 2009
12:01 am

John, It works great! Thank you so much! Irving ... irving_guy2000...
irving_guy2000
Offline Send Email 		Jan 14, 2009
8:00 pm
< Prev Topic  |  Next Topic >
Message #
Search:
Advanced
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help