Results 1 to 6 of 6
  1. #1
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57

    Auto create a column in a Table

    I have a form with a text field txtHOT and has a control source "Hand Over To" from the table Main. It's purpose is to assign pending work to the next staff on shift. Sometimes there is a pending work that may take several shifts to complete. Is there a way to create a new column on the Main Table every time a pending work is handed over to someone.



    Eg
    At the end of Sam's shift task 1 is pending so he enters Tom's name on the txtHOT field which save in the table Main in the column "Hand Over To" in row x. Currently when tom finishes the shift and task 1 is still pending so he hands it over to Mat. At the moment when tom enters in txtHOT and updates it replaces the existing value in column "Hand Over To" Row X. Instead i want it to create another column to enter the 2nd hand over to. Is this is possible and if so can someone guide me.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You do NOT need another Column. You need to add another record in a table to show that
    PersonX worked on TaskT on ShiftP, and at the end of the shift TaskT was still incomplete.

    Access deals with Tables and Records. Excel deals with Rows and Columns.

    It seems you have People/Worker; Shift; Task. And possibly a TaskPriority list.

    Can multiple Workers work on the same Task at the same time/Shift?
    Is there a sequence/priority assigned to a Task? eg Task9 must be completed by some Date.

    Good luck.

  3. #3
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57
    a task can not be created multiple times once it is created it can only be closed until it is closed all workers that work on it need to captured.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What makes you think that I suggested creating a Task multiple times?
    You want to know who worked on a Task, when and whether or not the Task was completed.

    Since all people work on a task until it is completed; and since people can be scheduled/assigned Tasks;
    you can know who is on what/next shift and what Task is currently active.

    You could have 3 tables as shown below:
    Code:
    Person---------->WorkedOnTask<-----------------Task
    
    John        Apr 2/17 shift 1 incomplete      TaskX
    Bill           Apr 2/17 shift 3 incomplete      TaskX
    Sam        Apr 2/17 shift 3 incomplete      TaskX
    sally         Apr 3/17 shift 2 incomplete     TaskX
    Ann         Apr 3/17 shift  3 *Complete      TaskX  <=====Completed

  5. #5
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57
    Quote Originally Posted by orange View Post
    What makes you think that I suggested creating a Task multiple times?
    You want to know who worked on a Task, when and whether or not the Task was completed.

    Since all people work on a task until it is completed; and since people can be scheduled/assigned Tasks;
    you can know who is on what/next shift and what Task is currently active.
    The table stores information based on the task and not the employee. The requirement is to have all that information in one table. Thus i was trying to figure how way to create a column everytime the task was handed over to.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    This is not a requirement
    The requirement is to have all that information in one table.
    Your requirement may be to have information readily available.
    If you are trying to do all of this with 1 table, then I think you have a design problem.
    But, you need to tell us more about your business and processes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 03-02-2015, 06:05 PM
  2. Replies: 2
    Last Post: 10-29-2013, 04:38 PM
  3. Replies: 1
    Last Post: 12-17-2011, 02:42 PM
  4. Replies: 1
    Last Post: 12-16-2011, 08:16 AM
  5. Auto-Create a Table
    By Mxcsquared in forum Forms
    Replies: 3
    Last Post: 01-28-2006, 11:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums