2003 Date Functions Don't Work in Access 2010 (1 Viewer)

[C.F.]

How do I get my date functions -- created in Access 2003 -- to work in Access 2010? (I sense this is a common problem.)

 

[plog]

If its common, did you google the functions in question and get your issue resolved?

If not, what in particular are you having trouble with?

 

[C.F.]

Thanks for the feedback, Plog.
1. Yes, I have Googled, and recently found a site that may hold promise...
http://msdn.microsoft.com/en-us/library/gg251104.aspx .
2. The particular trouble is the following error message when opening Access 2003 database with date functions in Access 2010...
"Your [XYZ] database or project contains a missing or broken reference to the file'MSCAL.OCX' version 7.0. ..."

Plog, any good suggestions?

 

[boblarson]

The calendar 11.0 control (MSCALOCX) is no longer in Access (beginning with Access 2010). You need to remove that calendar from any forms that use it and replace it with something else. I prefer to use a NON-ACTIVEX solution (there are some in our Database Samples forum category).

 

[Pat Hartman]

A2007 and A2010 have a built in date picker. Any control that is bound to a field with a date data type or any unbound field that is formatted as a date will show a picker button next to it when the control receives the focus. You should be able to simply delete the activeX controls you are using and replace them witn standard bound textbox controls.