Attachment Dialog Box

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?

Thank you in advance!
jeannie JonesDatabase DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fabrice LambertConsultingCommented:

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 DeveloperAuthor Commented:
how would i do that
Mark EdwardsChief Technology OfficerCommented:
You're not the first to want to do this.  Check out this link I found by googling "access vba add attachment":
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

jeannie JonesDatabase DeveloperAuthor Commented:
i will thank you
jeannie JonesDatabase DeveloperAuthor 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 LLCCommented:
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.

Mark EdwardsChief Technology OfficerCommented:
Jeannie:  I've attached a demo file that does what you want it to.  You can examine the design to see how it works.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jeannie JonesDatabase DeveloperAuthor Commented:
Thank you Mark Edwards for your help that was exactly what I was looking for.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.