DateYear

[Ge0rge]

I am not very proficient in access so this question may be be simple dont know. I have a data base called 2020 I have similar ones 2016,2017 2018 2019 . eachyear i just use the next year. well I dont have a 2021, so i renamed 2020. the data base is blank no entries. Problem is when I try to write a cheque for instance it auto shows tear as 2020. I don't know where this YearDate is.... any help?

[ranman256]

it could be a function in code, or a query.
you have to trace where the value is coming from.

normally, one would use Year(date()) function to get the current year. But if it's not getting 2021, then you must search.

[Micron]

So what did you do over the last few years when you got it to work? Do the same?

[JoeM]

If you cannot figure out where it is, you can strip away any sensitive data and upload a copy of your database for analysis.

By the way, you should not need to create a new database for each year. You don't even need to create a new table for each year.
You should be able to continue to use the same database year-after-year. If the data table starts to get too large, you can just archive off some of the old data.