Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Embedded OLE object update sluggish (2000/sp3)

    So I've got an embedded OLE object (powerpoint slide) on a form.

    I'm using that slide to genreate a polyline of points to represent some database information visually (relative coordinates).

    I'm finding that the update is extremely sluggish, upwards of 1-2 seconds between when VBA code creates or deletes the polyline, and when the slide on the form is actually updated.

    I tried a few things and found that if I double-clicked the slide to edit-in-place (not open a PPT app window), and then ran my code, the slide was updated immediately! And when I exited "edit" mode (even if exited before 1-2 sec passed), the update was also quicker to the embedded slide.

    I suspect that the sluggishness may come from how Access is going to PowerPoint to update the slide, and then maybe copying the data through DDE (or similar) to represent the slide in the embedded object; I'm no expert, just poking around. I've attached my test database to this email for reference...

    How can I speed up the respose-time on this embedded slide?

    ..dane

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Embedded OLE object update sluggish (2000/sp3)

    Insert

    frmPreview!pptPanelPreview.Action = acOLEActivate

    before drawing the polyline, and

    frmPreview!pptPanelPreview.Action = acOLEClose

    afterwards.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2002
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Embedded OLE object update sluggish (2000/sp3)

    Thanks for the suggestion Hans. Worked like a champ..

    FYI -- I set the .verb to acOLEVerbHide to keep the PowerPoint application from popping up and remaining open even after the slide had been updated..

    ..dane

Posting Permissions

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