Jim Dettman
jimdettman at verizon.net
Thu Mar 5 12:47:50 CST 2009
Keith (and all), An over looked feature in F&R is the cross reference utility. Often one asks "What in my app is un-referenced?" You can do this in F&R. From the main dialog, click the "Cross-Ref" button in the lower right. Then in the report style area (#2 lower right), check "Only list unreferenced items". This is a feature that is only found in some higher end tools and is often over looked in F&R. FWIW, Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Thursday, March 05, 2009 12:16 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Changing Table Names Too Cool, guys! Thanks. Don't know how I got along with out this! Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD 21231 410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Thursday, March 05, 2009 12:04 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Changing Table Names Keith, I usually use Rick Fishers Find and replace to do that type of thing.. HTTP://www.rickworld.com HTH Bill ----- Original Message ----- From: "Keith Williamson" <Kwilliamson at RTKL.com> To: <accessd at databaseadvisors.com> Sent: Thursday, March 05, 2009 8:49 AM Subject: [AccessD] Changing Table Names Hey guys....does anyone have a utility for changing the name of a table (or query), and have the change pass on to all dependent queries/forms/reports? Thanks, Keith Williamson | Associate, Asst. Controller | kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond St. | Baltimore, MD 21231 410.537.6098 Direct | 410.276.4232 Fax | www.rtkl.com <blocked::http://www.rtkl.com/> ------------------------------------------------------------------------ -------- The information contained in this communication is confidential, may be privileged and is intended for the exclusive use of the above named addressee(s). If you are not the intended recipient(s), you are expressly prohibited from copying, distributing, disseminating, or in any other way using any of the information contained within this communication. If you have received this communication in error, please contact the sender by telephone at (410) 537-6000 or by response via e-mail and permanently delete the original email and any copies. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com