Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Holiday Table (Access 2000)

    Hello All: Just wondering if anyone has a table of US Holidays for the next 8 years that could be shared. TIA.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Holiday Table (Access 2000)

    While I was waiting for a response, I created one of my own thru 2020. If anyone needs one, I now have one.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Holiday Table (Access 2000)

    I was going to suggest you look at holidays in Outlook, as it will generate them for several years, but it appears you found another alternative. Besides, I was going to suggest that Outlook has been know to create some strange dates for certain holidays. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Wendell

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Holiday Table (Access 2000)

    Time & chaos have several lists for their software. You may be able to import it or change to a very nice programme!

    2002 Major League Baseball schedules are also available.

    Time & Chaos

  5. #5
    New Lounger
    Join Date
    Jul 2001
    Location
    Iowa, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Holiday Table (Access 2000)

    There was a lot of traffic on this topic in Woody's Access Watch a month or three ago, so check there, too.

    I was challenged a couple years ago to come up with a more permanent solution than a table of holidays, particularly because of Outlook date snafus, and came up with the attached code. A case statement out of the attached actually made it into a Readers Respond :-)
    Attached Files Attached Files

Posting Permissions

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