moving a schedule from Excel Problems

[samohtwerdna]

Hello all!

I usually post in the Excel portion of this forum as Excel is much more familiar to me than Access. I originally created a spreadsheet schedule for my companies short orders with built in calander reminders and email notifications. The sheet had formula's to figure out dates a job would go into production and estimated ship date (ESD) based on certain conditions. The problem I was having with Excel is the need to keep sorting my rows for proper calculation and that my end users where scared of the beast. I portected the formula cells - but had issues with unprotecting and reprotecting when I would run my VBA code.

So I decided to try the schedule out in Access. I have a semi normalized DB now with several tables and two forms. my main form is the entry point for the Job info, and on it I have several date fields that are calculated by the "Code" for the Job and the "dateSigned".

I have two major problems:

I can't manipulate the ESD (estimated ship date) with my Push and Pull buttons If I don't store this calculated date - can I?
I need to see the total money for the ESD - but don't know how to set up the query if my date is calculated
Can someone help??
http://vbaexpress.com/forum/images/smilies/banghead.gif

[matthewspatrick]

Andrew,

If it were me, I would want to do the following:


At the time a new order is created, calculate an estimated ship date based on the conditions at the time, store that value, and lock out changes to it. This initial estimate can then be used later on if you need to do variance analysis on how long you think it will take to do things and how long it actually takes
You will probably also need another form field that is calculated "estimated ship date right now" that is not stored

Patrick