Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011

    Unanswered: Looking for an old post

    While Googling around looking for a solution I found a reference that I think will do what I am looking for:

    However...when I try to follow the says I don't have permission. I am trying to link an OLE object through vba after some user input. I know how to create the field and I know how to manually input the link, I just don't users to have to do anything more than specify the file name.

    Thanks for any help you folks can offer.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    here. this might help you find it... | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2011

    Thanks for the help...

    It definitely got me going in the right direction and I now have an easy solution. I was trying to display PowerPoint previews dynamically without having to generate the preview everytime. Now I create the link when a new record is added and anytime the user browses through the entries...the OLE displays the preview instantly.

    Here is the little bit of code I used:

    strMarketingMaterialsLocation = DLookup("ASK_MarketingMaterials", "tbl_ADM_LocalInformation")
    strPresentationFileName = Me.PresentationSlideFile
    strPresentationFilePath = strMarketingMaterialsLocation & "\" & strPresentationFileName
    Me.SlideThumbnail.Class = "PowerPoint.Show"
    Me.SlideThumbnail.OLETypeAllowed = acOLELinked
    Me.SlideThumbnail.SourceDoc = strPresentationFilePath
    Me.SlideThumbnail.Action = acOLECreateLink

    Thanks again for the nudge in the right direction!

Posting Permissions

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