[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-10-13
12
Medium Priority
?
282 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:SFSDIT
  • 8
  • 4
12 Comments
 
LVL 75
ID: 36966201
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
 

Author Comment

by:SFSDIT
ID: 36966239
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
 
LVL 75
ID: 36966246
Look on the Event tab.  And this is the box you are entering a Date in ?

mx
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:SFSDIT
ID: 36966262
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
 
LVL 75
ID: 36966266
Can you upload the db, and state exactly how to reproduce the problem ?

mx
0
 

Author Comment

by:SFSDIT
ID: 36966282
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
 
LVL 75
ID: 36966292
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
 
LVL 75
ID: 36966294
What Year do you want it to be out to ?

mx
0
 
LVL 75
ID: 36966314
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 36966324
See attached db.  I changed it to what I show above.


Apthousing-MX01.zip
0
 

Author Closing Comment

by:SFSDIT
ID: 36966409
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
 
LVL 75
ID: 36966504
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

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question