Attachment Dialog Box

jeannie Jones
jeannie Jones used Ask the Experts™
on
I am trying to open the window pictured in the following link using a commmand button in a form. Is it possible that anyone can show me how to do that?

http://www.utteraccess.com/forum/Launching-Attachments-Dia-t1652872.html

Thank you in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Fabrice LambertConsulting
Distinguished Expert 2017

Commented:
Hi,

Don't think it is doable as this dialog box is build in access.

On the other hand, you can make a form that will behav exactly like it.
jeannie JonesDatabase Developer

Author

Commented:
how would i do that
Mark EdwardsChief Technology Officer

Commented:
You're not the first to want to do this.  Check out this link I found by googling "access vba add attachment":

https://stackoverflow.com/questions/18237180/add-view-attachments-using-ms-access-vba
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

jeannie JonesDatabase Developer

Author

Commented:
i will thank you
jeannie JonesDatabase Developer

Author

Commented:
i have a button on my form that when the user clicks on it the attachment dialog box pops up that what im looking for not sure if it can be done
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Personally, I just never add attachments to my Access databases, I always store those files on a file server and only store the pointer to the file in Access.  Attachments rapidly eat up the very limited amount of space accessible in an Access database.

Dale
Chief Technology Officer
Commented:
Jeannie:  I've attached a demo file that does what you want it to.  You can examine the design to see how it works.

Enjoy!
AttachmentManagementBoxPopup.zip
jeannie JonesDatabase Developer

Author

Commented:
Thank you Mark Edwards for your help that was exactly what I was looking for.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial