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

  • Thread starter Jamie Carpenter via AccessMonster.com
  • Start date
J

Jamie Carpenter via AccessMonster.com

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

Guest

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}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top