View VB Coding for Entire Database?

[Guest]

Is it possible to view the entier VB coding for the entire database in one
screen, so you can use the find & replace tool to replace certain text
throughout the whole database? As if you need to update your naming scheme
and take the spaces out, etc.... VB that includes Tables, queries, reports,
etc.

Thanks
Curtis

 

[Guest]

There is usually too much code to see all on one screen at the same time.
However, if you do use Find (or Find and Replace) you can select Current
Project on the Find dialog. It will look in ALL modules within the entire
database. If you need to close the find dialog to change some code, just use
F3 to find the next instance. I do that sort of thing all the time.

jmonty

 

[Guest]

But you still have to redo your queries and update every field in your forms
as it wont update those right? I tested it & it didn't.

 

[Douglas J. Steele]

Take a look at 3rd party products such as:

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/