Microsoft KB Archive/935402

= Error message when you try to run the FileSearch function in Access 2007: &quot;You entered an expression that has an invalid reference to the property FileSearch&quot; =

Article ID: 935402

Article Last Modified on 4/5/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-



SYMPTOMS
When you try to run the FileSearch function in Microsoft Office Access 2007, you receive the following error message:

You entered an expression that has an invalid reference to the property FileSearch.

This problem occurs if the FileSearch function was created in an earlier version of Access.



CAUSE
The File Search task pane and the FileSearch object have been removed from the 2007 Microsoft Office programs.



RESOLUTION
To programmatically search for a file in Access 2007, you can use either the Dir function or the FileSystemObject class.

For more information about the Dir function, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/access/HA012288241033.aspx

The FileSystemObject class was originally created for the Microsoft Visual Basic Scripting Edition. The FileSystemObject class is not included in the Visual Basic for Applications object library. To use the FileSystemObject class, you must select Microsoft Scripting Run-time (Scrrun.dll) in the References dialog box for the project.

For more information about the FileSystemObject class, click the following article numbers to view the articles in the Microsoft Knowledge Base:

186118 How to use FileSystemObject with Visual Basic

185601 How to recursively search directories by using FileSystemObject



MORE INFORMATION
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

920229 Error message when you run a macro to search for a file in an Office 2007 program: &quot;Run-time error 5111&quot;

Keywords: kbexpertiseinter kbtshoot kbprb KB935402

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.