Results 1 to 5 of 5
  1. #1
    kacocal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    26

    Search Engine

    Hi all,



    I am wondering whether someone can help me with this.

    I am designing a search form. When I enter the keyword (say: Peter), and click the "Search" button, This form will search through the whole database and find all the related Tables, Forms, Subforms, and all other objects which has this keyword "Peter" in these objects. It will also show the actual objects which contain this keyword "Peter".

    Any suggestions or feedback is really appreciated.

    Thank you.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I have a demo data base that will look for values across all tables, but Forms, Reports etc are not handled.
    Good luck

  3. #3
    kacocal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    26
    Quote Originally Posted by orange View Post
    I have a demo data base that will look for values across all tables, but Forms, Reports etc are not handled.
    Good luck

    Thank you Orange. I think I can do it for the values across all tables. Are there any ways for me to find the keyword in Forms, Reports etc... I really want to figure that out.

  4. #4
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    do you mean you want to find a word occurrence in any control (e.g. textbox) on any open form or report? Or do you mean contained in the control's properties, such as name? I think the former...
    If so, you may have to use a recordset clone that is related to the open form/report and loop through every field, record by record, using the InStr function.

  5. #5
    kacocal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2015
    Posts
    26
    Micron,

    Thank you. Yes it is the former.

    All the hints are already here and I am going to follow them and work on it over the weekend.

    Thank you all. Have a nice weekend.

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

Similar Threads

  1. access database engine does not recognize
    By slimjen in forum Forms
    Replies: 8
    Last Post: 05-30-2014, 11:53 AM
  2. Replies: 1
    Last Post: 09-28-2011, 01:24 PM
  3. Jet Engine
    By wharting in forum Access
    Replies: 10
    Last Post: 08-27-2011, 04:50 AM
  4. Search engine result database suggestions
    By PIHA520 in forum Access
    Replies: 0
    Last Post: 05-29-2011, 05:44 PM
  5. Replies: 1
    Last Post: 04-01-2011, 01:28 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