[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