calendar in Access

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • glamster7
    New Member
    • May 2007
    • 33

    #16
    If its possibly could I have a copy of this as well. email addy is Email address removed per site rules!

    Comment

    • eriktheviking
      New Member
      • Oct 2007
      • 13

      #17
      This is a great calendar, but something strange is happening with some of the dates. I've uploaded some screen-shots to http://s238.photobucket.com/albums/ff21/eriktheviking/ so you can see what I mean.

      For example, the Calendar is showing that October 1 2007 was on a Wednesday (Oct07a.jpg) when it was actually on a Monday. The Events form shows it correctly (Oct07b.jpg).

      November is correct on both the Calendar and the Events form (see Nov07a.jpg and Nov07b.jpg).

      December is similar to November, with the Calendar showing 1 Dec 2007 on a Friday when it will really be on a Saturday (see Dec07a.jpg and Dec07b.jpg).

      I have not modified the code at all and am completely stumped about what's going on. Any help much appreciated.

      ADezii: I have PM'd you, but realise you must be very busy so I decided to post here too.

      Comment

      • ADezii
        Recognized Expert Expert
        • Apr 2006
        • 8834

        #18
        Originally posted by eriktheviking
        This is a great calendar, but something strange is happening with some of the dates. I've uploaded some screen-shots to http://s238.photobucket.com/albums/ff21/eriktheviking/ so you can see what I mean.

        For example, the Calendar is showing that October 1 2007 was on a Wednesday (Oct07a.jpg) when it was actually on a Monday. The Events form shows it correctly (Oct07b.jpg).

        November is correct on both the Calendar and the Events form (see Nov07a.jpg and Nov07b.jpg).

        December is similar to November, with the Calendar showing 1 Dec 2007 on a Friday when it will really be on a Saturday (see Dec07a.jpg and Dec07b.jpg).

        I have not modified the code at all and am completely stumped about what's going on. Any help much appreciated.

        ADezii: I have PM'd you, but realise you must be very busy so I decided to post here too.
        eriktheviking, I am more stumped than you are, since I show none of these anomalies such as you describe. I have no reply right now, but I'll continue to look into it.

        Comment

        • eriktheviking
          New Member
          • Oct 2007
          • 13

          #19
          Originally posted by ADezii
          eriktheviking, I am more stumped than you are, since I show none of these anomalies such as you describe. I have no reply right now, but I'll continue to look into it.
          Ok, thanks ADezii. I look forward to hearing from you.

          Comment

          • martin DH
            New Member
            • Feb 2007
            • 114

            #20
            Originally posted by ADezii
            Give me your E-Maill address and I'll send it as a File Attachment.
            ADezii,
            I would also be interested in a copy of this calendar if still available!

            Email address removed per site rules!

            Thanks.

            Comment

            • missinglinq
              Recognized Expert Specialist
              • Nov 2006
              • 3533

              #21
              Come on, people! Site rules forbid the posting of email addresses and they will be removed by the moderators!

              If you need communication outside of the thread you need to use PMs. But remember, information shared via PMs is not available to other members/guests!

              Linq ;0)>

              Comment

              • eriktheviking
                New Member
                • Oct 2007
                • 13

                #22
                I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......an d so on. Grateful for any advice.

                Comment

                • ADezii
                  Recognized Expert Expert
                  • Apr 2006
                  • 8834

                  #23
                  Originally posted by eriktheviking
                  I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......an d so on. Grateful for any advice.
                  Sorry Erik, but I do not know what to tell you, it works perfectly on all my PCs. It must be something to do with your System (Date/Time setings). Have you checked your Date/Time settings in Control Panel?

                  Comment

                  • eriktheviking
                    New Member
                    • Oct 2007
                    • 13

                    #24
                    Yes, the date and time settings on both the pcs I tried it on are fine (GMT Standard Time). I even tried it on my work pc and got the very same error!

                    Comment

                    • BradHodge
                      Recognized Expert New Member
                      • Apr 2007
                      • 166

                      #25
                      Looks like a future Tip of the Week, huh ADezii? :)

                      Brad.

                      Comment

                      • ADezii
                        Recognized Expert Expert
                        • Apr 2006
                        • 8834

                        #26
                        Originally posted by BradHodge
                        Looks like a future Tip of the Week, huh ADezii? :)

                        Brad.
                        Sure, as soon as I find out what the problem is, and how I can relate a Topic to it (LOL).

                        Comment

                        • eriktheviking
                          New Member
                          • Oct 2007
                          • 13

                          #27
                          Hi, any progress with this?

                          I've found some other calendars here http://www.accessmvp.com/JConrad/acc...calendars.html, e.g http://www.access-programmers.co.uk/...9&d=1148031828. They all display the dates and days correctly, but are not as easy to use as yours.

                          Comment

                          • mshmyob
                            Recognized Expert Contributor
                            • Jan 2008
                            • 903

                            #28
                            Not that this helps but I have the same calendar aqnd it works just fine on two of my computers.


                            Originally posted by eriktheviking
                            I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......an d so on. Grateful for any advice.

                            Comment

                            • ADezii
                              Recognized Expert Expert
                              • Apr 2006
                              • 8834

                              #29
                              Originally posted by mshmyob
                              Not that this helps but I have the same calendar aqnd it works just fine on two of my computers.
                              Thanks mshmyob, this is really driving me out of my mind. I can come to no other soluyion but to state that the problem with the Calendar as far as eriktheviking goes, must be PC specific. Specific to what - I don't know! (LOL).

                              Comment

                              • eriktheviking
                                New Member
                                • Oct 2007
                                • 13

                                #30
                                Originally posted by ADezii
                                Thanks mshmyob, this is really driving me out of my mind. I can come to no other soluyion but to state that the problem with the Calendar as far as eriktheviking goes, must be PC specific. Specific to what - I don't know! (LOL).
                                If it's specific to my computers, then it's weird that I get the same result on my 4 home computers and 3 computers I've tried at my place of work!!! So it is specific and general then. LOL.

                                Comment

                                Working...