How do I get the Date picker in Access 2010 to work properly

We have several datasheet forms in Access 2010 application.  There are dates within the datasheet.  We have formatted the date as a short date in the table source.  We have also selected the "for dates" on the field for the form.

When we select a date in the Date Picker, there is not a date captured in the field on the form.
btgtechAsked:
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.

PatHartmanCommented:
So, you're saying that you click on the picker, choose a date, but nothing shows up in the control?  Sounds like the control/record/form is not updateable.

PS "formatted the date as a short date in the table source" - doesn't change the way a date is stored.  It only overrides the windows default setting for how the date is displayed.  Dates are always stored internally as double precision numbers.  The integer is the number of days since Dec 30, 1899 (referred to as the origin date or date 0) and the time is stored as a decimal.  Negative values are dates prior to Dec 30, 1899.  Positive values are after that date.
0
btgtechAuthor Commented:
When we click on the picker, and select a date, the date does not show up in the field on the datasheet.

1. we have confirmed that the Form and field are enabled
2. we have confirmed that the form and field allow data entry and allow edits.

what else can we check?
0
btgtechAuthor Commented:
We are able to manually type a date into the field.
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.

PatHartmanCommented:
Try deleting the control.  Save and compact the database.  Then re add the control.
0
btgtechAuthor Commented:
This occurs on all of the forms which have date fields.

So I need to delete all of the date fields on all forms, compact and repair and then add all of the date fields back into the forms?
0
btgtechAuthor Commented:
The end users are also running this app using Access Runtime 2010.  Is there anythign we should consider related to the date entry when using Runtime?
0
PatHartmanCommented:
No.  If it happens in multiple places it is unlikely to be corruption.  Does the problem only happen when using the runtime?
0
btgtechAuthor Commented:
No - It is happening in the version on my computer as well
0
btgtechAuthor Commented:
but only in one access application
0
PatHartmanCommented:
Now we're back to suspecting corruption but of a more generalized nature.  If the Date Picker wasn't working for any application, I would suggest reinstalling Office but since the situation is restricted to a single database and the problem occurs on multiple computers, the problem is with that specific database.

Start with compact/repair.  Then do a /decompile.   If it still doesn't work, create a new empty database and import all the objects into it.  Don't forget to set your references and startup properties.

If a complete copy doesn't solve the problem, the corruption goes deeper and you'll need to find the corrupted object.  Most likely it is a form since those are the things we change over and over again although I've had queries corrupt on me.  To ferret out a bad form is time consuming.  Start with an empty database again and import everything except the forms.  Then import one form at a time and test.
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
btgtechAuthor Commented:
Does it make any difference that I have the table in a Backend database and the queries, forms and reports in a Front End Database?
0
PatHartmanCommented:
No.  That is the correct setup.  Usually it is the FE that is corrupted anyway.
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.