drewkeller
Technical User
I think this is possible but it would be nice to have an example to work from...
We are going to keep Engineering Change Orders (ECO) in a database on the server to track changes in how a product is manufactured. When an ECO is proposed, it has to be signed off by several people before the actual changes are going to be made. Once all of the action items are done, the ECO is closed.
What I envision is this
ECO creation: The user enters the data into a form in Access. Part of the data is who will need to sign off on it. Another part is who will need to perform action items (i.e. a task list). When the form is done being entered, pressing a button saves the information in the ECO log and sends an email to everyone who needs to sign off.
Signoff: Everyone who needs to sign off gets an email that contains the ECO. The email contains a form with two buttons: Accept and Reject. When either button is pressed, the action is logged in the ECO database and when all signoffs have been completed, the action items can be started.
Action items: An email is sent to each person who has a task in the action items (one at a time, serially). The email contains a button that can be clicked when the task is complete. Clicking the button updates the database and sends the email to the next person in the routing.
Once all action items are complete, the ECO is closed.
So is this possible and is there an example somewhere that i could start from? thanks.
We are going to keep Engineering Change Orders (ECO) in a database on the server to track changes in how a product is manufactured. When an ECO is proposed, it has to be signed off by several people before the actual changes are going to be made. Once all of the action items are done, the ECO is closed.
What I envision is this
ECO creation: The user enters the data into a form in Access. Part of the data is who will need to sign off on it. Another part is who will need to perform action items (i.e. a task list). When the form is done being entered, pressing a button saves the information in the ECO log and sends an email to everyone who needs to sign off.
Signoff: Everyone who needs to sign off gets an email that contains the ECO. The email contains a form with two buttons: Accept and Reject. When either button is pressed, the action is logged in the ECO database and when all signoffs have been completed, the action items can be started.
Action items: An email is sent to each person who has a task in the action items (one at a time, serially). The email contains a button that can be clicked when the task is complete. Clicking the button updates the database and sends the email to the next person in the routing.
Once all action items are complete, the ECO is closed.
So is this possible and is there an example somewhere that i could start from? thanks.