UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

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

New Member
Posts: 8



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: 12,704
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,069
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
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 24th October 2014 - 11:08 AM