Renaming ALL Queries/Macros/Forms in less steps..

[Guest]

I’m consolidating 5 working dbs into 1 main db and I’d like rename all
queries/macros/forms to match each databases functional names. For example:

1.AP Database
All objects will have *AP-(plus current object name)
i.e. qAP-XXXXXX for queries
fAP-XXXXXX for forms
mAP-XXXXXX for macros
etc…

2.Color Database
All objects will have *CLR-(plus current object name)
i.e. qCLR-XXXXXX for queries
fCLR-XXXXXX for forms
mCLR-XXXXXX for macros
etc….

I have a minimal knowledge of VB, with that said, is this task possible
using queries?

Will appreciate any help I can get.

Thanks in advance

Rob

 

[Douglas J. Steele]

You're probably best off looking at a 3rd party tool to help you, rather
than trying to write something yourself.

Take a look at
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/