Error message when you try to run the FileSearch function in Access 2007: "You entered an expression that has an invalid reference to the property FileSearch"
SYMPTOMSWhen 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.CAUSEThe File Search task pane and the
FileSearch object have been removed from
the 2007 Microsoft Office programs. RESOLUTIONTo 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 (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 (http://support.microsoft.com/kb/186118/)
How to use FileSystemObject with Visual Basic
185601 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/920229/)
Error message when you run a macro to search for a file in an Office 2007 program: "Run-time error 5111"
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
