• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

Access 2010 date() no longer supported - how to change 100's of references to Date()

What in the world was MS thinking to drop support for MSCAL.ocx?

I have a HUGE database app that can't always use the referenced "Show Date Picker" workaround: (see link: http://office.microsoft.com/en-us/access/HA102835451033.aspx).

IOW, I have date() functions that don't require/need the "Show Date Picker" user interface.
MS removed Date() completely.

Anyone know of a workaround to replace the Date() function in a Access 2010 database app?
0
RomChi
Asked:
RomChi
  • 3
  • 3
  • 2
  • +2
1 Solution
 
OP_ZaharinCommented:
- Microsoft provides 3 options for replacing MSCAL:
1- built-in DatePicker
2- Windows DatePicker control
3- use a subform that looks and functions like a calendar
OR
- third party control

- the following link provides example of using the 3 options, should any of these matches your requirement:

http://msdn.microsoft.com/en-us/library/gg251104.aspx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  Not sure what your referring to. Date() is certainly still part of VBA and should work fine.  If it doesn't, then you have broken references in your VBA project.

JimD.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
And Microsoft has LONG advised you to NOT use ActiveX controls that are not supported in Access (which is the majority of them, even those produced my Microsoft). That you chose to use them is your choice, of course, but you must live with the consequences.
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.

 
RomChiAuthor Commented:
Well, I'll supply the right answer myself. :)

In reality... all you have to do is enter vba.date() or for that matter vba. all references that are broken with MS's insidious decision to not be backwards complatible.

So, I did numerous search and replace on thousands of entries. Just enter vba. preceding all those references and voila. It worked.
0
 
RomChiAuthor Commented:
No objections.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
So did you have a missing reference? Is that what you're saying?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Maybe not a broken reference, but an ambiguious one.   Must have two libs referenced with a Date() function. Certainly not the fault of Access/VBA.

JimD.
0
 
GRayLCommented:
OK, I'm tired of waiting - which one is the genius?  Are we allowed to guess?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I am ... no, Jim is ... no YOU are ... oh what the heck - we can ALL be geniuses!!! Crackers and cheese for everybody!!!
0
 
RomChiAuthor Commented:
The guy is a genius
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now