Re: Why wont this statement work

In your table use 'srtName' for the field name ('str' is a memory jogger
which will tell you at a glance that the field contains string data) ... by
using a filed naming convention like this you overcome forever the danger
that you'll use a word reserved by Access/VB/JET ... Cheers ...

"fredg" wrote:

> On 28 Jul 2005 20:27:28 -0700, dgrdinh@xxxxxxxxx wrote:
>
> > Hello, building reports in access for the first time. I'm putting
> > expressions into Text Boxes but get odd results. I have a field in a
> > table for a name of a person, its called "NAME".
> >
> > when I put
> >
> > NAME
> >
> > into the textbox I get the persons name: Andy
> >
> > when I put
> >
> > ="Hi There " + [NAME]
> >
> > I want "Hi There Andy" but get "Hi There Reports By Class",
> >
> > where Reports by Class is the name of my report. Why is it sometimes
> > getting the "name" property from the table in some cases and the "name"
> > of the report in others? whats the rule? How do I specify to use the
> > "name" of the table and not the "name" of the report?
>
> Name is a reserved Access/VBA/Jet word and should not be used as a
> field name.
> 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'
>
> After you change the [Name] field to something else,
> ="Hi there " & [AField]
> will work. Make sure the name of the control is not "AField"
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.
>
.

Relevant Pages

  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: Images in VBA application
    ... If you are printing the images in reports, to avoid memory leakage, you ... the Access formatting process prior to being spooled to the Printer Driver. ... Memory" error that can popup when printing image intensive reports. ... Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can I attach several reports to one email message?
    ... I have no idea what tables would look like when sent as attachments ... Then I'd suggest explicitly creating PDF files from the reports. ... Alternatively see Creating PDF files from within Microsoft Access ...
    (microsoft.public.access.reports)
  • Re: Propagating Field Name Changes
    ... Joan Wild ... Microsoft Access MVP ... > list with LASTNAME as the control name. ... >>>However, forms, reports, and modules do not. ...
    (microsoft.public.access.tablesdbdesign)
  • Microsoft Access Importing Data
    ... I am using a software package that exports into Microsoft Access ... ID First name Last Name City Charges ... all the data and one mistake could make reports worthless. ...
    (microsoft.public.access.gettingstarted)