Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 935402 - Last Review: April 5, 2007 - Revision: 1.0
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"
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.
The
File Search task pane and the
FileSearch object have been removed from
the 2007 Microsoft Office programs.
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:
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://kbalertz.com/Feedback.aspx?kbNumber=186118/
)
How to use FileSystemObject with Visual Basic
185601Â
(http://kbalertz.com/Feedback.aspx?kbNumber=185601/
)
How to recursively search directories by using FileSystemObject
For more information, click the
following article number to view the article in the Microsoft Knowledge Base:
920229Â
(http://kbalertz.com/Feedback.aspx?kbNumber=920229/
)
Error message when you run a macro to search for a file in an Office 2007 program: "Run-time error 5111"
APPLIES TO
- Microsoft Office Access 2007
| kbexpertiseinter kbtshoot kbprb KB935402 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate