searching database-novice

  • Thread starter Thread starter terry
  • Start date Start date
T

terry

I have a number of data bases which I have to search individually when
looking up a name. . Is it possible to have one search 'box' which will
search all my databases and return all entries in the files?
Terry
 
I have a number of data bases which I have to search individually when
looking up a name. . Is it possible to have one search 'box' which will
search all my databases and return all entries in the files?
Terry
Click to expand...

Why do you have the same "kind" of data in multiple databases? Do you really
mean separate *databases* - different .mdb or .accdb containers, each for
multiple tables, forms, etc. - or separate tables?

Such a search box could be created using some VBA code but it would be
horribly inefficient.
 
THank you. Sorry for not being clear. I have separate tables all contain a
field for surnames but have different information pertaining to the entry.
terry
 
THank you. Sorry for not being clear. I have separate tables all contain a
field for surnames but have different information pertaining to the entry.
terry
Click to expand...

Then you have an incorrectly structured database, it would appear. If you have
a collection of people, they should all be in a "People" table, with a unique
PersonID as a primary key (surnames are NOT unique), related to one or more
tables with the other information. Perhaps I am off base here, since I know
nothing about your application, though! What ARE your tables, and how (if at
all) are they related?
 
Thanks John, I am not real experienced and have over time constructed a
number of tables . If you go to my web site home.pacific.net.au/~tandd it
may be clearer
 
Thanks John, I am not real experienced and have over time constructed a
number of tables . If you go to my web site home.pacific.net.au/~tandd it
may be clearer
Click to expand...

I'll try to look at it in the next day or two. In the meantime consider
looking at some of these tutorials and other resources:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
terry said:
I have a number of data bases which I have to search individually when
looking up a name. . Is it possible to have one search 'box' which will
search all my databases and return all entries in the files?
Terry
Click to expand...
 
Thanks John, I am not real experienced and have over time constructed a
number of tables . If you go to my web site home.pacific.net.au/~tandd it
may be clearer
Click to expand...

John's right that your database structure could probably be improved.

But to answer your original question - you can query multiple tables
at once using a Union query as long as they have common fields. Think
of Union as a way to join tables vertically instead of horizontally.

You'll need to learn how to piece it together using SQL View, because
you can't design it directly in the Query Design View.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Thanks John, I am not real experienced and have over time constructed a
number of tables . If you go to my web site home.pacific.net.au/~tandd it
may be clearer
Click to expand...

The webpage is interesting - best of luck in your endeavours! - but I don't
see anything obvious describing the table structure of your database, nor even
any evidence that you're using Access on the website. Perhaps I'm looking in
the wrong place!
 
Back
Top