[AccessD] Date

The trouble is that the breakage of the date function signals other
problems, so just finding a workaround for it isn't enough.  Why would a
secretary need a reference to Word 9 in your Access application if the
application works without it?  Anytime you build an app that uses a
specific version of another application library, you must take the
necessary steps to insure that it doesn't break on another machine.

Charlotte Foust

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Wednesday, February 04, 2004 3:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Date


nee, I know that one.
it worked fine after i took of reference to MS Word 9 on 2 ppl machines,
but i can't do it for everybody, caz one of the secretaries needs it for
something. I dunno why Format(date) worked on some machines but not
others, i just wrote function myself that reformats it from 2/2/04 (or
with leading zeros) February 2, 2004.

>
>
>
>
> You betcha! and how many times have we all fell for that one :-)
>
> In fact, there are several intrinsic functions that cause the same 
> problem.
>
> BBB
>
>
>
>
>
> Another problem is calling a field on a table Date. Causes mayhem when

> you use the Date function.
>
> Andy Lacey
> http://www.minstersystems.co.uk
>
> <Snipo!>
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com