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

That seems wise Dan - I haven't had this issue since Win98 users experienced same problem. And I am absolutely stumped how a PC which has had no changes to the OS or applications can suddenly get errors when I install a new mdb. In other words, last week their previous version of the same mdb gave them no errors with these same functions. Suddenly they start appearing and cause a critical process to fall over.

I think that I will pull out all references to Date() and use of Format() functions - but that's tricky to do today.

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