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

I remember this happening back then too - with Win98 users - but I have never seen it with Win 2K pro or WinXP Pro. Back then I remember it was the MDAC version - but now - who knows. 

Kath
  ----- Original Message ----- 
  From: Jim Lawrence (AccessD) 
  To: Access Developers discussion and problem solving 
  Sent: Monday, November 08, 2004 11:37 AM
  Subject: RE: [AccessD] Date() not working - MDAC issue or not?


  Hi Kath:

  This problem you are having sounds like a very old problem, about four to
  five years ago, that I had on a site that had just been upgraded to A2K.
  Neither the Date(), Format() etc., commands would work. The solution turned
  out to be a simple update from MS. The problem only happened with upgrades
  and not with full installs.

  HTH
  Jim

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath Pelletti
  Sent: Sunday, November 07, 2004 3:50 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Date() not working - MDAC issue or not?


  Charlotte - no - no ref to mde - thanks anyway

  Kath
    ----- Original Message -----
    From: Charlotte Foust
    To: Access Developers discussion and problem solving
    Sent: Saturday, November 06, 2004 3:14 AM
    Subject: RE: [AccessD] Date() not working - MDAC issue or not?


    Are you referencing an MDE at all?  We found that we had similar
    problems with an app when the code library we were referencing was in
    the application folder, since the user is allowed to determine the app
    folder at installation.  Even though the reference appeared to be
    resolved, it required unsetting it and then resetting it before things
    got back to normal.  We solved the problem by putting the mde in the
    runtime folder, which we install to a fixed location.  After that, we
    stopped having that particular problem.

    Charlotte Foust


    -----Original Message-----
    From: Kath Pelletti [mailto:KP at sdsonline.net]
    Sent: Thursday, November 04, 2004 7:27 PM
    To: Access Developers discussion and problem solving
    Subject: Re: [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
    --
    _______________________________________________
    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
  --
  _______________________________________________
  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