Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: Week of drop down menu which automatically populates date values

    Hi all—
    I am very new to ACCESS so any help is greatly appreciated.
    I am trying to create a form which selects a “Week of Value” and then populates 7 boxes with the dates in that week.
    1. So I need a drop down menu for the “name”
    2. The one which selects the “week of”
    3. The “date” field then automatically populates with the “dates” in that week.
    4. I need to save records for all 7 days

    Name Week of Day Date Scheduled Kept
    Monday
    Tuesday
    Wednesday
    Thursday
    Friday
    Saturday
    Sunday

    Name Week of Day Date Scheduled Kept
    Joe Smith April 1, 2013 Monday April 1, 2013 7 8
    Tuesday April 2, 2013 9 7
    Wednesday April 3, 2013 6 5
    Thursday April 4, 2013 No Sessions No Sessions
    Friday April 5, 2013 8 3
    Saturday April 6, 2013 No Sessions No Sessions
    Sunday April 7, 2013 No Sessions No Sessions

    Any assistance is greatly appreciated.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by mgarret View Post
    I am trying to create a form which selects a “Week of Value” and then populates 7 boxes with the dates in that week.
    1. What's a Week of Value?
    2. In which week, for which month of which year?
    Have a nice day!

Posting Permissions

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