Results 1 to 2 of 2
  1. #1
    Clucky is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2011
    Location
    UK
    Posts
    1

    Project Milestone Planning

    Morning All!



    I was wondering if someone could help me. Having been quite adept at Access in college some years ago... a fair bit of knowledge has leaked out over the years since and have hit a roadblock now I have started using it again!

    I have created a Project Tracking Database in MS Access that is essentially a more tailored version of the Project template you can download from MS.

    What I am stuck with is I am trying to add a Project Milestone Planning table as an extra tab in the project details form. My project details form looks like the attached form. What I am trying to add is a number of editable cells by month (AP) going forward for the next say 10 years that the user can enter text into, like the attached.

    Please can someone tell me how I should go about doing this?

    Many thanks in advance for your help!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,818
    Having bound controls for data entry into each month across page like this would require a table with a field for each month times 10 years, one record for each project. Then the form would show all 120 fields or else have to modify the form for each year to bind controls to current year fields. Not efficient or normalized design.

    Otherwise, to have this form design, use unbound controls and then use VBA to add/modify records in a conventional table structure.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Planning/strategy?
    By Bryan021 in forum Access
    Replies: 4
    Last Post: 04-18-2011, 11:40 AM
  2. please can you help me with a project
    By Mark@starsupplies.co.uk in forum Database Design
    Replies: 1
    Last Post: 08-31-2010, 04:31 PM
  3. What's a milestone
    By nacho in forum Access
    Replies: 1
    Last Post: 04-18-2010, 10:24 AM
  4. Creating a calendar-like layout with a planning
    By ThermalSloth in forum Access
    Replies: 0
    Last Post: 11-24-2009, 06:22 AM
  5. advice on planning tables
    By justinm1015 in forum Access
    Replies: 1
    Last Post: 09-16-2009, 02:27 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