From: Tomahawk Lady on 27 Jul 2010 10:08 In Access 2002 and 03, when you changed a name in a table, the change automatically propogated to all queries, forms and reports. That doesn't seem to happen in 2007. Am I missing something or did 2007 really lose this capability? Will the capability return in Access 2010?
From: Douglas J. Steele on 27 Jul 2010 10:24 Click on the Office button (large circle in the upper left-hand corner), then select Access Options from the bottom of the form that appears. Click on the Current Database tab, and scroll down until you see the Name AutoCorrect Options section almost at the bottom. Ensure that Perform name AutoCorrect is checked. Note, though, that most of us recommend not using the so-called "AutoCorrupt" feature (jsut as we did for Access 2002 and 2003)! See what Allen Browne has at http://www.allenbrowne.com/bug-03.html for some of the reasons why. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele Co-author: Access 2010 Solutions, published by Wiley (no e-mails, please!) "Tomahawk Lady" <nancycmarshall(a)verizon.net> wrote in message news:3da175cd-c218-420f-9ace-93635fb79046(a)b5g2000vbl.googlegroups.com... > In Access 2002 and 03, when you changed a name in a table, the change > automatically propogated to all queries, forms and reports. That > doesn't seem to happen in 2007. Am I missing something or did 2007 > really lose this capability? Will the capability return in Access > 2010?
From: David W. Fenton on 27 Jul 2010 20:05 "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in news:i2mq69$15v$1(a)news.eternal-september.org: > Note, though, that most of us recommend not using the so-called > "AutoCorrupt" feature (jsut as we did for Access 2002 and 2003)! > See what Allen Browne has at > http://www.allenbrowne.com/bug-03.html for some of the reasons > why. I actually use it strategically -- I have it off by default, but when I know I need to do a renaming that has ramifications through multiple objects, and it's the type of thing that Name AutoCorrect can actually propagate, I turn it on, let it build the dependencies table, make the change, let it propagate the change, then turn if off again. I've found this works just fine. -- David W. Fenton http://www.dfenton.com/ contact via website only http://www.dfenton.com/DFA/
|
Pages: 1 Prev: Date Issue Next: User-Level Security -- <New Tables/Queries> |