[AccessD] Date() Problem

Jim Lawrence accessd at shaw.ca
Thu Feb 15 17:51:54 CST 2007


Hi Mark:

Have all the appropriate patches been applied to the computer you are trying
to migrate your application to? Make sure the destination system has all the
current patches.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, February 15, 2007 12:33 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Date() Problem

Gustav,

First thing I checked for...on my machine I have:

Visual Basic For Applications
MS Access 8.0 Object Library
MS DAO 3.6 object Library

...and the same on this machine??? <<<I went verify before hitting send>>>

It was the same...so I removed the DAO...and added it back(just to 
see)...and now it works...Thanks???

I give up...nothing is making sense today...

Thanks again,

Mark A. Matte


>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Date() Problem
>Date: Thu, 15 Feb 2007 20:59:28 +0100
>
>Hi Mark
>
>That is because you have a missing reference on that machine.
>
>/gustav
>
> >>> markamatte at hotmail.com 15-02-2007 20:52:35 >>>
>Hello All,
>
>I have had a nightmare with dates lately.  I have a query that runs using
>Date() as criteria because I only want stuff for current date.  I was using
>Format()...but will change to FIX() after the last thread...the problem is
>on 1 machine neither works with Date() as criteria.  Just on this 1
>machine(that I know of) when I try to run the query I get the error:
>
>"Function isn't available in expressions in query expression '
>(((Fix([dt]))=Date()))'."
>
>If I switch Date() to an actual date #1/24/07# it runs fine.  I even tried
>FIX(Now())...and this worked...apparently this machine does not like
>Date()???
>
>Any ideas/suggestions?  I need to know if I'm using  Date() the wrong
>way(kinda like FORMAT) or is this something unique to this 1 machine?
>
>Thanks Again,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Dont miss your chance to WIN 10 hours of private jet travel from Microsoft 
Office Live http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/





More information about the AccessD mailing list