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
|
|||
|
|||
date and time field
2 issues:
1. I want the start time to automatically enter itself. I know that I can do this by entering: now() view the date is displayed as : 10/4/2008 10:14:43 AM. I don't want the date to display this way, but in Saturday, October 04, 2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section? 2. The above format automatically enters the time stamp.In this instance I want to manually enter the date and time stamp by selecting the date picker picker. I want to be able to manually enter the time stamp in the same format: Saturday, October 04, 2008 10:14:43 AM. How do I accomplish this? |
#2
|
|||
|
|||
date and time field
"AD" wrote in message
news 2 issues: 1. I want the start time to automatically enter itself. I know that I can do this by entering: now() view the date is displayed as : 10/4/2008 10:14:43 AM. I don't want the date to display this way, but in Saturday, October 04, 2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section? You don't use the Default Value property to affect the display format. Use the Format property instead. Set that property to the desired display format that you want. 2. The above format automatically enters the time stamp.In this instance I want to manually enter the date and time stamp by selecting the date picker picker. I want to be able to manually enter the time stamp in the same format: Saturday, October 04, 2008 10:14:43 AM. I'm confused... you want to use the datetime picker to select the date/time, but you then want to manually enter the date/time value? Don't you do one or the other? Regardless, see my answer to your first question above. -- Ken Snell MS ACCESS MVP |
#3
|
|||
|
|||
date and time field
I think you can use: Me![Text1] = Format(Now(), "MMMM DD HH:MM:Ss Am/PM") Thanks LD -- Lorenzo DÃ*az Cad Technician "AD" wrote: 2 issues: 1. I want the start time to automatically enter itself. I know that I can do this by entering: now() view the date is displayed as : 10/4/2008 10:14:43 AM. I don't want the date to display this way, but in Saturday, October 04, 2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section? 2. The above format automatically enters the time stamp.In this instance I want to manually enter the date and time stamp by selecting the date picker picker. I want to be able to manually enter the time stamp in the same format: Saturday, October 04, 2008 10:14:43 AM. How do I accomplish this? |
#4
|
|||
|
|||
date and time field
Let me clarify what I am trying to do. I am creating a radio dispatch data
base. I set one field for the start date and time. That field is where I have the now() in the default value. The issue on this is how I want it to appear. I want it to show the day, month, day and year as Saturday, October 04, 2008 10:14:43 AM. This information is automatically entered as the rest of the fields are filled out. The second date and time field will be for the end of date and time. Since the now() automatically enters the most currently information and not when the call is being closed out I need to figure out what I need to do to manually select the day with the date picker with the date and current time of the close of the call. Example, Saturday, October 04, 2008 10:30:00 AM "Ken Snell (MVP)" wrote: "AD" wrote in message news 2 issues: 1. I want the start time to automatically enter itself. I know that I can do this by entering: now() view the date is displayed as : 10/4/2008 10:14:43 AM. I don't want the date to display this way, but in Saturday, October 04, 2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section? You don't use the Default Value property to affect the display format. Use the Format property instead. Set that property to the desired display format that you want. 2. The above format automatically enters the time stamp.In this instance I want to manually enter the date and time stamp by selecting the date picker picker. I want to be able to manually enter the time stamp in the same format: Saturday, October 04, 2008 10:14:43 AM. I'm confused... you want to use the datetime picker to select the date/time, but you then want to manually enter the date/time value? Don't you do one or the other? Regardless, see my answer to your first question above. -- Ken Snell MS ACCESS MVP |
#5
|
|||
|
|||
date and time field
As I said, use the Format property of the field to set the display format
that you want. How you display the date/time value does not change how ACCESS actually stores the date/time value in the table, nor how you enter the data. Enter this for the Format property of the fields: dddd mmmm d", "yyyy hh:nn:ss ampm As for "manually" entering the current date and time in a field, you can use keyboard shortcuts. When you're in the field, first press Ctrl+; (enters the date) then press the space bar to enter a space then press Ctrl+Shift+; (enters the time). ACCESS will properly store the date/time value, and if you've set the Format property the way you want, the value will be diplayed the way you want when you click away from the field. -- Ken Snell MS ACCESS MVP "AD" wrote in message ... Let me clarify what I am trying to do. I am creating a radio dispatch data base. I set one field for the start date and time. That field is where I have the now() in the default value. The issue on this is how I want it to appear. I want it to show the day, month, day and year as Saturday, October 04, 2008 10:14:43 AM. This information is automatically entered as the rest of the fields are filled out. The second date and time field will be for the end of date and time. Since the now() automatically enters the most currently information and not when the call is being closed out I need to figure out what I need to do to manually select the day with the date picker with the date and current time of the close of the call. Example, Saturday, October 04, 2008 10:30:00 AM "Ken Snell (MVP)" wrote: "AD" wrote in message news 2 issues: 1. I want the start time to automatically enter itself. I know that I can do this by entering: now() view the date is displayed as : 10/4/2008 10:14:43 AM. I don't want the date to display this way, but in Saturday, October 04, 2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section? You don't use the Default Value property to affect the display format. Use the Format property instead. Set that property to the desired display format that you want. 2. The above format automatically enters the time stamp.In this instance I want to manually enter the date and time stamp by selecting the date picker picker. I want to be able to manually enter the time stamp in the same format: Saturday, October 04, 2008 10:14:43 AM. I'm confused... you want to use the datetime picker to select the date/time, but you then want to manually enter the date/time value? Don't you do one or the other? Regardless, see my answer to your first question above. -- Ken Snell MS ACCESS MVP |
Thread Tools | |
Display Modes | |
|
|