UtterAccess.com
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: 9



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,129
From: Wisconsin



ic60650,

Instead 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


--------------------
(;,;) Li'l Cthulu says: Make sure you provide enough info in your questions!
Changing your real table name to "Table1" and your real form name to "Form1" makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page
 
+
Peter Hibbs
post Jul 30 2010, 10:02 AM
Post #3

UtterAccess VIP
Posts: 1,003
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: 28th July 2014 - 05:30 PM