Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Field Names Throughout Database (97/2000)

    Because I learned Access on my own while building a database, I now find that I have a few inappropriate field names (for example "E-mail" instead of "EMail" which forces me to use brackets in code because of the hyphen). By now, of course, that field name is embedded in numerous queries, forms, reports, and code modules.

    My question is, is there any easy way to locate all the incidences of such a field and change them? I don't mind changing them manually once I find them if necessary - it's finding them that is the issue so I don't miss one (or twelve <img src=/S/smile.gif border=0 alt=smile width=15 height=15> ) and have something malfunction when someone else is using the database.

    thanks,
    -cynthia

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Field Names Throughout Database (97/2000)

    See <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=81047&page=& view=&sb=&o=&vc=1#Post81047>this thread</A>
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Field Names Throughout Database (97/2000)

    Thank you. That is what I suspected.
    Since I seem to have only two such fields, I guess I'll leave well enough alone <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    -cynthia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •