Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / January 2005

Tip: Looking for answers? Try searching our database.

Date AND Time Picker???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
code - 03 Jan 2005 20:17 GMT
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
Peter Yang [MSFT] - 04 Jan 2005 06:10 GMT
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
code - 04 Jan 2005 06:27 GMT
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
Peter Yang [MSFT] - 04 Jan 2005 10:15 GMT
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
code - 04 Jan 2005 15:19 GMT
Neat! Thank you, I think that works rather well!

--Jon

> Hello Jon,
>
[quoted text clipped - 147 lines]
> | > |
> | > | --Jon
Peter Yang [MSFT] - 05 Jan 2005 01:26 GMT
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
 
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.