Board index Office Access

Seach multiple tables at once

Seach multiple tables at once

Post by HekaEnt vi » Sat, 27 Jan 2007 01:00:17


I have 3 different tables(each one for a different electonic document)
containing similar information reguarding part number, customer, creator and
dates etc. and what i would like to do is create a blank form called [search]!
and have [search]! contain a text box [txtBox] and make it possible so that
when i click on the one button on the form that it will search all 3 tables
with the infomartion entered in the text box and bring up the corresponding
information. i read something about a query that could do something similar
to this, but basically i want a search function that searches through all
columns of the enlisted 3 tables. if this is not possible then please tell me
as this is a "would like to have" by the owners of the company.

--
Message posted via http://www.yqcomputer.com/
 
 
 
Top

Seach multiple tables at once

Post by John Spenc » Sat, 27 Jan 2007 01:53:50

IF the three tables are parallel in structure you could use a union query to
combine them into one and search that for the results. The SQL of that
might look something like the following

SELECT Part, Customer, Creater
FROM TableOne
WHERE Part = [Forms]![Search]![txtBox]
UNION
SELECT PartNum, CustomerName, CreatedBy
FROM TableTwo
WHERE Part = [Forms]![Search]![txtBox]
UNION
SELECT Part, Customer, Manufacturer
FROM TableThree
WHERE Part = [Forms]![Search]![txtBox]

Read the help on UNION queries to understand the rules and limitations on
this type of query.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

 
 
 
Top

1. how to drag multiple items to pivot table report at once

2. Rename Multiple Tables at once

3. create multiple tables at once - HELP please

4. Need to create multiple Pivot tables at once

5. Changing Data Source on Multiple Pivot Tables at once

6. Export multiple tables at once to Excel. HELP!

7. Importing multiple .xls files to tables at once with code

8. Can Oracle use Multiple indexes at once on a single table?

9. How can permissions of multiple tables be changed at once?

10. how do i resize multiple tables at once

11. Refreshing Multiple Pivot Tables at once?

12. Default Print Style for IMAP messages changes to Tables when printing multiple items at once.

13. remove multiple hyperlinks in a table all at once

14. update multiple tables at once

15. Table of Contents- List of Tables Spacing Problem Once Table Number Exceeds 99

All times are UTC
Board index