Mark A Matte
markamatte at hotmail.com
Thu Feb 15 14:32:49 CST 2007
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/