Results 1 to 3 of 3
  1. #1
    simba is offline Advanced Beginner
    Windows 7 Access 2003
    Join Date
    Mar 2010
    Posts
    34

    How to search the Database?

    I have a database for the resources available. It has 3 fields namely Resourcename, Type of service and county.



    How can I search the database choosing county and typing a keyword for Resourcename or Type of service.

    I do not want to go to the form and use ctrl+H, instead use a search button.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Note:
    ctril+H is for search and replace.
    ctrl+F is for find.

    Have you tried using the filter by form?

  3. #3
    simba is offline Advanced Beginner
    Windows 7 Access 2003
    Join Date
    Mar 2010
    Posts
    34

    searching the database

    Hi!

    Sorry, it was my mistake that instead of putting Ctrl+F, I had put it Ctrl+H.

    I haven't tried using the filter by form. I will give it a try.

    I have attached the database herewith.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-31-2010, 08:57 PM
  2. Database Search filter
    By dada in forum Programming
    Replies: 7
    Last Post: 08-19-2010, 12:42 AM
  3. Search a Number in Database Field
    By julia_877 in forum Programming
    Replies: 3
    Last Post: 08-06-2010, 01:24 PM
  4. Search 17,000 records
    By dibblejon in forum Forms
    Replies: 1
    Last Post: 02-25-2010, 08:01 AM
  5. Search
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-24-2009, 12:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums