Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 (Drop Down Date Box with just Saturday's Listed)

    Hi,

    Looking to create a combo box, but I only want Saturday lists starting with the next saturday. Don't need to go back on this combo box, but would be nice to be able to to in another combo box. The defult value would be the next Saturday.
    Best Regards,

    Luke

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: 2000 (Drop Down Date Box with just Saturday's

    I would add a new table with just the dates of Saturdays. Probably easiest to do this in Excel (where the fill handle will create a series of dates) then import it.

    Set the Row Source of the combo to a query that selects values from this table where the date is greater than or equal to Date().
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 (Drop Down Date Box with just Saturday's Listed)

    Please provide more information. It's not clear to me what you mean by "I only want Saturday lists starting with the next saturday" - what list? And what does "would be nice to be able to to in another combo box" mean?

  4. #4
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (Drop Down Date Box with just Saturday's Listed)

    I need to have a combo box which only lists Saturday, for example:

    Saturday 22nd September 2007
    Saturday 29th September 2007
    ...
    ...
    ...
    Best Regards,

    Luke

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 (Drop Down Date Box with just Saturday's Listed)

    I'd go with John Hutchison's suggestion.

Posting Permissions

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