I am working with Microsoft Access 2010. I have an application which was developed in Access 2003 and is using the Application.FileSearch command.
This command is not present in Access2010 please could anyone check and update the code to cater for the FileSearch..
Thank you ever so muchCode:
On Error GoTo Search_Err
Dim strPrompt As String, strTitle As String
ChDir AttachmentPath ' Changes directory to new file path
Dim i As Integer
.LookIn = AttachmentPath
.FileName = Fname
If .Execute > 0 Then
AttachST = 1
AttachST = 0
MsgBox "File Path Not Found (" & Error$ & ")", vbInformation, vbNullString