• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • 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)PresidentCommented:

  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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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)PresidentCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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