[AccessD] Date

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 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Charlotte Foust
> Sent: 04 February 2004 18:13
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Date
> 
> 
> Yes, it does make a difference.  If you aren't using the Word 
> library, uncheck it on his machine, otherwise, reset it on 
> his machine.  If you have a reference to Word 8, that 
> reference may not resolve properly on a machine without the 
> Word 8 library.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
> Sent: Wednesday, February 04, 2004 10:00 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Date
> 
> 
> i checked on of the problematic ppl's references right now
> me and him have all the same exsept I have Word 8.0 Object 
> Library and he has 9.0 donn't think it makes any difference
> 
> > Check for broken references on their machines.  Date() is one of the
> > built-in functions that breaks when a reference is flaky.
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> > Sent: Wednesday, February 04, 2004 9:08 AM
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] Date
> >
> >
> > =Date()
> >
> > if i put that on report (or formatted)=Format(Date(),"mmmm dd"",
> > ""yyyy") it opens fine on my machine and on several others. 
> There are
> > however couple of ppl who have both Access 97 and 2000 on their 
> > machines, they get errors at this part. All the other references to 
> > tables and forms works fine. What could be the problem ?
> >
> >
> > -----------------------------------------
> > 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
> 
> 
> 
> -----------------------------------------
> 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
> 
>