NEED HELP UGRENTLY!!!! PLS HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chanl2001@hotmail.com - 27 Jul 2006 10:01 GMT

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!!!!!!!!!

Reply to this Message

John Vinson - 27 Jul 2006 18:49 GMT

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.

Ummm... Access *is* a search engine.

>I have created 3 different topics of database.
>e.g. database1 - Speakers

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
>
[quoted text clipped - 4 lines]
>
>ok, now 3 differnet products of data have done.

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.
>
[quoted text clipped - 4 lines]
>type in enquiry's word or some button to check? Do I need to link the
>relationship?

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!!!!!!!!!

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]

Reply to this Message