If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Easy Time Entry on a form?? Help.
I am working on a project that is requiring many date and time fields.
From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#2
|
|||
|
|||
Easy Time Entry on a form?? Help.
I use the MS Date and Time picker this can be found by opening a form in
design view select Insert, Active X Control, Microsoft Date and Time Picker Control 6.0 Have a look and see what you think. HTH S "Jeff C" wrote in message oups.com... I am working on a project that is requiring many date and time fields. From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#3
|
|||
|
|||
Easy Time Entry on a form?? Help.
Thanks for your reply, I looked at that but could not get anything but a
calendar for the date to show up. I have used Allen Browne's Calendar Control extensively in just about every tool I have built but cannot find a clock control. Date and Time picker has one? Are there problems with that control? If I found the controls I was thinking of assigning a command button to run update queries on all the date and time fields one at a time as the data is entered. One button for field 1, oanother for field 2 etc. Thanks for your ideas -- Jeff C Live Well .. Be Happy In All You Do "Simon Glencross" wrote: I use the MS Date and Time picker this can be found by opening a form in design view select Insert, Active X Control, Microsoft Date and Time Picker Control 6.0 Have a look and see what you think. HTH S "Jeff C" wrote in message oups.com... I am working on a project that is requiring many date and time fields. From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#4
|
|||
|
|||
Easy Time Entry on a form?? Help.
I use the DateTime Picker Control regularly without any problem.
If you want, post your email address and I send you a database with a a Form using the Calendar Control for date-component value and a DateTime Picker Control for time-component value. -- HTH Van T. Dinh MVP (Access) "Jeff C" wrote in message ... Thanks for your reply, I looked at that but could not get anything but a calendar for the date to show up. I have used Allen Browne's Calendar Control extensively in just about every tool I have built but cannot find a clock control. Date and Time picker has one? Are there problems with that control? If I found the controls I was thinking of assigning a command button to run update queries on all the date and time fields one at a time as the data is entered. One button for field 1, oanother for field 2 etc. Thanks for your ideas -- Jeff C Live Well .. Be Happy In All You Do "Simon Glencross" wrote: I use the MS Date and Time picker this can be found by opening a form in design view select Insert, Active X Control, Microsoft Date and Time Picker Control 6.0 Have a look and see what you think. HTH S "Jeff C" wrote in message oups.com... I am working on a project that is requiring many date and time fields. From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#5
|
|||
|
|||
Easy Time Entry on a form?? Help.
Thanks Van
jpcoulsonathotmaildotcom I appreciate your help! -- Jeff C Live Well .. Be Happy In All You Do "Van T. Dinh" wrote: I use the DateTime Picker Control regularly without any problem. If you want, post your email address and I send you a database with a a Form using the Calendar Control for date-component value and a DateTime Picker Control for time-component value. -- HTH Van T. Dinh MVP (Access) "Jeff C" wrote in message ... Thanks for your reply, I looked at that but could not get anything but a calendar for the date to show up. I have used Allen Browne's Calendar Control extensively in just about every tool I have built but cannot find a clock control. Date and Time picker has one? Are there problems with that control? If I found the controls I was thinking of assigning a command button to run update queries on all the date and time fields one at a time as the data is entered. One button for field 1, oanother for field 2 etc. Thanks for your ideas -- Jeff C Live Well .. Be Happy In All You Do "Simon Glencross" wrote: I use the MS Date and Time picker this can be found by opening a form in design view select Insert, Active X Control, Microsoft Date and Time Picker Control 6.0 Have a look and see what you think. HTH S "Jeff C" wrote in message oups.com... I am working on a project that is requiring many date and time fields. From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#6
|
|||
|
|||
Easy Time Entry on a form?? Help.
Zipped file is on its way.
-- HTH Van T. Dinh MVP (Access) "Jeff C" wrote in message ... Thanks Van jpcoulsonathotmaildotcom I appreciate your help! -- Jeff C Live Well .. Be Happy In All You Do |
#7
|
|||
|
|||
Easy Time Entry on a form?? Help.
Hello! My situation is almost exactly like what JeffC described. I have
several fields that require both date and time to be entered, and it would be nice if I could provide a calendar tool to make data entry easier. Would you be able to forward me that zip file you sent Jeff? Or point me to a website or two that have date and time pickers? techgeek1234 at hotmail.com Thank you! "Van T. Dinh" wrote: I use the DateTime Picker Control regularly without any problem. If you want, post your email address and I send you a database with a a Form using the Calendar Control for date-component value and a DateTime Picker Control for time-component value. -- HTH Van T. Dinh MVP (Access) "Jeff C" wrote in message ... Thanks for your reply, I looked at that but could not get anything but a calendar for the date to show up. I have used Allen Browne's Calendar Control extensively in just about every tool I have built but cannot find a clock control. Date and Time picker has one? Are there problems with that control? If I found the controls I was thinking of assigning a command button to run update queries on all the date and time fields one at a time as the data is entered. One button for field 1, oanother for field 2 etc. Thanks for your ideas -- Jeff C Live Well .. Be Happy In All You Do "Simon Glencross" wrote: I use the MS Date and Time picker this can be found by opening a form in design view select Insert, Active X Control, Microsoft Date and Time Picker Control 6.0 Have a look and see what you think. HTH S "Jeff C" wrote in message oups.com... I am working on a project that is requiring many date and time fields. From these I will be building queries that will be calculating different elapsed time values. In the past I have used a pop up calendar making the entry of a date quicker/easier. Has anybody come up with a tool that does the same with time? My fields are formatted as a general date and on my data entry form I customized an input mask to take the full date and military time entries, it just results in alot of repetative entry when in most cases everything happens on the same day. However on those occasions when the data covers time before and after midnight it is necessary. I appreciate any thoughts or ideas/solutions. Thank you |
#8
|
|||
|
|||
Easy Time Entry on a form?? Help.
zipped file is on its way.
-- HTH Van T. Dinh MVP (Access) "Tech Geek 1234" wrote in message ... Hello! My situation is almost exactly like what JeffC described. I have several fields that require both date and time to be entered, and it would be nice if I could provide a calendar tool to make data entry easier. Would you be able to forward me that zip file you sent Jeff? Or point me to a website or two that have date and time pickers? techgeek1234 at hotmail.com Thank you! |
#9
|
|||
|
|||
Easy Time Entry on a form?? Help.
Thank you very much! That form is perfect!
"Van T. Dinh" wrote: zipped file is on its way. -- HTH Van T. Dinh MVP (Access) "Tech Geek 1234" wrote in message ... Hello! My situation is almost exactly like what JeffC described. I have several fields that require both date and time to be entered, and it would be nice if I could provide a calendar tool to make data entry easier. Would you be able to forward me that zip file you sent Jeff? Or point me to a website or two that have date and time pickers? techgeek1234 at hotmail.com Thank you! |
#10
|
|||
|
|||
Easy Time Entry on a form?? Help.
(Jeff liked it too ...)
You're welcome ... Glad the zipped file helps. -- HTH Van T. Dinh MVP (Access) "Tech Geek 1234" wrote in message ... Thank you very much! That form is perfect! |
|
Thread Tools | |
Display Modes | |
|
|