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
|
|||
|
|||
entering data in date time field
I have the following problem: When I try to enter data in a date time field
of a new record, I get the following message: "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSixe setting." The date time field is mm/dd/yyyy hhnn. I get the message both when I enter data including the slashes and space, and when I use an input mask. I had created the date time field using the CDate function on fields month, day, year, and time, and ran a make table query for the date time field to be part of the table. For a new record, I got the error message even if I entered data that was identical to that of any previous record in which the data in the date time field was accepted. What's the trick? |
#2
|
|||
|
|||
entering data in date time field
Sounds like your entry is not being interpreted correctly.
Open the table in design view. Check that the field is a Date/Time type. Remove anything in the Format and Input Mask properties of the field (lower pane.) Save, and switch the table to datasheet view. Try entering a value, including the 2 slashes and the colon between the hours and minutes. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "LAF" wrote in message ... I have the following problem: When I try to enter data in a date time field of a new record, I get the following message: "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSixe setting." The date time field is mm/dd/yyyy hhnn. I get the message both when I enter data including the slashes and space, and when I use an input mask. I had created the date time field using the CDate function on fields month, day, year, and time, and ran a make table query for the date time field to be part of the table. For a new record, I got the error message even if I entered data that was identical to that of any previous record in which the data in the date time field was accepted. |
#3
|
|||
|
|||
entering data in date time field
On Fri, 25 Nov 2005 21:20:02 -0800, LAF
wrote: "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSixe setting." The date time field is mm/dd/yyyy hhnn. I get the message both when I enter data including the slashes and space, and when I use an input mask. Try entering a : between the hours and minutes, it may be objecting to 2005 2005 (at five minutes after eight pm). John W. Vinson[MVP] |
#4
|
|||
|
|||
entering data in date time field
Hi Allen and John,
Thanks for the advice. Turns out that if I keep the format, eliminate the input mask, and manually type the colon between hours and minutes, access saves the record and eliminates the colon according to format. However, if I use an input mask with the colon, access gives the error message indicated in earlier post. This leads to another question. Is there any input mask that could be used so that data entry does not require the person to manually put in slashes, space, and colon? Thanks, LAF "Allen Browne" wrote: Sounds like your entry is not being interpreted correctly. Open the table in design view. Check that the field is a Date/Time type. Remove anything in the Format and Input Mask properties of the field (lower pane.) Save, and switch the table to datasheet view. Try entering a value, including the 2 slashes and the colon between the hours and minutes. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "LAF" wrote in message ... I have the following problem: When I try to enter data in a date time field of a new record, I get the following message: "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSixe setting." The date time field is mm/dd/yyyy hhnn. I get the message both when I enter data including the slashes and space, and when I use an input mask. I had created the date time field using the CDate function on fields month, day, year, and time, and ran a make table query for the date time field to be part of the table. For a new record, I got the error message even if I entered data that was identical to that of any previous record in which the data in the date time field was accepted. |
#5
|
|||
|
|||
entering data in date time field
On Sat, 26 Nov 2005 09:16:06 -0800, LAF
wrote: Hi Allen and John, Thanks for the advice. Turns out that if I keep the format, eliminate the input mask, and manually type the colon between hours and minutes, access saves the record and eliminates the colon according to format. However, if I use an input mask with the colon, access gives the error message indicated in earlier post. This leads to another question. Is there any input mask that could be used so that data entry does not require the person to manually put in slashes, space, and colon? Su 00/00/0000 00:00 If the user types twelve (valid) digits, Access will put in the punctuation for them. John W. Vinson[MVP] |
#6
|
|||
|
|||
entering data in date time field
Hi John,
I got the same error message when I used your input mask and entered 11 then 25 then 2005 then 12 then 50. Access accepts the same data when I do not use the input mask and manually enter the slashes, space, and colon. LAF "John Vinson" wrote: On Sat, 26 Nov 2005 09:16:06 -0800, LAF wrote: Hi Allen and John, Thanks for the advice. Turns out that if I keep the format, eliminate the input mask, and manually type the colon between hours and minutes, access saves the record and eliminates the colon according to format. However, if I use an input mask with the colon, access gives the error message indicated in earlier post. This leads to another question. Is there any input mask that could be used so that data entry does not require the person to manually put in slashes, space, and colon? Su 00/00/0000 00:00 If the user types twelve (valid) digits, Access will put in the punctuation for them. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
The Jet SQL Syntax For Entering A Date And Time Into A DateTime Field | Nathan Sokalski | Running & Setting Up Queries | 2 | June 12th, 2005 05:06 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |