If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Data Access Page Problem | Doug Munich | General Discussion | 0 | June 5th, 2004 12:03 AM |