0

How can I create a button in form to open attachment window by clicking on it using macros or vba? attachment window

June7
  • 19,874
  • 8
  • 24
  • 34
Peter SH
  • 59
  • 1
  • 1
  • 7

1 Answers1

1

Saving objects in database tables uses up Access 2GB size limit. Attachment field is a multi-value type and can be frustrating to manage. Most experienced developers leave files in external folder location. Review Add/view attachments using MS Access VBA and Access Attachment Dialog Window.

However, following code worked for me.

Me.attachmentcontrolname.SetFocus
DoCmd.RunCommand acCmdManageAttachments
June7
  • 19,874
  • 8
  • 24
  • 34