Solved

Access 2010 Report Dynamic Link To Solidworks Drawing in OLEUnbound Box

Posted on 2014-04-24
5
832 Views
Last Modified: 2014-05-02
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:
\\tcadcam1\cad\Master\1201\120197.SLDDRW

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?
0
Comment
Question by:Scamquist
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 84
ID: 40021207
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.
0
 
LVL 1

Author Comment

by:Scamquist
ID: 40021405
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?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40022192
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.
0
 
LVL 1

Author Comment

by:Scamquist
ID: 40037546
I believe the solid works drawings may be the issue.  Will try other image types.  thank you for the assist.
0
 
LVL 1

Author Closing Comment

by:Scamquist
ID: 40037547
Thank you for the help
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question