Re: Form for report parameters

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Wed, 7 Mar 2007 13:03:18 -0800, CMTH wrote:

I found the problem!
In the Paramform under OTHER for the two unbound text controls, the name was
set to txtStartDate and txtEndDate instead of simply StartDate and EndDate.

Thanks for your help and patience!!!

"CMTH" wrote:

* snipped *

In looking over your query SQL I notice you have a field named "Date".

Date is a reserved Access/VBA/Jet word and should not be used as a
field name. I would suggest you change it to something else, perhaps
"dteDate" or "ProductionDate".
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Filling textboxes using the value from a combobox
    ... > Sorry if this is a really stupid question but I am completly new to access ... In the Combo Box, use a Prime Key field, LastName field, FirstName ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.forms)
  • Re: Creating a "Days since" field
    ... > I get reports from other companies, ... 'Reserved Words in Microsoft Access' ... in the control source of an unbopund control on your form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Newbie DLookUp
    ... > I am trying to set up a DLookUp in Access 2000. ... any field or table used in it's control source expression. ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.gettingstarted)
  • Re: Parsing Question
    ... I've parsed out everything following the comma to begin my attempt at ... show commas only after the Last Name, and a space separating the First ... For additional reserved words, ... Reserved Words in Microsoft Access' ...
    (comp.databases.ms-access)
  • Re: Help with Option Explicit
    ... "fredg" wrote: ... Well my field name in the combo has changed to dDate. ... For additional reserved words, ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.formscoding)