Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Evansville, Indiana, USA
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Calendar Control in SubForm

    I am trying to implement a calendar via a subform. I found this demo on the msdn. However I don't want the text box to be updated when the Month and Year increment and decrement buttons are pressed. I only want to update the text box when the date is actually clicked. I am not sure what I need to modify to fix this.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Trying to change the way that Calendar works is difficult.

    What version of Access are you using? 2007 and 2010 provide a built in Calendar that you can use with no code at all. A calendar icon appears beside any date feild.
    Calendar1.gif
    Click that calendar icon and a Calendar appears.
    Calendar2.gif

    For older versions you need something. I attach a demo that uses an alternative Calendar. In this case the Calendar becomes visible when you double click the date field.
    Attached Files Attached Files
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Evansville, Indiana, USA
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using Access 2010. This is why I can't just use the built in Calendar Control. The application is a timesheet card. The user picks the week they want from a calendar. The database has worked for 5 years with the Calendar Control. We are upgrading to 2010 and I can't utilize the date picker because the application has to look exactly the same as it did before. With the code I posted I can make it look the same. I just don't want the increment and decrement buttons to update the textbox.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by bzimmer View Post
    I am using Access 2010. This is why I can't just use the built in Calendar Control.
    I don't understand this? Why not? The built in Calendar Control looks very similar.

    So has the issue of the increment buttons been around for 5 years?
    Regards
    John



  5. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Evansville, Indiana, USA
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The ActiveX Calendar Control 12.0 is not supported in Access 2010. See the link to the msdn:

    http://msdn.microsoft.com/en-us/library/gg251104.aspx

Posting Permissions

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