Solved

MS Date Picker 64 bit 32 bit issue

Posted on 2016-10-23
12
54 Views
Last Modified: 2016-10-24
Hi - I've developed a small Access Database application in a 64 bit environment.  It uses the MSCOMCT2.OCX Date picker control.  I'm trying to set it up on a user's computer which is 32 bit and this control isn't there, and I can't register it either.

Is there another control that will work in both environments, or another way round this - I need a quick fix, it doesn't have to be elegant.?
Using Access 2013


Many thanks


A
0
Comment
Question by:Sokella
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 57
ID: 41856322
No "quick" work around that I'm aware of and just to be clear; is your Access app running in 32 or 64 bit mode (not the OS).  If it truly is 64 bit,  your choices:

1. Switch to a 3rd party control, such as DBI's (www.dbi-tech.com)
2. Switch to another date picker like this: http://www.lebans.com/monthcalendar.htm  which is built on native controls.
3. use the one built into Access.

Jim.
0
 
LVL 57
ID: 41856324
BTW, here's the one I use:

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

The first I posted may still have issues in a 64 bit environment (haven't tried it).  This is the one I meant to post.

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41856358
I have a date/time picker I developed in just VBA (1 table, a query, a form and a code module) that I have posted on my website.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 41856535
"3. use the one built into Access."
I totally agree with that.  Frankly, I see 'date pickers' as overrated for the most part.
Whereas at work I enable the built in Date Picker (>=A2010), almost all users just type in a date ... FAST.
And they all know that (assuming a DateTime data type) if you are entering a date in the current year, at most ... you only have to type mm-dd because Access will automatically add the year.  Now sometimes they are convenient say if you need the Date for some particular day of the week/month ...eg 'last Tuesday', in which case the built in Date Picker works just fine.
0
 
LVL 57
ID: 41856838
<<I enable the built in Date Picker (>=A2010), >>

 Think it was 2007 and up if I'm not mistaken.    I don't use it, so I'd have to double check, but I'm pretty sure it was 2007 and up.

Jim.
0
 
LVL 75
ID: 41857378
Yeah ... since I've never use A2007 ... that's why I only mentioned >=A2010 ... but I think you are correct it was in A2007.
0
 

Author Comment

by:Sokella
ID: 41857648
OK - so if I go with option 3. Use the one built into Access, where do I find it?  Also, if I have unbound controls can I make one of them a date/time control?

Thanks

A
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 41857663
You enable it on the Property sheet for a Text box.


date picker
0
 
LVL 75
ID: 41857672
"  Also, if I have unbound controls can I make one of them a date/time control?"
Well ... if ... the Control Source for the Text Box is not a DateTime data type Field (from a table or query), then the Date Picker does not show ... so, that is kind of a Gotcha :-(
Seems this is where Microsoft dropped the ball ... unless I am missing something ...
There might be a way to fake it ... not sure.

date picker 2
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 41857680
You might try setting the Format property of the textbox to one of the date formats, that might work even with an unbound control.
0
 
LVL 75
ID: 41857689
yes ...that does work ...so the answer to the question
"  Also, if I have unbound controls can I make one of them a date/time control?"

is .... Yes !
0
 

Author Closing Comment

by:Sokella
ID: 41857697
Many thanks to all who contributed.  This works just fine.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question