Ms Access Date input field behaving strangely. (1 Viewer)

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
Hello.

I have a database thats been working fine even when i input Date. but recently after updating my Pc. the dates fields on my table or forms does not allow me to enter the date. an error will pop. i tried to change the dates formats and even reset my regional dates format on my Pc but it seems like i am stuck in one place. i will get an error " The value you have entered isnt valid for this field"

see attached.. and what may cause this. i tried to create a new database with a small date table and tried.. still..is it something to do with my Pc or there is something wrong with Ms access 2013

regards
 

Attachments

  • 2021-10-13.png
    2021-10-13.png
    137 KB · Views: 262

Jon

Access World Site Owner
Staff member
Local time
Today, 14:08
Joined
Sep 28, 1999
Messages
7,303
Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:08
Joined
Feb 19, 2002
Messages
42,970
Start by removing all the formatting on the table and on the control. Then remove any validation rules. Make sure the field is defined as Date on the table.

FYI - fomatting a date only affects how it is displayed. Dates are stored internally as double precision numbers with the integer portion represnenting the number of days since 12/30/1899 and the decimal representing the fraction of a day since midnight. So:
1.5 = noon on 12/31/1899
-3.25 = 6 AM on 12/27/1899
5.75 = 6 PM on 1/4/1900
 

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
Attached copy. Try and enter date from the form.
 

Attachments

  • testDateDB.zip
    21.5 KB · Views: 315

Gasman

Enthusiastic Amateur
Local time
Today, 14:08
Joined
Sep 21, 2011
Messages
14,042
I used the widget and that enters dates OK?
I typed in 15/10/1995 and it accepted that?

For the last two I set the format as yyyy-mm-dd
I then entered date as 15/10/2021 and the last as 2001-01-01 and both accepted.?


1634222430480.png
 

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
@Gasman
I am still getting the same error even after setting the format to yyyy-mm-dd .. Maybe explain the widget part of it.
it doesn't accept date from the table or form. i am using office 2013.
 

Attachments

  • 2021-10-26.png
    2021-10-26.png
    122.2 KB · Views: 320

Gasman

Enthusiastic Amateur
Local time
Today, 14:08
Joined
Sep 21, 2011
Messages
14,042
Here is your file back.
If it does not work for you, then I would say your PC is at fault first?
What are your regional date settings meant to be?
Try a repair of Office as well as whatever you updated on your PC is likely the culprit.
If it was a Windows Update, roll it back to check if ithat is the case.
 

Attachments

  • testDateDB.accdb
    436 KB · Views: 301

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
Okay now I believe it might be something to do with my computer or office updates. but what I cant tell.

here are my regional dates settings. i am still getting the error from the file you sent back..
 

Attachments

  • 2021-10-26 (1).png
    2021-10-26 (1).png
    70.3 KB · Views: 220
  • 2021-10-26 (2).png
    2021-10-26 (2).png
    64.2 KB · Views: 328

Gasman

Enthusiastic Amateur
Local time
Today, 14:08
Joined
Sep 21, 2011
Messages
14,042
So your date format os the same as mine (uk)
Try office repair.
As you said it used to work, then i would discount the tables being at fault, but does not hurt to check?
Enter the dates in mm/dd/yyyy format and see if that works
 

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
I tried to enter dates as mm/dd/yyyy.. same error..
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:08
Joined
Sep 21, 2011
Messages
14,042
That's impossible to tell from the screenshot.

@lovBah, open the table and enter a new record there using the date format displayed in the existing records.
Why do you say that?, it can be seen in regional settings?
 

sonic8

AWF VIP
Local time
Today, 15:08
Joined
Oct 27, 2015
Messages
998
Why do you say that?, it can be seen in regional settings?
Well, my fault, I guess it can be safely assumed that the date displayed for "Short date" and "Long date" are the same date. So, you're right.
 

lovBah

New member
Local time
Today, 16:08
Joined
Oct 13, 2021
Messages
11
Might be Ms office issues or windows updates on my PC or other software installed. .Tried to uninstall office and reinstalled. same error..
 

CJ_London

Super Moderator
Staff member
Local time
Today, 14:08
Joined
Feb 19, 2013
Messages
16,553
can you enter anything in the empname column?
can you change the value of an existng record?

wrong error message but just wondering if you have locked the table in some way or have the app in a read only folder
 

Users who are viewing this thread

Top Bottom