Access 2010 Report Dynamic Link To Solidworks Drawing in OLEUnbound Box

Greetings Experts.
I have an Access 2010 report that has an OLEunbond image of a Solidwork 2013 drawing.
I can view the document fine, however for each new item number, it is displaying the same image.  

The report is based on a query that contains a unique path for each item that is fully qualified:

in the query, this path is called ImagePath.

In the property sheet for this object is

OLE type                    Linked
OLE Type Allowed     Linked
OLE Class                   SolidWorks 2013
Class                           SldDraw.Document
Update                        Options Automatic

I also have a text box txtImagePath that builds the full path to the drawing.

Is there a way to have the picture change for each new detail item number record?
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Those values should be set for you in Access, but you should certainly check them.

OLE stuff has always been hit-or-miss in Access, so it doesn't surprise me that it won't render your drawing properly.

So if you switch back to Unbound OLE Object, can you then set the SourceItem or Sourcedoc in code? I'm not sure, but you could try this on the Report's Print or Format event:

Me.MyOLEControl.SourceDocument = "path to the document"

One trick that may work is to use a Web Browser control to show the document. Essentially, if you can view your item in a web browser (like you can a PDF, for instance), then often you can use a WebBrowser control on the form/report, and set the .Navigate property to the path of the item.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you sure you should be using an Unbound OLE control? If you're storing the image link, try using an Bound OLE Control instead.
ScamquistAuthor Commented:
I tried a Bound OLE control.  I put ImagePath as the control source.  
The control is blank when I open the report.

Do I need to specify the OLE Type Allowed and Class?
ScamquistAuthor Commented:
I believe the solid works drawings may be the issue.  Will try other image types.  thank you for the assist.
ScamquistAuthor Commented:
Thank you for the help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.