Re: Comma in query expression

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

Thanks to both of you. I actually came across a problem where I used the Name
word as feild name in another data base and learned that it is a reserved
word after encountering errors. I should have known better when using it
again in this databse.


fredg wrote:
You need to include text delimiters in the DCount statement if you are going
to use a text string.
[quoted text clipped - 9 lines]
OR
DCount("*","Main","[Name]= " & Chr(34) & Me.Recipient & Chr(34) )

In addition to what John has written, Name is a reserved
Access/VBA/Jet word and should not be used as a
field name.
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200709/1

.

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)