Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS Date Picker 64 bit 32 bit issue

Posted on 2016-10-23
12
60 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Flowing down data to other tables 13 32
update query 4 25
Send Meeting Request from Shared Mailbox 3 59
Random times with 12/24 hour switching 9 28
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.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 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