Access 2013 datapicker

Question

We are working with a database that was generated using an older version of Access.  My boss originally had this version on her laptop and upgraded to 2013.  My laptop came with 2013 already installed.  In our database, there are a lot of forms that have drop-down boxes used for entering dates.  My boss has no problem using these forms, whereas I get error messages such as "No object in this control" and "Missing link to MSCAL, etc." 

I found a workaround (using ActiveX control), but was wondering if there is something that I can install or do that will make all of the date drop-down boxes work instead of changing each form with the workaround. 

Any help would be appreciated.

Answer 1

Thank you very much! 

I used Wayne's link to the fix, and it is working now. 

I really appreciate your help!

Answer 2

ActiveX controls are to be avoided at all cost.

You would be much better served replacing your use of the ActiveX control with one of many Form based calendar/date pickers:

http://allenbrowne.com/ser-51.html

http://www.lebans.com/monthcalendar.htm

http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html

http://www.utteraccess.com/forum/Time-Pieces-date-time-Pi-t1901319.html

See my brief article on the subject at: http://www.devhut.net/2010/06/10/ms-access-calendar-control/

---

Daniel Pineault - 2010-2013 MVP

http://www.cardaconsultants.com

http://www.devhut.net

Answer 3

MS have stopped shipping the calendar 2007>

Have a look here for a fix (active X)

http://msdn.microsoft.com/en-us/library/office/gg251104(v=office.14).aspx

Or if you have a copy of access 2003 2007 you can just copy the MSCAL to your system.

But MS thinks it's a better to use text boxes as date pickers.  You need to remove the MSCAL control from the form then format a text box as a date - this way you get the date picker back (don't forget to select Show Date Picker in the properties box)

PS - I like the new text box date picker.  Much better than the old popup calender