Re: Date Function not working

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks, I'll bet that's it. Inherited these databases so I will check
when I get back in the office tomorrow.


On Thu, 26 May 2005 23:27:39 -0400, "Ken Snell [MVP]"
<kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote:

>Just guessing at the moment, but my guess is that you have a field or
>control named Date on the form. ACCESS is probably assuming that you mean
>the control or field, not the function.
>
>Do not use Date, Name, etc. as the name of a table's or query's field. They
>and many other words are reserved words in ACCESS, and can create serious
>confusion for ACCESS and Jet. See these Knowledge Base articles for more
>information:
>
> List of reserved words in Access 2002 and Access 2003
>http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
>
> List of Microsoft Jet 4.0 reserved words
>http://support.microsoft.com/?id=321266
>
> Special characters that you must avoid when you work with Access
>databases
>http://support.microsoft.com/?id=826763

.

Quantcast