Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: Insert Into Unbound Object Frame

    I have an access database with tables linked from oracle.
    I have a form with an unbound object frame on it.
    I am attempting to insert a word document into this frame through code.
    My word documents are stored in a table in Oracle.
    I wanted to retrieve the word document from the database using a lookup then insert into the frame.
    My frame is named LetterDocument
    Here's what I have so far
    LetterDocument.Class = "Word.Document"
    LetterDocument.SourceDoc = DLookup("[WordDocument]", "[Table]", "[ID]=" & Me.ID_Field.Value)
    LetterDocument.Action = acOLECreateEmbed
    I can't figure out what property allows me to insert the document directly. SourceDoc is looking for a path.

  2. #2
    Join Date
    Mar 2005
    I think I figured it out?
    I need to use a Bound Object Frame and leave it unbound.
    Then in code I can use
    BoundObjectFrame.Value = DLookup......
    It seems to work, hopefully I am approaching it correctly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts