Display a drawing on an MS Access Form

Hot Topic

INserting custom fields in Word
Program code fro sorting coloumns in a listbox VB Excel
How to check the TCP/IP checkbox in network connection property window?
printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro
Calendar control issue in excel
Is VBA SDK free and ...?
Problem with Microsoft CRM 3.0 Outlook Client
a big thank you!
Code erroring out.
Protecting the Source Code

Microsoft ISV

Installing VBA6.0 on XP
How to open Access files and export them to Excel
What MSDN editions have non-English Windows XP?
ISV Competency Partners left behind for Office 12 Beta
extract office file's title into excel
Word Macro Runtime Error
Excel DDE Server
Excel Range Selection
Output property to save as
Vb migration to Access 2003

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

  • pierguido

    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)



  • Timothy John Peters

    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)



  • Jason Timms

    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

  • Yahor Sinkevich

    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