How to produce & print in Poerpoint??

[webmeister]

I've got a small employee training tracking database - no problem there. What the users currently do is to run a report from the database that shows who received what training, and when. They then open Powerpoint, pull up a training certificate document and manually type the employee name (by referring to the MS Access report), course taken and date the course was completed.

Here's my question: Can Access automatically pull up or go into Powerpoint and produce these Powerpoint certificates automatically? If so, how would I go about doing this? The users would love me forever (or at least until the next request) if this can be automated.

Yhank you in advance - it's amazing how knowledgeable you folks are!!

 

[The_Doc_Man]

A couple of thoughts...

1. Access reports can be made to look like powerpoint reports if you have access to the same image library of clip-art and such. Why bother with PowerPoint?

2. Word MailMerge can be made to look like powerpoint reports if you have access to the same image library of clip-art and such. Why bother with Powerpoint?

3. OK, you really wanted to do this? What you must do is open PowerPoint as an application. (Look up Application Objects in Access.)

Now open a blank presentation in PowerPoint and open ITS Help file to look at the section on programming objects in PP. These objects will include a collection of slides which have a collection of text and other objects.

You will need to add a text object with font, size, style, color, etc. and place it at specific coordinates on the slide. You can pre-format the slide to hold everything else, but the name and date will be something to be added later.

 

[webmeister]

Doc Man,

Thanks for your reply...... sometimes someone else's ideas are just the jump-start needed. I think I'll take the approach of checking those image files you mentioned - just not sure about the cutesy borders that come with Powerpoint...... any suggestions on that?

Thanks again!