Open Multiple Attachments (1 Viewer)

jacksonwearn

New member
Local time
Today, 07:39
Joined
Jun 14, 2013
Messages
9
I have a Database with a field that holds several attachments. I want to make a command button for a form that will open the attachment window that pops up when you double click on the attachment in the table.

attach_fig7(1).gif

I'd like the above window to open when I click the command button.
 

JHB

Have been here a while
Local time
Today, 15:39
Joined
Jun 17, 2012
Messages
7,732
If the forms recordsource is bound to a query/table with an attachment and have a control on form for it you can use below code to open dialogbox.
Code:
DoCmd.GoToControl "MyAttachmentControlName"  
Application.RunCommand (acCmdManageAttachments)
 

jacksonwearn

New member
Local time
Today, 07:39
Joined
Jun 14, 2013
Messages
9
If the forms recordsource is bound to a query/table with an attachment and have a control on form for it you can use below code to open dialogbox.
Code:
DoCmd.GoToControl "MyAttachmentControlName"  
Application.RunCommand (acCmdManageAttachments)

This works perfectly. Thanks!
 

Users who are viewing this thread

Top Bottom