none
MSCAL.OCX RRS feed

  • Question

  • I use MSComCtl.DTPicker for my MS Access application and I beleive that I need MSCAL.OCX on my Office folder, recently, we migrate from MS Access 2013 to MS Access 2016 64 bits, it seems that it does not recognize this Active X cntrol any more even I copy the MSCAL.OCX to the folder,

    Are there any work around for this for MS Access 2016 64 bits>

    Your help and information is great appreciated,

    Regards,

    Sourises,

    Thursday, October 12, 2017 1:09 PM

All replies

  • The MSCAL.OCX component has been deprecated and should not be used. There are options:

    https://sites.google.com/site/e90e50/calendar-control-class

    https://www.devhut.net/2010/06/10/ms-access-calendar-date-picker-control/


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, October 12, 2017 1:31 PM
  • I'd urge you to do away with ActiveX components, and avoid this whole issue of bitness, deprecation and switch over to using a 100% form based calendar/date picker. 

    Paul has already provided you with some good resources on the matter.


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

    Thursday, October 12, 2017 2:30 PM
  • yes, understand, thanks a milion for the information and helping,

    The only thing is the app already uses this control I need find  the fastest solution for this issue.

    Thanks agin for helping,

    Regards,

    Sourises,

    Thursday, October 12, 2017 2:41 PM
  • yes, understand, thanks a milion for the information and helping,

    The only thing is the app already uses this control I need find  the fastest solution for this issue.

    Thanks agin for helping,

    Regards,

    Sourises,

    Hi,

    Pardon me for jumping in, and this is just one person's opinion. But if it was me, the fastest solution would be to remove all the ActiveX control and just use the built-in date picker.

    Then, if you have more time, you can troubleshoot how to add the ActiveX control back in, if you still want to.

    Just my 2 cents...

    Thursday, October 12, 2017 2:48 PM
  • yes, understand, thanks a milion for the information and helping,

    The only thing is the app already uses this control I need find  the fastest solution for this issue.

    Thanks agin for helping,

    Regards,

    Sourises,


    There was never a 64-bit version of MSCAL.OCX that I am aware of so you will probably need to use an alternative, preferably not ActiveX.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, October 12, 2017 9:30 PM
  • > we migrate from MS Access 2013 to MS Access 2016 64 bits

    That seems like a REALLY BAD IDEA (RBI) and contra to all the advice, from MSFT and many other sources. Why was this decision made?

    There is no mscal.ocx for 64-bit, probably never will be, so you have to use an alternative. This is one of the many aspects the decision makers behind this RBI should have taken into account if they knew what they were doing, so you will have time and resources to deal with this fall-out. I would vote for the built-in one, but some of the VBA-only ones are pretty good as well, and essential if you need more features than built-in.


    -Tom. Microsoft Access MVP

    Friday, October 13, 2017 2:17 AM
  • Thanks for the information and help,

    I tried above solution, but none of them can run under MS Access 2016 64 bits version.

    They were build on MS Access 32 bits version. I followed MS Access 2016 64 bits compile errors to modify code for 64 bits version, but I still get run time errors.

    Regards,

    Sourises,

    Tuesday, October 17, 2017 12:57 PM
  • Thanks for the information and helping,

    Does MS Access 2016 64 bits have any date time picker control to work with form base or ActiveX?

    If not, how MS Acess 2016 64 bits application to deal with date time picker user interface?

    It should have a way to let users to enter date using calendar using MS Access 2016 64 bits.

    Thanks again for helping,

    Regards,

    Sourises,

    Tuesday, October 17, 2017 1:05 PM
  • Did you check out

    https://www.devhut.net/2010/06/10/ms-access-calendar-date-picker-control/ ?  Use a form based Date/Time picker and it will work for any version/edition/bitness of Access.


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

    Tuesday, October 17, 2017 1:30 PM
  • Yes, I did and tried all calendar date picker, but no luck for my application.

    Regards,

    Sourises,

    Tuesday, October 17, 2017 3:25 PM
  • We are developers. Please use precise language. "no luck" does not give us any information. Luck has nothing to do with how your application performs or does not perform. Rather we want exact steps to reproduce, and any error messages quoted VERBATIM.

    -Tom. Microsoft Access MVP

    Wednesday, October 18, 2017 3:59 AM
  • Allen Browne’s Popup Calendar  download link broken,
    Stephen Lebans Calendarhas compile error and I tried to fix compile error and get run time error in the Calendar code.
    Arvin Meyer’s Calendar another  deos not have implement method, it looks doa350.dll when I open the aceess

    I think that all Calendar use 32 bits to develop that it still needs some mordification to meet 64 bits 2016 requirements.

    Thanks again for helping,

    Regards,

    Sourises,

    Wednesday, November 1, 2017 7:56 PM
  • Hello,

    You may mark helpful post as answer to close this thread and create different new threads to discuss the issue when you use the control the community members suggested.

    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.

    Thursday, November 2, 2017 7:57 AM
    Moderator