Global find & replace

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
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....
 
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.
 
Back
Top