I did some trial and error and was able to make it work.
Private Sub Command7_Click()
Dim PathFilename As String Dim FilenameOnly As String Dim L As Integer
L = Len(ImagesFolder) PathFilename = GetFileNameOnly(LaunchCD(Me)) FilenameOnly = PathFilename
If Left(PathFilename, L) <> ImagesFolder Then 'FilenameOnly = EmployeeID & "-" & FilenameOnly To Add claim number to photo. If Dir(ImagesFolder & FilenameOnly) <> "" Then If MsgBox("File Already Exist, Overwrite It?", vbYesNo) = vbNo Then Exit Sub End If End If
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Imaging Seminar.