Access 2010 Date Picker Error

Hi Experts,

We have an old Access database in 2000 format which we'd like to convert into accdb format. After the conversion everything works except for the date picker when user running reports. The date picker will show up as #Error in the field and won't even allow any input. I know it's probably gonna require to update some old objects which no longer works in 2010 but I don't know how.

Any help is appreciated.

Thanks!
AccessErr.png
lo_oscarAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I believe the old date picker is not supported. However, there is a new built in date picker that can be enabled (is by default) for text boxes ... and will show automatically if that control has a date or is bound to a DateTime data type Field.

mx
0
 
lo_oscarAuthor Commented:
Hi,

I'm not very familiar with 2010, is it possible for you to guide me through what and where i should go and make changes? Thank you!
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
I don't see any "#Error" in your sceenshot?

I have a Calendar control in a form in an Access 2010 formatted DB and it works (inserts date into a bound date field) just fine...
On the After Update event of the Calendar, I do this:
    Private Sub Calendar4_AfterUpdate()
        Me.OrderDate = Me.Calendar4
    End Sub


How exactly are you using this control in conjunction with the field?
Remember, you did not post any code or state the design of your form...

JeffCoachman
untitled.JPG
0
 
lo_oscarAuthor Commented:
Thank you guys. I figured it out. I'll reward the point equally to both of you.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Just so we are clear, ...what was the solution?

Remember, you don't have to award points if a post does not directly solve your problem.
0
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.

All Courses

From novice to tech pro — start learning today.