• unbound frames (2003)

    Author
    Topic
    #430849

    Please Help, I am trying to use a list box populated by a query to change the object in an unbound list box using the onclick event. History: I established an unbound object frame and put a clip of a word document in it and displayed on a form. I then created a list box and tried to create an on click event to change the object in the frame to a new word document (I’m sort of using this as a document preview situation). However no matter what I try I can’t get it to work. I looked at the help text and it described a way of linking but if I follow that method exactly it still will not work. I would appreciate any thoughts on this.

    I tried this code based on previous thread suggestions within this forum:

    ” With Me.objFrmContractReviewPreview
    .CLASS = “Microsoft.Word”
    .SourceDoc = “W:DEPT400410SHAREContractReviewEDAN00024-00-C-2103 P00016.doc”
    .Action = acOLECreateEmbed ‘ or acOLECreateLink
    End With”

    and get this:

    “Run Time Error 2793

    Microsoft Office Access can’t perform the operation specified in the action property of the visual basic procedure youre trying to run.”

    Thanks
    Kevin

    Viewing 0 reply threads
    Author
    Replies
    • #1007092

      1) Use .Class = “Word.Document.8”
      2) Make sure that you set Enabled = True and Locked = False for objFrmContractReviewPreview, either in design view or in code.

    Viewing 0 reply threads
    Reply To: unbound frames (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: