Solved

Access 2010 Date Picker Error

Posted on 2011-03-10
5
680 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:lo_oscar
  • 2
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 35102315
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
 

Author Comment

by:lo_oscar
ID: 35102551
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
ID: 35111864
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
 

Author Closing Comment

by:lo_oscar
ID: 35111915
Thank you guys. I figured it out. I'll reward the point equally to both of you.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35112472
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

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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 …

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now