UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> Date Picker, Office 2007    
 
   
ic60650
post Jul 30 2010, 09:22 AM
Post#1



Posts: 8
Joined: 27-March 07



Is there any way to enable the date picker on an unbound text box? My ActiveX controls from older versions of Access have stopped working and I'm looking for a quick solution. Any help appreciated.
Go to the top of the page
 
doctor9
post Jul 30 2010, 09:45 AM
Post#2


UtterAccess Editor
Posts: 13,305
Joined: 29-March 05
From: Wisconsin


ic60650,
nstead of an ActiveX control, you can use a user-created date picker based on a form in the way you describe. For example, check out the TimePieces Demo in our code archive forum.
Hope this helps,
Dennis
Go to the top of the page
 
Peter Hibbs
post Jul 30 2010, 10:02 AM
Post#3


UtterAccess VIP
Posts: 1,147
Joined: 17-June 10
From: Dorset. UK.


Hi ic60650,
Since you are presumably using Access 2007 (accdb format) you can show the built-in Date Picker pop-up form when an unbound control gets the focus.
Just make sure the control's Show Date Picker property is set to For Dates and the Format property has a valid date format (say Long Date or whatever) and when the focus moves to the control the date picker form will appear.
HTH
Peter Hibbs.
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    6th March 2015 - 12:30 PM