Class Module Replacement for Office FileSearch Object

[David W. Fenton]

In late May and early June, I posted a flurry of activity on my work
on replacing the Office FileSearch object with a class module that
replicates most of its functionality (the feature was removed from
Office 2007, thus necessitating a replacement).

I've finally gotten around to documenting it and folding in the
improvements that I made to it when implementing it for my client.

You can read about it (in some detail) and download the sample
database here:

http://dfenton.com/DFA/download/Access/FileSearch.html

The demo database has a sample implementation of the class module,
but all you need to really use it is the class module itself.

I'd love it others would try it out and make it break, but I know
everybody's busy.

I also cleaned up and updated my main Access download page:

http://dfenton.com/DFA/download/Access/

I cut out a lot of the ancient stuff (like 16-bit OCX's and a
discussion of the A97 bookmark bug) and re-organized the page (I
also converted it to use stricter HTML, but that doesn't change the
content or appearance). I also rewrote the information about my
Multiple Back End Reconnect Utility:

http://dfenton.com/DFA/download/Access/Reconnect.html

So, I'd appreciate feedback on any of that, but particularly on the
File Search class module.

Thanks for reading!

 

[David W. Fenton]

You can read about it (in some detail) and download the sample
database here:

http://dfenton.com/DFA/download/Access/FileSearch.html

Fixed version uploaded, so if you downloaded it before 12:30pm
Eastern, you need to re-download.

The reason is that Tom Wickerath took the time to test, and found a
bug immediately, one which I introduced during the process of
getting it ready to upload yesterday, and one which points out the
perils of trying to work with UI from a multi-purpose class module
like this.

The problem was that I added optional arguments to the ProgressBar
sub, and didn't test what happened when those were nothing and got
passed off to the form's subroutine for handling that.

If anyone has any ideas on how to do something like this in a manner
that causes as little alteration to the class module as possible.

 

[David W. Fenton]

Linked at:
http://allenbrowne.com/links.html

Thank you, Allen.

And to anyone who hasn't visited that links page recently, it's well
worth some time -- I picked up a few for my bookmarks that I didn't
know about.