Sokella
asked on
MS Date Picker 64 bit 32 bit issue
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
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
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.
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<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.
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.
Yeah ... since I've never use A2007 ... that's why I only mentioned >=A2010 ... but I think you are correct it was in A2007.
ASKER
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
Thanks
A
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
" 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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 !
" Also, if I have unbound controls can I make one of them a date/time control?"
is .... Yes !
ASKER
Many thanks to all who contributed. This works just fine.
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.