Need to change date in field to whatever I want

[judiandlee]

I have a database for my research. I need to change the date, so that I do
not have any restraints on my admissions. I have checked the data field for
date of admission and it looks exactly the same in the data field, but for
some reason, the date will not allow me to move forward with 2010. I am not
sure what to do. Can you please help. This seems to be the only field that
does not change to what I need it to change to. I currently am able to use
the date for 2010. in other date fields except for one field. Please any
suggestions. I am very new in setting or using access.

 

[Larry Linson]

I find your description difficult (no, impossible is the word I should use)
to follow. Could you simplify and clarify? If we can understand what you
have and what you want to accomplish, we'll be in a much better position to
be able to offer useful suggestions.

Fields exist in Tables and in Queries; but I somehow infer that you are
talking about Controls on a Form as "fields", as well, and that complicates
understanding your question. If you are not allowed to type in a date with
the year 2010, then you should check the Validation rules, and the code in
the Before Update event of the Control. If you can type it in but aren't
allowed to save the Record, you should check the Validation rule defined for
that Field in the Table in which it resides, and the code in the Before
Update event of the Form.

Each of these causes should produce a message to the user, but may not if it
is due to user-written validation code in an After Update event. If there
IS an error message, it would certainly be useful if you would quote it
_exactly_.

Larry Linson
Microsoft Office Access MVP

 

[John W. Vinson]

I have a database for my research. I need to change the date, so that I do
not have any restraints on my admissions. I have checked the data field for
date of admission and it looks exactly the same in the data field, but for
some reason, the date will not allow me to move forward with 2010. I am not
sure what to do. Can you please help. This seems to be the only field that
does not change to what I need it to change to. I currently am able to use
the date for 2010. in other date fields except for one field. Please any
suggestions. I am very new in setting or using access.

What's the context? Is this date in a Table (which has Fields)? If so what is
the datatype of the field: Date/Time or Text or something else? Is there
anything in the Validation Rule property of the field?

Or is it on a Form, in which case it's properly speaking not a Field but a
Control on the form? If it is a Form Control, what is the Recordsource
property of the form (view the Form's properties by clicking the little square
at the upper left intersection of the rulers in design view)? What's the
textbox's Control Source? Is there anything in the textbox's Validation Rule
property, or its Beforeupdate event property (on the Events tab)?