Solved

Access 2010 Date Picker Error

Posted on 2011-03-10
5
683 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

910 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

24 Experts available now in Live!

Get 1:1 Help Now