none
Searching for Character Strings in Access Objects RRS feed

  • Question

  • Hello:

    To search an Access application for instances of the same string in Modules, Forms and Reports, I was recommended to use Rick Fisher's "Find and Replace".

    I went to the website (not well constructed) and it provided little information on installation.  Then it recommended using the obsolete help files (.hlp) for instructions, and even included links to a Microsoft website to download the software to allow reading these obsolete files.  Of course, the links were broken and removed by Microsoft.

    If I were running a business, I would not make it so difficult to purchase a product.  All my attempts to locate a .hlp reader or converter were useless. Why would a business owner make it so difficult!!!

    All Rick needed to do was provide a PDF file.  I don't understand his business model.

    Anyway, any ideas on how to install and use?

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Friday, February 14, 2020 8:16 PM

Answers

  • The installation file repl9.exe is a self-extracting zip file that contains - among other files - a PDF file with instructions. They basically are:

    Close any open Access sessions.
    Start Access
    Open the replace9.mde file. A form should open that has an Install button. Click this and it should
    install.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by RichLocus Friday, February 14, 2020 9:20 PM
    Friday, February 14, 2020 8:43 PM

All replies

  • The installation file repl9.exe is a self-extracting zip file that contains - among other files - a PDF file with instructions. They basically are:

    Close any open Access sessions.
    Start Access
    Open the replace9.mde file. A form should open that has an Install button. Click this and it should
    install.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by RichLocus Friday, February 14, 2020 9:20 PM
    Friday, February 14, 2020 8:43 PM
  • Hans:

    Thanks again for a straightforward answer that works! I had reach the point of frustration... which I normally don't :)

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Friday, February 14, 2020 9:21 PM
  • Rick has disappeared (will over a year now).  So it is impossible to get licenses or support.

    You may like to review

    https://www.devhut.net/2020/02/13/access-new-find-and-replace-for-developers/


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Friday, February 14, 2020 11:26 PM
  • David:

    Looks good.  I downloaded it and purchased a license.  There were two files:

    FindAndReplace_ADT_1014

    KeyData

    Where are the install instructions? I looked all over the website where I purchased it but there were no instructions anywhere to be found.

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com


    • Edited by RichLocus Saturday, February 15, 2020 6:08 AM
    Saturday, February 15, 2020 5:50 AM
  • David:

    I downloaded the product and the key, and on a Office 365 *32 bit) I ran the msi that came with the product.  Then I opened Access and there were no new tabs.

    I tried it again with Access open and still nothing.

    What am I missing?

    P.S. There were no install instructions.

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Saturday, February 15, 2020 8:09 PM
  • With these add-on products, I don't believe there is going to be a new tab. They are generally placed as one of the options within a tab. Look in each of the tabs for new options.
    Saturday, February 15, 2020 8:42 PM
  • What am I missing?

    Hi Rich,

    This must be frustrating! In the meantime you could have written your own "Find and Replace" utility based on the simpler version of Hans in the other thread. But I don't know your program capabilities.

    I have build my own "Find (and very seldom Replace)" utility, that can analyse all my (100+) applications at a very detailed level. My applications all are linked to a general library database, that takes care of alomost 98% of all functionality. With changes in the general routines, I can then "immediately" see in which applications, and where, these changes will have consequences.

    This all is possible because "forms" are build by Modules that contain the code to tune one generalized Access-form, "reports" are building blocks to generate RTF- or HTML-code directly, and "querydefs" are reduced to sql-string that are constructed dynamically. Field-names and all related properties are available in metadata-tables. I only need to search in Modules and metadata-tables.

    Perhaps this non-conventional way triggers something.

    Imb.

    Saturday, February 15, 2020 10:09 PM
  • Did you check:

    Database Tools -> Add-ins


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, February 16, 2020 1:38 AM
  • David:

    I got the Find and Replace application developed in Germany by Access Development Tools to work. Yay!!!

    I finally figured it out.  I subscribe to Office 365 and the first 4 machines I used to download Office 365 defaulted to 32-bit (several years ago, that was the version Microsoft suggested).  The fifth machine I downloaded a few weeks ago DEFAULTED to 64-bit.

    So... I assumed it was the same 32 bit version of Office.  What happened was I used the 32-bit version of the Find and Replace developed by Access Development Tools to install the product on a 64-bit version of Access.  Of course, it didn't work!!

    The only improvement to the Find and Replace application would be to check versions before installing and give the user an error message if the versions (32 or 64) didn't match.  There were no error messages and the install went just fine.  So, without a warning, I was thrashing to find why.  Now I know.

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Sunday, February 16, 2020 10:26 PM
  • David:

    The only lingering issue, which I reported to Access Dev Tools, is that after I do a search (and when I have the Compact on Close enabled), there is an error message that occurs when I close Access.  Phillip was able to reproduce the error and he's working on it.

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Monday, February 17, 2020 8:55 PM
  • ... after I do a search (and when I have the Compact on Close enabled), there is an error message that occurs when I close Access.

    Thank you for reporting this!

    We released an update to Access DevTools Find and Replace that fixes this problem.

    See the Find and Replace – Version History for details and a download link to the new version. https://accessdevtools.com/blog/find-and-replace-version-history/


    Friday, April 17, 2020 11:35 AM