我套用别人的代码:结果就是存在文件夹中没用到的图片未被删除,就是说不能准确地做出判断
Private Sub 清除_Click()
'Me.图片名称 = Null
'Call Form_Current
On Error GoTo Err_清除_Click
Dim FSO As Object
Dim 图片名称 As String
If (Not IsNull(DLookup("[图片编号]", "tbl信息图片表", "[图片名称] ='" & Me![图片名称] & "'"))) Then
MsgBox "清除当前图片"
Me!图像控件.Picture = "" '清除图像
Else
'If Not IsNull(Me.图片名称) Then
Set FSO = CreateObject("Scripting.FileSystemObject")
If FSO.FileExists(Me!图像控件.Picture) = True Then
FSO.Deletefile Me!图像控件.Picture
Me!图像控件.Picture = "" '清除图像
Set FSO = Nothing
End If
End If
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.GoToRecord , , acNewRec
Me.图片数量.Requery
Exit_清除_Click:
Exit Sub
Err_清除_Click:
MsgBox Err.Description
Resume Exit_清除_Click
End Sub