Solved

Applying a naming convention to an existing project

Posted on 2011-09-04
3
282 Views
Last Modified: 2012-05-12
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
Comment
Question by:callstate
3 Comments
 
LVL 6

Expert Comment

by:TinTombStone
ID: 36481463
Try: Edit, Replace

It will allow you to find and replace within the current procedure, module or project
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 36481508
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 36481574
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Office 2016 User Guides 5 33
Vlookup nonexact IP address match 32 54
Importing and Dropping Table in Access 11 25
Search Form not Querying 2 12
My experience with Windows 10 over a one year period and suggestions for smooth operation
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now