Checking tables and column names using VBA

[RLN]

Re: Access 2003

I inherited an Access app (developed by an end user long ago) with objects
having no centralized uniform naming conventions. Some of these objects have
spaces, some have dashes, some even have slashes across various table names,
controls on forms, VBA variables in code, queries, modules, reports, etc.

The classic one here was an object named "rptPrint-AllRows".
After checking all of the "rpt" objects in the app and never having found
the problem, I finally discovered this object was really a query, and not a
report at all.
(I renamed this one to "qryPrintAll")

For the most part, the application itself is somewhat stable after I fixed a
few minor bugs, but I can forsee many problems down the road when trying to
debug bigger problems (or add enhancements) in the future.

Is there a way (via VBA) to rename every occurrence of a table, column,
form control, query, report, macro or module from "ItemNamedX" to
"ItemNamedY", regardless of where the object is found in the application?

My IT dept is tight on the purse strings or else I would have bought
"SpeedFerret" by Black Moshannon Systems yesterday. This is why I am
looking for a way in VBA to be able to do this.

thank you.

 

[John Spencer]

Find And Replace from Rick Fisher has a 30-day Shareware Trial. It works
pretty well and you can get a full-fledged copy for less than $50.
Considering the cost of your time to develop something that is even remotely
similar - $50 is a bargain.

Products to document the database and do a global find and replace. All
have Access 97 and later versions. Some don't have an Access 2003 version,
but may still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[RLN]

John,
I downloaded the utility from Rick Fischer, so I'll be using it.
Thank you for your response. This was very helpful. I appreciate it.

 

[Visitbazaar Info]

Visitbazaar.com is a secure online shopping mall where you can shop over 200
stores and save up to 60% and more with coupons, deals and discounts. Since
October of 2007, we have helped many customers save money on products &
services ranging from arts and crafts to web services. At Visitbazaar.com,
we are strongly committed to keeping our online mall a safe place to shop
at, and to help our customers save money on a wide selection of products &
services.

My Window is a browser application which increases the internet browsing
speed by applying various compression techniques and protocol optimization.
Reduces the upload and download time in FTP. To switch on MyWindow feature,
log on Visitbazaar.com now.

http://www.visitbazaar.com/mywindow.html


Regards
Visitbazaar Info