Date & Time Picker for Access 2010

I am looking for a Date & Time Picket solution for Access 2010. The control I was using in 2007 worked great but since I moved up to 2010 it stopped working. The control is dependant on MSCAL.Calendar.7 which is not available in 2010. Any suggestions would be appreciated.
DestinyToursAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There are lots of suggestions here:

http://www.granite.ab.ca/access/calendars.htm

You would be best served to use a method that uses "native" Access controls, or an API call, rather than ActiveX controls.

Jeff Conrad has some also:

http://www.accessmvp.com/JConrad/accessjunkie/calendars.html
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Um ... what about the built in Date Picker, available in a Text Box ?

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
1

2

Otherwise ...  my all time favorite ... all vba code driven and super flexible
http://www.lebans.com/monthcalendar.htm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

John CarrollCommented:
The key here is I need to enter Date & Time for flights. The built-in date picker is excellent but only does dates. In fact I believe most or all of the previous suggestions are date only. I searched the web into the wee hours of the morning last night but could only find date-only pickers.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"I need to enter "
I'm confused. You are not the OP ?
0
John CarrollCommented:
I am the OP but the system is now calling me Frozone.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
http://www.viescas.com/Info/links.htm#Downloads

The download above named "Calendar.zip" does Date and Time.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
wow ....  ok then.
That's a first I believe.
0
DestinyToursAuthor Commented:
I think we have this OP issue corrected so sorry about the confusion.

Calendar zip does in fact do date and time and has a version that works without OCX so If I have to use this one I will - thank you!

Please find attached a copy of the Date/Time Picket I have been using for the past few years (greatest thing since sliced bread). As you can see it uses slider controls for hour and minutes but this control needs MSCAL.Calendar.7 which is not available in 2010. Do you think there is a way to get this to work without MSCAL.Calendar.7 (or register MSCAL.Calendar.7 on my 2010)?
DateTimePicker.mdb
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You should ... be able to put that OCX (if you have a copy) in the same folder as your db (or wherever) and then set a VBA Reference to it.
I tried this some time ago and it worked.
See if it does ...  no registration was necessary in this case.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You may not be able to legally deploy that control, so be aware of that.

Note that you'll have more and more trouble with these sorts of things as you move up in Access versions, so your best bet for "future proofing" your application is to do away with non-compliant ActiveX controls where possible, or move to a programming environment that supports third party controls (like .NET).
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Scott ... are you saying that MSCAL.Calendar.7 is non-compliant ?

Also, I downloaded John's calender ... and it also uses MSCAL.Calendar.7  ... consequently does not work in >=A2010 ... 'no ojbect.
Were you aware of that ?
0
John CarrollCommented:
Since I really want to keep using this control I continued to research and here is what I did.

Copied MSCAL.OCX from one of my PCs with Office 2007 to my C:\windows\syswow64 directory. I see that this control is owned by Microsoft so I made an executive decision to continue using it.
Opened the Command window as Administrator and navigated the C:\windows\syswow64 directory.
Typed the command: regsvr32 mscal.ocx
Restarted Access and Bob's your uncle (Date/Time Picket is back, it's sexy, I can enter flights again and all is right with the world).

If anyone objects to me using MSCAL.OCX in Access 2010, please complete type out your complaint in triplicate and forward to Microsoft.

Better yet, if Microsoft decides to upgrade their built-in date picker to also support time similar the control I am using, then even better.

Thanks for all of the responses on this and hopefully it will help others :-)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Executive decision to continue using it."

But ... as Scott eluded to ... it's really a licensing issue ... and technically, you probably do not have rights to use it. However, if only being used on your system ... then I personally would not worry about it.

mx
0
John CarrollCommented:
I know it may be a licensing issue but since it appears that Microsoft owns the control, I can't imagine that they would want be to stop using it on an upgraded version of their product so I made an Executive decision (and yes it's only on my system). But if Microsoft is reading this and they insist that I remove MSCAL.OCX from my 2010 install then I am happy to cease & desist.

In fact I am going to be proactive and send a copy of this control to a buddy of mine who works at Microsoft and ask him to suggest to his Access team to replicate this into a new built-in Date/Time Picker.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
umm ... As someone who attends the MVP Summits each year and spends 3 days with the Access Product Group ... good luck with that :-)
But you can certainly try ....

Hey ... if you have a chance, can you try the setting a Reference approach?   You might have to temporarily Unregister it.
0
John CarrollCommented:
I attended the Access/VB DevCons conferences for years (late 90s to 2004) and they were open to suggestions then but I guess things have changed.

Not sure what you mean by the Reference approach. I can also deregister the control if I had to.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
This post above:

"You should ... be able to put that OCX (if you have a copy) in the same folder as your db (or wherever) and then set a VBA Reference to it.
I tried this some time ago and it worked.
See if it does ...  no registration was necessary in this case."


" I guess things have changed."
The focus is 100% on Web Apps.  No further changes to the Desktop side :-(
0
John CarrollCommented:
Do you mean in Tools, Reverences, Browse then select the MSCAL.OCX? If so the I would have to deregister the control first in order to see if this works not?

Regarding focusing on web apps, that actually makes sense. In fact I need to find a way to move my back-end to the cloud so I have access to my database from anywhere. I might have to hire some help for that. This be the next thread I post to see what others are doing.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Do you mean in Tools, Reverences, Browse then select the MSCAL.OCX? If so the I would have to deregister the control first in order to see if this works not?"

Exactly.
To keep all things equal ... I would definitely unregiser it first ... just so there is no chance of fooling ourselves that it is working.
0
John CarrollCommented:
I unregistered the OCX and set the VBA reference but it didn't work. It will only work if the control is registered.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What happened exactly ?
errors ?
0
John CarrollCommented:
Can't remember the specific error. If you open the form in the database I posted you'll see the error.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Scott ... are you saying that MSCAL.Calendar.7 is non-compliant ?
I'm saying ANY ActiveX control is non-compliant with Access 2007 or greater, unless the owner of that control specifically states otherwise. As far as I know, MSFT has not claimed any sort of official compliance with any controls since Access 2003.

So if it works, then it works - but don't say we didn't warn ya :)

If anyone objects to me using MSCAL.OCX in Access 2010, please complete type out your complaint in triplicate and forward to Microsoft.
I realize this is a bit tongue-in-cheek, but as Joe said this is a licensing issue. While I doubt MSFT will swoop down with the black helicopters, EE doesn't really approve of suggestions that circumvent licensing/security/etc, and as such tends to appreciate it when the Experts point out these matters to others.
0
John CarrollCommented:
I completely understand about licensing and if I planned to roll this program out to a bunch of users in a large company or commercially that that would be a different story, but this is just for my use. But even if I tried to approach Microsoft to license an ActiveX control that they haven't supported for 10+ years I doubt I would get a return phone call or email as it wouldn't be worth their time.

When I get the time I would like to hammer away at this though to see if there is a way I can reproduce this slick Date/Time Picker without the use of the MSCAL.OCX control. It sure makes it a lot easier to enter flights.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"If you open the form in the database I posted you'll see the error."
OH ... well, you probably need to delete the existing Control on that Form, then re-select/insert it from the list of ActiveX Controls.  Pretty sure that is what I had to do.
I would try this, but I do not have access to that OCX right now ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.