[AccessD] Date

John W. Colby jwcolby at colbyconsulting.com
Wed Feb 4 19:30:33 CST 2004


Charlotte,

What is the answer to this?  It isn't so much "a reference to a specific
version" as it is "a reference to a lib" and that lib unfortunately includes
a "version".  I have this problem myself.  I use outlook and word both, one
of which requires an actual reference to an OLB.  That OLB is a specific
file in a specific location.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Wednesday, February 04, 2004 7:12 PM
To: Access Developers discussion and problem solving
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list