btgtech
asked on
Access 2010: Use a field as a calculated field but allow users to write over the value
I have an access database which we are using for planning purposes. We are back dating the project from the delivery date using estimated hours for the work. This then calculates the complete dates for each of the tasks.
Once the planning dates are sent, we would like to allow the user to be able to go to the field and write over the date in the field and change it to a new planning date.
Is this possible?
Example:
1. Planned Delivery Date = Date entered by user
2. Inspection Comp Date = Planned Delivery date - Packaging Hours Est
3. Assembly Comp Date = Inspection Comp Date - Inspection Hours Est
etc.
What if I then want to allow the user to go into the app and change the inspection complete date without changing the other dates that come before the inspection date?
Once the planning dates are sent, we would like to allow the user to be able to go to the field and write over the date in the field and change it to a new planning date.
Is this possible?
Example:
1. Planned Delivery Date = Date entered by user
2. Inspection Comp Date = Planned Delivery date - Packaging Hours Est
3. Assembly Comp Date = Inspection Comp Date - Inspection Hours Est
etc.
What if I then want to allow the user to go into the app and change the inspection complete date without changing the other dates that come before the inspection date?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any reason for the B grade? You asked if you could update a field based on a calculation and my comment informed you that you could not do so, and gave you a workaround for it.
You then asked a question about using a staging table or form, and I provided you input on that.
So why the B?
You then asked a question about using a staging table or form, and I provided you input on that.
So why the B?
ASKER
Thoughts?