DavidDrotts
IS-IT--Management
Hello!
I am trying to build an access database to accomplish the same thing that MS Project accomplishes. My table has the following fields: ID, Task (memo), Start (short-date), Finish (short-date), and Duration (number). Tasks will be inputted by the user; when they input the duration (number of days to complete) and then after they input the start date the finish date will be programmatically entered (which I have done…see below).
Private Sub Duration_AfterUpdate()
Dim Start As Date
Dim Finish As Date
Dim Today As Date
Dim Duration As Integer
Duration = Me!Duration
finsh = Me!Finish
Start = Me!Start
Me!Finish.value = DateAdd("d", Duration, Me!Start)
These tasks will rarely be independent of each other, which means task 2, most likely, cannot be started until task one is completed. If this is the case then I need to find a way to pull the finish date from ID 1 (task 1) and feed it to the start date of ID 2. Just like MS Project, if the finish time is pushed back in task 1, so will the start time in task 2.
Your help will be greatly appreciated, I think the answer has got to be simple but I am scratching myself bald trying to figure out how to pull the data!
Please Help!!!
Thank you in advance…
David Drotts
I am trying to build an access database to accomplish the same thing that MS Project accomplishes. My table has the following fields: ID, Task (memo), Start (short-date), Finish (short-date), and Duration (number). Tasks will be inputted by the user; when they input the duration (number of days to complete) and then after they input the start date the finish date will be programmatically entered (which I have done…see below).
Private Sub Duration_AfterUpdate()
Dim Start As Date
Dim Finish As Date
Dim Today As Date
Dim Duration As Integer
Duration = Me!Duration
finsh = Me!Finish
Start = Me!Start
Me!Finish.value = DateAdd("d", Duration, Me!Start)
These tasks will rarely be independent of each other, which means task 2, most likely, cannot be started until task one is completed. If this is the case then I need to find a way to pull the finish date from ID 1 (task 1) and feed it to the start date of ID 2. Just like MS Project, if the finish time is pushed back in task 1, so will the start time in task 2.
Your help will be greatly appreciated, I think the answer has got to be simple but I am scratching myself bald trying to figure out how to pull the data!
Please Help!!!
Thank you in advance…
David Drotts