NEED HELP UGRENTLY!!!! PLS HELP

  • Thread starter Thread starter chanl2001
  • Start date Start date
C

chanl2001

Hi everyone, I would like to use access to make a search engine.
I have created 3 different topics of database.
e.g. database1 - Speakers

All 3 database were contained product's information

e.g Factory Tel. no Fax no Contact person
e-mail Product Product No.
XXXXXX XXXXX XXXXX XXXXXXXXXXX
XXXXX XXXXXX XXXXXXXXX

ok, now 3 differnet products of data have done.
then I need help for the next part.

How can I make it like a search engine? For example if someone would
like to search which factory have XXXXproudct. Or which 2 factory both
have the same product to sell? How can I make it just show out the
information that I want but not all? How can I make something that can
type in enquiry's word or some button to check? Do I need to link the
relationship?

I know it is lots of problem here, but it is very ugrent. Pls if any
access experts help me.
Thanks for helping me!!!!!!!!!
 
On 27 Jul 2006 02:01:54 -0700, (e-mail address removed) wrote:

Most everyone who posts here needs help. SHOUTING with an
undescriptive subject line will *not* get you a faster or better
answer; it's more likely to just annoy the volunteers like me.
Hi everyone, I would like to use access to make a search engine.
Click to expand...

Ummm... Access *is* a search engine.
I have created 3 different topics of database.
e.g. database1 - Speakers
Click to expand...

I hope that you mean that you created three Tables in a database. In
Access jargon, a "database" is the .mdb (or .mde or other) file, a
container for multiple tables, forms, reports, and other objects.
All 3 database were contained product's information

e.g Factory Tel. no Fax no Contact person
e-mail Product Product No.
XXXXXX XXXXX XXXXX XXXXXXXXXXX
XXXXX XXXXXX XXXXXXXXX

ok, now 3 differnet products of data have done.
Click to expand...

If you have three identical tables differing only in the category of
the product, your design IS WRONG. You should instead have one big
table, with a Topic field to allow you to select that subset of the
records.
then I need help for the next part.

How can I make it like a search engine? For example if someone would
like to search which factory have XXXXproudct. Or which 2 factory both
have the same product to sell? How can I make it just show out the
information that I want but not all? How can I make something that can
type in enquiry's word or some button to check? Do I need to link the
relationship?
Click to expand...

Take a look at "Filter by Form". Create a Form based on your table (or
on one of your tables), and try using the Filter menu option.
I know it is lots of problem here, but it is very ugrent. Pls if any
access experts help me.
Thanks for helping me!!!!!!!!!
Click to expand...

You may want to go back to basics and learn a bit about how Access
works. Try using the Northwind sample database; or check the
references at

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

particularly the Database Design 101 links.

John W. Vinson[MVP]
 
Back
Top