Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Searching for a single word in all table

    Hi I'm extremely new to Access and I have created a fairly large database for inventory where I work. The thing that I would really like to do is to be able to search ALL of the tables I have created for a term. For example if I wanted to find out where a bottle of 70% alcohol is, is there a way I can search through all the table I created for "70% alcohol" and it will tell me where it is located in the database?!?!

  2. #2
    BCJourney is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Cincinnati, OH
    It sounds like you need to normalize your data first. You should have separate tables for related information. In this case if you have one table that simply has "Item" and "location" as in 70% alcohol and closet then you could simply open the table, highlight the field (column) you wish to search, "item" and type in "70% alcohol". This would take you to the record. You can also create a form based on the table and add a combo box to select item you are looking for. I'm not sure if you're referring to where it is located in a different context. If i misunderstood you purpose, please let me know.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-23-2011, 10:39 AM
  2. Table related to multiple tables by single ID
    By MrTumnus in forum Access
    Replies: 1
    Last Post: 11-17-2009, 02:05 PM
  3. Searching Dates
    By knightjp in forum Database Design
    Replies: 2
    Last Post: 08-16-2008, 11:39 PM
  4. How do I get info from Access table to Word doc.
    By slim_jim_56 in forum Import/Export Data
    Replies: 0
    Last Post: 10-04-2007, 09:56 PM
  5. Importing a table created in word to Access
    By anthony_f_justin in forum Access
    Replies: 4
    Last Post: 01-04-2006, 09:06 AM

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