ask end-users&developers before dropping Application.FileSearch!!

[Guest]

Here is Access 2003 (and also generic VBA) code that has used in a large
number of Access 2003 Projects, often in multiple subroutines:

Dim FindExistingFile As Office.FileSearch
Set FindExistingFile = Application.FileSearch

When Microsoft customers run the working Access 2003 (and other Office 2003)
applications under Access 2007 (Excel 2007, et cetera),
the code breaks with the following errors:

Microsoft Visual Basic
-----------------------
Run-time error '2455':
You entered an expression that has an invalid reference to the property
FileSearch.

The options are End or Debug.



PLEASE ..... this needs to be fixed immediately.

Also, I notice that my particular customer is not the only one with this
problem.

For example, there are TechNet Excel 2007 threads talking about broken VBA
code
with regards to Application.FileSearch.

I can not understand how Microsoft can deem a product fit to ship when
obvious bugs
exist and should have been detected in alpha testing.



regards ...
gerry

gerry lowry 905.825.9582
ability business computer services
1421 Derby County Crescent
Oakville Ontario Canada L6M 4N8
(e-mail address removed)
http://abilitybusinesscomputerservices.com

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...caf6&dg=microsoft.public.access.modulesdaovba

 

['69 Camaro]

Hi, Gerry.

PLEASE ..... this needs to be fixed immediately.

It will not be fixed in Access 2007.

I can not understand how Microsoft can deem a product fit to ship when
obvious bugs
exist and should have been detected in alpha testing.

It's not a bug. This feature was intentionally removed. Please see Allen
Browne's tip, "List files recursively" tip for other suggestions to replace
the FileSearch Property:
http://allenbrowne.com/ser-59.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

To add some to what Gunny has already told you, here is a free article
available on Access Advisor.com, written by Access MVP Doug Steele:

Find Your Data
http://advisor.com/doc/16279

Doug shows how to use three methods to help find files.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________