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