Solved

Applying a naming convention to an existing project

Posted on 2011-09-04
3
283 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

785 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