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
