troubleshooting Question

Using a Button To Insert Object Into Access 2007 Form

Avatar of souquetbressand
souquetbressandFlag for United States of America asked on
Microsoft AccessVisual Basic Classic
7 Comments1 Solution1049 ViewsLast Modified:

I have a form which has a bound image field which stores OLE objects (specifically PDF documents) in a MySQL database backend.  When you use this field in the full version of Access 2007 you can right click and insert a document into the table.

However, in Access 2007 RunTime this menu is disabled.  I have seen information on how to create a custom menu which will give the same functionality, albeit with a significant amount of work, but I wish to use a button to insert the object into that field instead of the menu.  Regrettably I have been unable to locate any code or information which makes this process possible.  

What I need is for a user to click the button, have a dialog box pop up (hopefully the same one that full Access 2007 uses when you right click and "Insert Object") for the user to select the file, take that file and add it to the bound object field in the database, thus storing the document for later retrieval as is possible in full Access 2007.

Is this possible and if so, does anyone have a suggestion for a resource which I can use to design and build this function?  

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros