In need of a Access 97 database to replace an excel spreadsheet procedure (need a upgrade)
Current Procedure: User group to complete a notification template (also attached) and then email it to SUPs and myself. We then update the Summary spreadsheets with the data. The USERs do not have edit capabilities, while the SUPs and I do.
For the new database, we would like the User group to be able to complete a form that would update the records with fields similar to those on the spreadsheets. Then the SUPs could pull a report (such as, show all records for a particular client) or could pull reports by client, or by dates across all clients. Certain SUPS and I would also have edit ability on the records while the Users would not. If an SCL needed to update a record, then they would need to submit another record or subform
**Need:**
User panel Sup Panel (Unless coder has better idea)
Report panel with additional email capablities
Prevent a record from being saved if the user has not filled in all the fields; we want to insure that the user has providedall the information we need in their submission.
Attached is a current sample of the spreadsheet and tables I started
I will need daily update of the database
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
pc
access 97