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
|
|||
|
|||
Start Time and End Time field templates require dates, not times
I am a novice at Access. I am using Access 2007. I am trying to design a
form. I added a Start Time and End Time field from the Event fields. But when I try to insert times into these fields, they insist on dates, not times. A tiny calendar appears next to the field when I am trying to type a time. And when I do type a time, I get the message that says that the input value must be greater than 1/1/1900. This appears to be a bug in these field templates. Is there a fix for this? |
#2
|
|||
|
|||
Start Time and End Time field templates require dates, not times
Access stores the date and times as a signle field. You need to set the
format for the field to time. See this: http://support.microsoft.com/kb/210276 Bonnie http://www.dataplus-svc.com/database_programming.htm Rojo26 wrote: I am a novice at Access. I am using Access 2007. I am trying to design a form. I added a Start Time and End Time field from the Event fields. But when I try to insert times into these fields, they insist on dates, not times. A tiny calendar appears next to the field when I am trying to type a time. And when I do type a time, I get the message that says that the input value must be greater than 1/1/1900. This appears to be a bug in these field templates. Is there a fix for this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#3
|
|||
|
|||
Start Time and End Time field templates require dates, not tim
Bchicks, I appreciate your assistance, but I don't think you understand my
problem. When I open Access 2007, on the right side of the screen, there is a list of field templates to use. Under Events, there are Start Time and End Time. There are other field templates for dates. I must assume that these field templates are already supposed to be set for time and not dates. Otherwise, why would they be in the list? As I said, I am a novice. I don't know how to write code, and I don't have the time to learn. I can't be concerned with how Access stores information internally. I have other work to do, and I need to create forms to make my other work go much quicker. All the other field templates I have used work fine except these two. So I think there was a mistake made by Microsoft. Since no one knows of a fix for this problem, perhaps someone knows of a field template that accepts times and not dates without having to program it. Anyone? Joel "bhicks11 via AccessMonster.com" wrote: Access stores the date and times as a signle field. You need to set the format for the field to time. See this: http://support.microsoft.com/kb/210276 Bonnie http://www.dataplus-svc.com/database_programming.htm Rojo26 wrote: I am a novice at Access. I am using Access 2007. I am trying to design a form. I added a Start Time and End Time field from the Event fields. But when I try to insert times into these fields, they insist on dates, not times. A tiny calendar appears next to the field when I am trying to type a time. And when I do type a time, I get the message that says that the input value must be greater than 1/1/1900. This appears to be a bug in these field templates. Is there a fix for this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 . |
Thread Tools | |
Display Modes | |
|
|