 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / ActiveX Controls / January 2005Date AND Time Picker???
Hello, I need either a usercontrol, or some method/example of how to set the date and time for a single field, but through two inputs in Access. In other words, the field name is "MeetDateTime", and I want the user to enter the date, maybe, in unbound text boxes such as "MeetDate" and "MeetTime", each with their own picker, and then when the form is submitted, they are combined into the MeetDateTime field. Or maybe there's a usercontrol which already has these two fields? Any help or ideas would be greatly apprecited!!!! Thanks in advance, --Jon Hello Jon, I am afraid there is no control to perform this job directly. You may want to use "date and time picker control" for date and time in one control. For example, you could set customformat property to "dd/MMM/yyyy 'at' H:mm". Or you need to write cutom code to manully adjoin the value of the box and update the table by respond to some events such as "updated". However, you also need to manage current record index which brings complexation. Thanks & Regards, Peter Yang MCSE2000, MCSA, MCDBA Microsoft Partner Online Support Get Secure! - www.microsoft.com/security ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: Date AND Time Picker??? | thread-index: AcTx0S/7fBaz4xdpS6K5IxpDRuJlOg== [quoted text clipped - 32 lines] | | --Jon Well I finally managed to create a popup form using the picker control because it can't be used directly in continuous forms view, but are you saying that there's a way to make one date picker edit both date and time? Using a format? Or were you just suggesting I use a custom Input Mask? The problem with the mask is that there is not *always* a time with the date, and the input mask doesn't handle this inconsistency well. My initial efforts at adjoining the fields manually had failed, but I just re-reviewed my original code, and suddenly I see the typo the kept it from working! --Jon > Hello Jon, > [quoted text clipped - 63 lines] > | > | --Jon Hello Jon, It is possible to edit both date and time in one date and time picker control. 1. Open the form in design mode, right click the Activex control->Dtpicker Object->Properites 2. On General tab, change "Customformat" to "dd/MMM/yyyy 'at' H:mm " (without quotes). Hope this helps. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: Date AND Time Picker??? | thread-index: AcTyJmZkghyUnP1xSkCeBi0rrrW+6w== | X-WBNR-Posting-Host: 68.51.159.109 | From: "=?Utf-8?B?Y29kZQ==?=" <code@community.nospam> | References: <8A7C1F93-F936-45B2-AB1C-223B140FAAF4@microsoft.com> <cv82nQi8EHA.764@cpmsftngxa10.phx.gbl> | Subject: RE: Date AND Time Picker??? | Date: Mon, 3 Jan 2005 22:27:01 -0800 [quoted text clipped - 12 lines] | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 | Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0 3.phx.gbl | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.activexcontrol:35528 | X-Tomcat-NG: microsoft.public.access.activexcontrol [quoted text clipped - 79 lines] | > | | > | --Jon Neat! Thank you, I think that works rather well! --Jon > Hello Jon, > [quoted text clipped - 147 lines] > | > | > | > | --Jon Hello Jon, My pleasure. :-) Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | Thread-Topic: Date AND Time Picker??? | thread-index: AcTycLnC4tF/KgQ5Tr2RfM/CBRb+7w== | X-WBNR-Posting-Host: 68.51.159.109 | From: "=?Utf-8?B?Y29kZQ==?=" <code@community.nospam> | References: <8A7C1F93-F936-45B2-AB1C-223B140FAAF4@microsoft.com> <cv82nQi8EHA.764@cpmsftngxa10.phx.gbl> <A0E61152-169A-4D76-93CD-C5C0843475A1@microsoft.com> <ig1DHZk8EHA.3152@cpmsftngxa10.phx.gbl> | Subject: RE: Date AND Time Picker??? | Date: Tue, 4 Jan 2005 07:19:04 -0800 [quoted text clipped - 12 lines] | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0 3.phx.gbl | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.activexcontrol:35536 | X-Tomcat-NG: microsoft.public.access.activexcontrol [quoted text clipped - 54 lines] | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0 | > 3.phx.gbl | > | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.activexcontrol:35528 [quoted text clipped - 95 lines] | > | > | | > | > | --Jon |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.