Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing a name in a report (MS Access 2007)

    Of a field that is part of a query that serves as recordsource fr one of my reports, i changed the name from klnt_id to klntId. i made the changing in the table where the field belongs as well in the query for the report. However, when i run the report i gat a error message saying that klnt_Id couldn't be find. When i look to the report in designview, i see a border within it the name 'foottext [klnt_ID]",
    I believe that this is the reason why i get the error message, but i can't figure out where or how i can reach this text in order to make the necessary coorection to the name. When i click on this border and go to the property window i see as name "Groupfoottext0", but not "foottext [klnt_ID]". when i run the query separatly, i get no error message

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a name in a report (MS Access 2007)

    Yu need to change the ControlSource property of the textbox.

    You also need to check the Grouping and Sorting dialog box for the changed field name.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a name in a report (MS Access 2007)

    In the report design window have you gone to View/Code in the menubars to see whats in the code if any?

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a name in a report (MS Access 2007)

    The name is probably in your "Group, Sort, and Total area."
    Click on your Design tab and the Group & Sort Button.
    You should see the Group, Sort, and test area at the bottom of your report.

    Click on the kint_ID and change it in the Window box that pops up.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: changing a name in a report (MS Access 2007)

    To avoid these problems it is worth getting a copy of Rick Fisher's Find and Replace . It is not free, but is very reasonably priced. You can download a trial version.

    If you use that to change a field name, you can be confident that all references to it will also be changed.
    Regards
    John



  6. #6
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a name in a report (MS Access 2007)

    Thank you for the help

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: changing a name in a report (MS Access 2007)

    Unless you build column names on the fly.

  8. #8
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: changing a name in a report (MS Access 2007)

    Are you saying that if you build column names on the fly, Find and Replace won't change them?

    Depends on how you build the column names I suppose.
    Regards
    John



Posting Permissions

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