Global find & replace

[John]

Hi

Is there a way to find

OpenRecordset(<whatever is here>)

and replace with

OpenRecordset(<whatever is here>, dbOpenDynaset, [dbSeeChanges])

globally across the app? I have upsized my backend to sql server and need
this changed across a huge application.

Many Thanks

Regards

 

[TedMi]

Try this: Export the VB code to a text file, and edit it in Word, using the
wild-card capabilities, paste back into the VB editor.
-TedMi

 

[Albert D. Kallal]

The built in code editor has a option to search the whole application.

If you talking about code in modules, forms and reports...the standard
search and replace should do the trick....

 

[Klatuu]

Albert is correct assuming all occurances are in modules (standard, class,
form, or report modules); however, here is a link to an inexpensive product I
have been using for about 5 years and I really like it.

 

[Klatuu]

Sorry, forgot to add the link:

http://www.rickworld.com/download.html