Results 1 to 3 of 3
  1. #1
    Pokrzi is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2022
    Posts
    1

    TO-DO Template data-base help

    Hello Together,

    this is my first post so I hope everything would be OK:

    I've downloaded free template from Access site.

    I would like to set "Task-list"Click image for larger version. 

Name:	Attachment.png 
Views:	31 
Size:	89.2 KB 
ID:	48523 with fixed tasks which are already pre-assigned to some people. So when someone is adding the new project - the task list is already there, some small adjustment will be done regarding resource assigning but there is no need to write new tasks all over again every time when someones wants to add new project.



    Right now I cannot add the tasks manually because I get the message "enter fix values with the field tasks.project". How can I get over it?

    Many thanks in advance for Your help!

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,402
    The error notification is because you're trying to assign tasks, but there is no project to assign the tasks to. Back on the Project List form, create the project, then assign tasks to it.
    As far as pre-fixed tasks, how would you know how to code in the tasks before the project is conceived? Do you have a set of projects that are done over and over, with a fixed set of tasks?

    I can see your thinking when you ran into the error. You want to create free standing tasks that can later be assigned to projects. That's a complete revision of the current parent/child design.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,402
    I looked at the existing template design and discovered that you can do exactly what (I think) you want with Common Tasks:

    Click image for larger version. 

Name:	common.png 
Views:	23 
Size:	137.3 KB 
ID:	48526

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

Similar Threads

  1. Replies: 4
    Last Post: 09-18-2014, 06:41 AM
  2. data base locking up
    By cwitt11 in forum Access
    Replies: 9
    Last Post: 07-21-2014, 01:28 PM
  3. Replies: 1
    Last Post: 07-08-2014, 06:22 AM
  4. Replies: 0
    Last Post: 09-26-2013, 08:31 AM
  5. Cannot add records to the data base
    By vagelism22678 in forum Access
    Replies: 1
    Last Post: 09-19-2011, 12:45 AM

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