Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    A VB question? (97)

    I have spent several days creating over 100 pareto charts and histograms. The good news is they look great and work as expected (almost).

    The "almost" is that the user enters a "minimum" dollar amount on a form, and that amount is used as one of the parameters in the queries driving the reports/charts. One of my users found a glaring error. If they enter "500", it starts at 501 instead of 500. I need to edit everyone of these charts and change ">" to ">=".

    Is there a way to globally change all the code/select criteria at one time?

    Any ideas are greatly appreciated!

    Thanks,
    Ken

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A VB question? (97)

    You could write your own search and replace utility, but it would be a lot of work to cover everything. There are several add-ins that can search through database objects, for example Find and Replace from Rick Fisher, and SPEED Ferret from Black Moshannon Systems. Both offer free trial downloads (with some of the functionality disabled).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •