John Colby
jwcolby at ColbyConsulting.com
Wed Mar 1 10:26:26 CST 2006
Exactly. If you are changing table names you already have to search and replace in forms, reports, queries, code etc. Find&Replace ! John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Wednesday, March 01, 2006 10:24 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Assistance Isn't that what Rick Fisher's Find and Replace is for? Actually has this kind of happen this week. Had to merge one table into another. So I had to change my fldBV prefix to fldBundle everywhere - tables, queries, forms, code, etc. Great program. It found them all. Rocky Gustav Brock wrote: > Hi Rocky > > Until you rename the table. Great time for fun! > > /gustav > > >>>> bchacc at san.rr.com 01-03-2006 15:54 >>> >>>> > You forgot the fld prefix! I now also put the name of the table into > each field name. so each field in tblCustomer, for example, begins > with fldCustomer. More self documenting. You can always see what > table a field comes from. > > Rocky > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com