Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Unanswered: Need to keep record on hold and work on it later

    Hello All,

    I am preparing a database to track the daily activities of my team. This is a real time database wherein the users will add their daily ongoing task and submit.

    The action for me is, I need to capture the time required for each task.

    Also, there is a possibility that the user will have to hold a task for a while/days due to some issue and will start another task. Once they have a feedback on the issue they will resume the pending/holded task.

    Here, I need to capture only the time they have invested in performing the task and ignore the time spent to receive feedback on the issue. Hence the time should start when they start the activity and pause when they hold the activity. Again, the time should continue where they had paused, when they re-start the holded activvity and finally ends when the submit.

    I have tried several ways, but unfortunately could not able to do it.

    Needed your help in this case and any suggestion from your side is welcome.

    I have attached my file so that you will get an idea of my database.

    Thank you very much.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    what about a cbobox have the current status and when that boxes changes it to update a hidden feild with the current date/Time
    you could take one step beater create a status table only having the activitiesID,statusID,datetimeitchange
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    what about a cbobox have the current status and when that boxes changes it to update a hidden feild with the current date/Time
    you could take one step beater create a status table only having the activitiesID,statusID,datetimeitchange
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •