[AccessD] Date() not working - MDAC issue or not?

For now I have got client back online - I was able to remote access the PC, remove the references to DAO and ADO, save, reopen the refs window, select the DAO and ADO again (in that order) and recompile. That seems to have the date() function back for them again. Strangely though, there are still a few errors with format().

Kath
  ----- Original Message ----- 
  From: Dan Waters 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, November 05, 2004 11:13 AM
  Subject: RE: [AccessD] Date() not working - MDAC issue or not?


  Kath,

  A few years ago I noticed this problem on a few computers, and it was a
  sporadic problem.  To get around it I put the following in a standard
  module:

  Public Function CurrentDate() As Date

      CurrentDate = CDate(DatePart("m", Now()) & "/" & DatePart("d", Now()) _
  & "/" & DatePart("yyyy", Now()))

      Exit Function

  End Function

  Now whenever I need the current date I just write:  txtDate = CurrentDate

  No problems for several years now!

  Dan Waters
  ProMation Systems

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Thursday, November 04, 2004 4:23 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Date() not working - MDAC issue or not?

  Hoping someone can shed some light here....

  A client using Windows 2000 Pro and Access 2000 has been using an mdb
  written in Access 2000 for several years. But this week when I installed an
  upgrade (same platform), the Date() functions throw errors, as do the
  Format() functions.

  They have a critical error at the moment caused by Date() notworking which I
  need to fix today. I know I could modify these functions to use, eg. Now(),
  but is this a MDAC problem? Mine is MDAC 2.7 on Windows XP SP1. 

  If I asked my client to download MDAC 2.8 (which I see is the latest) - is
  this going to solve the problem?

  I do not understand how this upgrade could possible have afftected the use
  of these functions??

  Thanks

  Kath
  --
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com