Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Applying a naming convention to an existing project

In an effort to 'clean up' my code and forms, I would like to apply a naming convention to all objects in the current project, renaming existing controls, forms, tables, querys, code modules, and subroutines and functions.

Is there a 'simple' way for doing this that will catch ALL references.  For instance, if I rename a form from Form1 to frmMainForm, and there is code or macros referencing the Form1 name, how can I be sure that all references are changed?
0
callstate
Asked:
callstate
2 Solutions
 
TinTombStoneCommented:
Try: Edit, Replace

It will allow you to find and replace within the current procedure, module or project
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Find and replace from Rick Fisher:


Www.rickworld.com


Well worth the money.    There is also across ref utility that let's you find all un-used objects


Jim
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Just an additional word on Rick Fisher's Find & Replace.  Specifically, you want:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

and I guarantee you F&R will find ALL references in ANY object, including queries where a Form may be referenced, etc.

And yest ... this is the 'simple' way.  
"how can I be sure that all references are changed?"
Because this product works.  I use it daily.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now