data access pages: how to create search engine & guestbook ??? (access 2000)

I am creating a multi-function database containing the following
tables (key=agency):

1.AGENCY Headquarters Contact Info

2.with multiple SITES for each agency

3.CORRESPONDENCE LOG with each agency (no correspondence with sites)
dates & subject stored in database with link to external pdf file of each
letter.

4.current CONTRACT STATUS automatic-status by date range(contract between
my company & agency)(status= valid or will expire in 30-60-90)


I have created the tables & relationships. Now I am creating data access
pages so people can search & update info via our intranet.

I need help with the following questions:

1. How can I make a guestbook or journal? It does not need to be searchable
therefor it could be saved seperate from the database. Actually I would
prefer if it was seperate from access because of the feild length
restrictions.

2. I would like to create a search engine - boolean?. Preferably similar
format to:

search by {A.dropdown menu} containing {B.dropdown menu} or {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}

A.when they click on {A.dropdown menu} they will choose from list of feild
names

this action will automatically update choices in {B.dropdown menu} to
values already in the database

or they can type in the text box (find in any part of cell)

- I don't know if I am using the proper terms - but I would like to have a
progressive filter.

example:
search by {County} containing {Sacramento} or {}
{Company} {XYZ, Inc.} {}
{Correspondence} {"all"} {Jan 2005}
{A.dropdown menu} {B.dropdown menu} {C.text box}

the user may have 3 lines of criteria, only 1 line, or maybe 5 lines. So it
will need to ignore any "blank or empty" fields.

SEARCH RESULTS:
Information will all be returned in the following "outline" format:
grouping territory
then county
then companies (with links to each company)

the links to each company will thake you to the "read-only page" like a
report (data entry=false). you must click on edit button to take you to a
form if you want to edit. then submit info. then returns you to the updated
read-only page.


I really appreciate any advice, resources, or code you can offer me!

Thanks!!!

--
Message posted via http://www.accessmonster.com

call a consultant &| upgrade
-----Original Message-----
I am creating a multi-function database containing the
following
tables (key=agency):

1.AGENCY Headquarters Contact Info

2.with multiple SITES for each agency

3.CORRESPONDENCE LOG with each agency (no correspondence
with sites)
dates & subject stored in database with link to external
pdf file of each
letter.

4.current CONTRACT STATUS automatic-status by date range
(contract between
my company & agency)(status= valid or will expire in 30-
60-90)


I have created the tables & relationships. Now I am
creating data access
pages so people can search & update info via our intranet.

I need help with the following questions:

1. How can I make a guestbook or journal? It does not
need to be searchable
therefor it could be saved seperate from the database.
Actually I would
prefer if it was seperate from access because of the
feild length
restrictions.

2. I would like to create a search engine - boolean?.
Preferably similar
format to:

search by {A.dropdown menu} containing {B.dropdown menu}
or {C.text box}
{A.dropdown menu} {B.dropdown
menu} {C.text box}
{A.dropdown menu} {B.dropdown
menu} {C.text box}
{A.dropdown menu} {B.dropdown
menu} {C.text box}

A.when they click on {A.dropdown menu} they will choose
from list of feild
names

this action will automatically update choices in
{B.dropdown menu} to
values already in the database

or they can type in the text box (find in any part of
cell)

- I don't know if I am using the proper terms - but I
would like to have a
progressive filter.

example:
search by {County} containing {Sacramento}
or {}
{Company} {XYZ,
Inc.} {}
{Correspondence}
{"all"} {Jan 2005}
{A.dropdown menu} {B.dropdown
menu} {C.text box}

the user may have 3 lines of criteria, only 1 line, or
maybe 5 lines. So it
will need to ignore any "blank or empty" fields.

SEARCH RESULTS:
Information will all be returned in the
following "outline" format:
grouping territory
then county
then companies (with links to each company)

the links to each company will thake you to the "read-
only page" like a
report (data entry=false). you must click on edit button
to take you to a
form if you want to edit. then submit info. then returns
you to the updated
read-only page.


I really appreciate any advice, resources, or code you
can offer me!

Thanks!!!

--
Message posted via http://www.accessmonster.com
.