Simulating PP slide sorter on an Access form

[Silvester]

Hi,

I would like to simulate the PP slidesorter on an A2000 form along with a
Project! cmdbutton that will project the selected slide.

Something similar but very basic is here
http://msdn.microsoft.com/library/d...-us/dno2k3ta/html/OfficeAccess2PowerPoint.asp

Has anyone done work on this or can point me in the right direction ?

Thanks

 

[John Nurick]

Hi,

I would like to simulate the PP slidesorter on an A2000 form along with a
Project! cmdbutton that will project the selected slide.

I think this would be extremely difficult. For one thing, Access forms
don't lend themselves to drag-n-drop interfaces. Why not automate
PowerPoint and use the real slide sorter?

 

[Silvester]

Perhaps I do not need the sorter functions, ie: drag/drop/reorder facility
of the PP slidesorter. I agree with you there.

But I do need to be able to browse every slide in the existing presentation
and be able to select a slide on the form and project it, similar to what PP
does.

Any wisdom ?

 

[Steve Rindsberg]

Perhaps I do not need the sorter functions, ie: drag/drop/reorder facility
of the PP slidesorter. I agree with you there.

But I do need to be able to browse every slide in the existing presentation
and be able to select a slide on the form and project it, similar to what PP
does.

Any wisdom ?

Have a look at the examples at http://skp.mvps.org

Shyam's got an example of displaying slides in an external app on a form.

 

[Stephen Lebans]

An option would be to use the new Office Document ActiveX control here:
http://support.microsoft.com/kb/311765

This would allow you to host a normal PowerPoint presentation directly
on an Access form.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Silvester]

Thanks very much Steve and Stephen.

Most of the code samples I've seen only allow for opening a PP slideshow and
view 1 slide at a time using next, back buttons.


I was wondering about how to amend the code found here :
http://msdn.microsoft.com/library/d...-us/dno2k3ta/html/OfficeAccess2PowerPoint.asp
to be able to :
1. View all slides in the presentation simultaneously on a scrolling subform
using bound object frames
2. DblClick on any given form frame/slide to have it project

I was wondering if anyone has already done work similar to this ?

TIA

 

[Steve Rindsberg]

I wonder if a different approach might work better;

It's a fairly simple thing to export an image of whatever size you need from
each slide in a presentation. Export a thumbnail and a full size image of
each slide. You could then create your own slide-sorter-like critter using
multiple image controls on a form, and use those to display thumbnails. Then
when the user doubleclicks a thumbnail, do whatever it takes to display the
image full screen (another form, perhaps)

 

[Silvester]

Yes I did think of that. I exported all slides to jpgs and then directed the
Access form to display them in a continuous form. But the form only displays
the 1st image repeatedly.

Unless I'm wrong, I've found that there is no way to display images on a
scrolling continuous Access form. This seems to be a Access limitation.

I wonder if there is an anwer to this in VB ? Then maybe I can shell it from
Access.

 

[Steve Rindsberg]

Yes I did think of that. I exported all slides to jpgs and then directed the
Access form to display them in a continuous form. But the form only displays
the 1st image repeatedly.

Unless I'm wrong, I've found that there is no way to display images on a
scrolling continuous Access form. This seems to be a Access limitation.

That's possible ... I don't use Access, but I've worked with an Access developer
on a project; from what I gather, the forms are a good bit different than the
forms we're used to in VB/PPT VBA.

I wonder if there is an anwer to this in VB ? Then maybe I can shell it from
Access.

Possibly an array of image controls?

 

[Silvester]

Stephen Lebans came out with an elegant solution on my other posting titled
"initiate PP instance in slidesorter view on A200 forms"

 

[Steve Rindsberg]

Stephen Lebans came out with an elegant solution on my other posting titled
"initiate PP instance in slidesorter view on A200 forms"

Yes, I saw that. Thanks for following up here with the info too.