CODEWITHSUNDEEP
ms-accessvbams-access-2013
Chris R
Chris R

Reputation: 33

Suppress the Attachment dialog in Access 2013

So I have a double click event on an OLE object to send an email and after that executes the attachment dialog comes up. I have the field locked so the user cannot update the picture anyway but I would prefer it not show at all. Is there anyway to suppress this dialog?

Dialog

Upvotes: 0

Views: 104

Answers (1)

Erik A
Erik A

Reputation: 32672

(I'm assuming here you're using an attachment field and not an OLE object field)

You can cancel showing the attachment dialog, by setting Cancel = True in the DoubleClick event, like this:

Private Sub myAttachmentField_DblClick(Cancel As Integer)
    Cancel = True
End Sub

Upvotes: 1

Related Questions