[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