How do I add more years to the year range in Access

Our HR guy is trying to update our Housing form.  ie.  a new couch was placed in an apartment last year 2011 but when he changes that field a message pops up that you need to enter a value 4-digit year between 1980 and 2010.  

How do extend the date beyond the 1980 and 2010 range? year error view layout
SFSDITDirector of ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Sounds like some validation is being done in the Before Update event  or the Validation Property of the control of that date text box.  Which text box is causing this error?  Check the Before Update event and/or the Validation Property ...

mx
0
SFSDITDirector of ITAuthor Commented:
Both look clear, no entry.  I'm not an Access guru by any means but this should be possible.  I've added screenshots of the properties for one of the problem fields.

 designview format data event other
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Look on the Event tab.  And this is the box you are entering a Date in ?

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

SFSDITDirector of ITAuthor Commented:
Sorry no, I am trying to change it directly from the form.  I can change it to any year but nothing greater than 2010.  Below is a screenshot of the page that I can change it on.  I click and edit that year. change view
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Can you upload the db, and state exactly how to reproduce the problem ?

mx
0
SFSDITDirector of ITAuthor Commented:
DB uploaded.

Press Select Apartment to View/Edit data.

Search for an apartment G44.

Click on any field that has a year of 2010 and change it to 2011 and you 'll get the message.


Apthousing.mdb
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Just as I suspected ... Validation Rule, but it's in the Housing - General table ... see image.

Adjust those to your liking ...

mx
Capture1.gif
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
What Year do you want it to be out to ?

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
How about this:

Validation Rule:  0 Or (Between 1980 And Year(Date()))

Validation Text: Please enter a 4-digit year between 1980 and the current Year.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
See attached db.  I changed it to what I show above.


Apthousing-MX01.zip
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SFSDITDirector of ITAuthor Commented:
Thank you so much.  I'll glance through your screenshots closer to see if I can follow what you did.

Have a good one.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You are welcome.  The changes were easy, using the best ever Find & Replace:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

get it!

mx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.