Results 1 to 4 of 4
  1. #1
    Douglasrac is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    92

    Question Universal Search


    Hi,

    How can I make a universal search in my data base? I want to type in one field, like the search field (Ctrl + F) and it will search in any table and any field. Right now I can only search in on field at a time.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you need code to do it, sir. If I'm thinking right...

    Access sports only very FEW of the qualities that web technology does. There's really no comparison.

  3. #3
    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
    Quote Originally Posted by Douglasrac View Post
    Hi,

    How can I make a universal search in my data base? I want to type in one field, like the search field (Ctrl + F) and it will search in any table and any field. Right now I can only search in on field at a time.

    Can you give an example of what you might hope to find? I'd like to see the thought process that makes this some sort of optimal approach.
    Is there a benefit to the searcher? How does one interpret/understand/put the result into context?

  4. #4
    Douglasrac is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    92
    I'm not so sure about what kind of information you want.

    I have a database with 4 or more tables. Would be nice to have a search system that would search in all tables at the same time.

    My database contains information about clients and their insurance. Which means that are data like license, register number, type of vehicle, phone numbers, payments, etc.

    Right now I can open a form, press Ctrl + F over Client field, and then search for name, any part of the name of the client.
    But if I need to search for anything else is a problem.

    First main problem: phone numbers. There are 3 fields for phone numbers (phone 1, phone 2, phone 3, meaning residential, comercial, mobile etc). If I need to search for a phone number I need to search that number 3 times. 1 for phone 1, if not found, change to phone 2, etc. That's not nice.

    Second main problem: a very useful thing to search is license number. But license is in another form. This "second" form I open from a button in form 1 (clients). When I do this, I only see in the second form, records that are related to the client in form 1. So I can't navigate in everything, like Form Clients (all clients) but only in the records related to that client, which means the Ctrl + F does not help.
    So the solution is to go to the table, select the License Number column, and search with Ctrl + F.

    But that is not what I think is a good searching system.

    Isn't that a way to search all records in all columns of the database? Even if it's a query? Because even if I create a query, I imagine I will need to search column by column, like I do with phone numbers.
    Of course something more user friendly, like a form, would be nice. But I prefer simplicity over fancy.
    I was expecting Access has something like this. Doesn't seem too hard. Search in all cells of every table.

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

Similar Threads

  1. Replies: 4
    Last Post: 03-17-2011, 06:17 AM
  2. Search Log!!!!!!!!!?!?!?!?!?
    By JG1992 in forum Queries
    Replies: 2
    Last Post: 03-13-2011, 03:09 PM
  3. help in search
    By Nokia N93 in forum Programming
    Replies: 5
    Last Post: 01-14-2011, 01:49 PM
  4. Replies: 2
    Last Post: 08-31-2010, 08:57 PM
  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