Ms Access Date input field behaving strangely.

[lovBah]

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

 

[Jon]

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]

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

 

[mike60smart]

Are you able to upload a zipped copy of the Db?

 

[lovBah]

Attached copy. Try and enter date from the form.

 

[Gasman]

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.?

 

[lovBah]

@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.

 

[Gasman]

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.

 

[lovBah]

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..

 

[Gasman]

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]

I tried to enter dates as mm/dd/yyyy.. same error..

 

[mike60smart]

I tried to enter dates as mm/dd/yyyy.. same error..

All dates work just fine on my PC just the same as Gasman.

 

[sonic8]

So your date format os the same as mine (uk)

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.

 

[Gasman]

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]

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]

Might be Ms office issues or windows updates on my PC or other software installed. .Tried to uninstall office and reinstalled. same error..

 

[sonic8]

@lovBah , what about entering the dates directly in the table?

 

[lovBah]

@lovBah , what about entering the dates directly in the table?

Same error..

 

[lovBah]

Same error..

 

[CJ_London]

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