I am trying to update a number of databases written in Access 2003 so that they will function in Access 2007. The problem I'm having is when it comes to trying to re-write VB that uses the Application.Filesearch functionality that has been removed from Office 2007.
I have found some very helpful information and resources regarding use of the Dir and FileSystemObject, but unfortunately I am not the database author and am a complete VB novice. I am therefore really struggling to successfully convert the Filesearch functionality using Dir.
An example of the type of code I am trying to convert is listed below, any help with this would be greatly appreciated!
Function File_Exists(Filename As String)
File_Exists = False
.LookIn = DirPart(Filename)
.SearchSubFolders = False
.Filename = FilePart(Filename)
.MatchTextExactly = True
' .FileType = msoFileTypeAllFiles
File_Exists = .Execute() <> 0