Display a drawing on an MS Access Form

Hot Topic

Open an excel file
Section 1 Footer
Losing primary display on Windows 2003 SE w/ single Radeon display
VBA WORKSHEET
Serial Port Communication Using MS Access VBA
Convert UTC date to mm/dd/yyyy hh-mm-ss
Defining a range according to the number of responses
custom toolbar error
How to install MS Jet 4.0 OLE DB?
VBA Collection Object

Microsoft ISV

Important MS Partner Question
Number formatting
Client to SSAS
run a macro in excel
Open an excel file
When to program in VBA and when not to???
Hi, Outlook new Mail item
Help with using Outlook from Access
Sql Server 2005 Resource Kit
Avalon Adaptation

Display a drawing on an MS Access Form

Hi there i would like to display a drawing (test.dwg) on my form in a
vb code. The form has an Bound Object Frame - OLE1 area. So
when the i press an button it should display the diagram itself (not
the link) inside the Bound Object Frame and be able to zoom in and out and edit. Thank you

Answer this question

Display a drawing on an MS Access Form

  • DPVic

    Here's the latest from the support engineer:

    As I mentioned, first of all, we have to confirm that the 3rd party ActiveX document support OLE automation server and just in-place editing. That’s very important to this issue. Base on the description provided by our buddy, we can not even fulfill the task and display the OLE document by manually inserting. I suggest our buddy contact Intergraph and get the confirmation from them (Intergraph Support Service) ASAP. http://ppm.intergraph.com/smartsketch/. It might be the most efficient way for this issue presently.

    -brenda (ISV Buddy Team)



  • withRajeev

    Per our support engineer:

    Base on my understanding, our buddy wants to insert "SmartSketch.Document" object (a 3rd product) into OLE field and then display in the Bound Object Frame control. Firstly, please ask our buddy refer to following articles:

    ACC: OLE Object Inserted into Object Frame Displayed as Icon

    http://support.microsoft.com/kb/q177587/

    ACC2: How to Programmatically Embed or Link an Object in a Form

    http://support.microsoft.com/kb/q114214/

    The most important thing is to confirm the third party object supports OLE Automation Server or not.

    Here’s some general troubleshooting steps if we do make sure it support OLE Automation Server:

    1. Check on BMP or PPT temporarily instead of "SmartSketch.Document"

    2. Right click the Bound Object Frame control and click “Insert Object…” to manually insert a "SmartSketch.Document" object. Can this issue be reproduced

    3. Please let me know Office version/ Office SP version/OS version and OS SP version.

    -brenda (ISV Buddy Team)



  • Oscar Naim - MSFT

    AT the moment i'm getting only the icon and file name displayed in the OLE1. When i click on the icon then it opens up the the diagram in SmartSketch which i don't want.


    here are the lines i'm using

    [OLE1].Class = "SmartSketch.Document"
    [OLE1].OLETypeAllowed = acOLEEmbedded
    [OLE1].SourceDoc = [File_Name]
    [OLE1].Action = acOLECreateEmbed
    [OLE1].Verb = 1

  • Tamar E. Granor

    hi there thank you for your reply.
    I can see a bmp picture in the OLE area.
    You can right click and select SmartSketch Document from the list to create an object type. But when i create a new object test.dwg i still get the icon. however i see the test.dwg when i copy the from the smartsketch window and paste to the OLE area.

    Office Pro 2003 (11.5614.5606)
    Windows XP PRO SP2
  • Display a drawing on an MS Access Form
Answer this question