Missing date picker control after upgrade

[cliftonx]

I just upgraded an .accdb database from Microsoft Access 2010 to Microsoft Access 2016. After the upgrade, I opened the Access 2016 version and noticed that when I opened one of my forms, the date picker control is missing. I really need that date picker control back on the form and working, just as it did in my Access 2010 version. Please advise as to what I'm doing wrong?

Thank You!!!

 

[Uncle Gizmo]

when I opened one of my forms, the date picker control is missing)

Do you mean you have a pop-up form which has a calendar in it to allow you to select the date?

 

[cliftonx]

Yes, that's right, its a sub form actually. I've posted a before and after shots. Please see attachments.

Thanks!!

 

[Uncle Gizmo]

It'll most likely be the Microsoft active x control which has been discontinued. You have to replace it with a non active x control. There are many. I think Ridders posted one in the example dB section of this forum. Also Allen Browne has one on his website.

Popup Calendar
Provided by Allen Browne, October 2004. Updated April 2010.

Sent from my SM-G925F using Tapatalk

 

[Uncle Gizmo]

There are many ways to set up a non active x control calendar. I used the calendar control setup problem as a basis for a set of videos on how to build a Class Module.

This is the 1st video in the series:-
https://youtu.be/xBC_WVioWnY

And this is the Play List:-
Object Oriented - MS Access - VBA (12 videos)


Sent from my SM-G925F using Tapatalk

 

[Uncle Gizmo]

The "Ridders" one I was thinking of is HERE:-

https://www.access-programmers.co.uk/forums/showthread.php?t=293996

 

[missinglinq]

It'll most likely be the Microsoft active x control which has been discontinued.

That would be my guess, as well, although what your graphic shows looks like a Combobox, in the 'before' image, rather than a DatePicker.

With the native DatePicker, present since v2007 for any DateTime control, why are you bothering with an addon one?

Linq ;0)>

 

[isladogs]

With the native DatePicker, present since v2007 for any DateTime control, why are you bothering with an addon one?

The built in date picker has issues which even Microsoft acknowledge.
In fact they have a web page suggesting alternatives for those who don't like it!.
https://msdn.microsoft.com/en-us/library/office/gg251104(v=office.14).aspx

Add on calendars can improve functionality - there's no need to use ActiveX alternatives.
The link by Uncle Gizmo to the calendar I uploaded (but didn't write) is one very good alternative

The file is here (and in several other threads):
https://www.access-programmers.co.uk/forums/showpost.php?p=1533910&postcount=2

Its has lots of downloads so perhaps its time I uploaded it to sample databases so its easier to find

 

[Uncle Gizmo]

I can't see the Word doc on my phone or Chromebook and I didn't really want to go and fire up my PC as it's bloody cold in the office!

 

[missinglinq]

The built in date picker has issues which even Microsoft acknowledge.

In fact they have a web page suggesting alternatives for those who don't like it!.

Add on calendars can improve functionality

That page cited is simply a guide for replacing the missing mscal.ocx calendar, in pre-existing, pre-2007 databases. Using alternatives to the ActiveX Calendar, in pre-2007 versions, has always been preferable, and a number of clever hacks, probably including those linked to, here, have been created to do this.

But you might notice that one of the methods of replacing the ActiveX Calendar, listed by Mircosoft, is using the native DatePicker!

And yes, there are times that Addon calendars can improve functionality. But probably not unless the 'from' and 'to' dates, being picked here, are dates in the far back or far future.

Linq ;0)>

 

[isladogs]

That page cited is simply a guide for replacing the missing mscal.ocx calendar, in pre-existing, pre-2007 databases. Using alternatives to the ActiveX Calendar, in pre-2007 versions, has always been preferable, and a number of clever hacks, probably including those linked to, here, have been created to do this.

But you might notice that one of the methods of replacing the ActiveX Calendar, listed by Mircosoft, is using the native DatePicker!

Yes I accept all that but they also offer alternatives

And yes, there are times that Addon calendars can improve functionality. But probably not unless the 'from' and 'to' dates, being picked here, are dates in the far back or far future.

Linq ;0)>

I often find a need to change months or years so one reason why I rarely use the date picker.
Another is that I prefer to have the small calendar button always visible which isn't the case for the date picker.

But that's just my preference.
Similarly, you'll use whichever tool suits you....

 

[Uncle Gizmo]

I hate the default MS Access date picker. I cannot understand why they got rid of the active x control - it just doesn't make sense.

Sent from my SM-G925F using Tapatalk