none
Need to transition Access add-on from using mscal.ocx to calendar function in Access 2016 RRS feed

  • Question

  • Need to use calendar object in my Access database. Currently cannot update to Office 2016 because unable to tweak my MSCAL.OCX in 2016. Understand there is a new calendar function available in Access 2016. Need to transfer to that format to continue to use custom add-on in my database, which is central to operating our business.
    Monday, September 25, 2017 8:45 PM

All replies

  • I'm not sure I'm following your exact question 100%, but I'd recommend you review: http://www.devhut.net/2017/06/17/great-access-tools-calendar-controls/ .  Migrating form the MSCAL.OCX ActiveX control to a proper form based calendar is very easy, I've done it numerous times and the payoff is you'll never need to revisit them, or worry about updates breaking them, worry about them being dropped by Microsoft (as was the case of Treeview controls for instance) ...

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Monday, September 25, 2017 8:53 PM
  • Hi Karen,

    Just curious, what version of Access are you using now, where your calendar add on still works? If you're using it with Access 2010 or 2013 right now, what is the problem using it in 2016?

    Monday, September 25, 2017 8:54 PM
  • MSCAL.OCX has been deprecated since MS Access 2010. 
    Tuesday, September 26, 2017 4:00 AM
  • Hello,

    You could use built-in date time picker which works for Office 2010-2016. Please create a textbox and set its format into date or bound to date field and make sure "Show Date Picker" property is set into "For Dates", then you could see a date picker beside when it is focused. You could also use third party controls like what Daniel suggested in his link.

    If your issue has been resolved, i suggest you mark helpful post as answer to close this thread. If you still has issue, please free feel to let us know.

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, September 27, 2017 8:10 AM
    Moderator