PDA

View Full Version : Connecting PowerPoint to a help database


VileFriend
01-19-2003, 08:07 AM
I have plans to create custom designed, unique and specific help programs for businesses.
This will give them the ability to provide a VCA. A Virtual Counter Assistant is to provide either their staff or customers with the ability to resolve many problems without requiring the time and effort of other people!
The idea is to silfer the query to determine the correct answer and then to give that answer in a PowerPoint presentation.
I have yet to decide on many aspects of it but I do need ideas and clarification on two points.
What database should I use and consequently how would you connect that database to PowerPoint:confused:
Do I go the HTML way? I am not keen on Windows help but Outlook Express is better as are many 3rd party products.
All ideas, advice and guidance will be gratefully appreciated, thank you.

MikeParent
01-19-2003, 08:57 AM
As far as I know PowerPoint can only publish a presentation as static HTML (1 slide=1 page). You may be best to create web templates and use those instead.

MikeParent
01-20-2003, 08:54 AM
I suspect powerpoint when it is running could in fact pull database content, but what we are talking about at best would be a ptp viewer plug-in or control running inside a web page... if you're going to do that, why bother with powerpoint at all, just an extra step.

Build a web template to mirror the powerpoint template.

VileFriend
01-26-2003, 05:39 PM
Originally posted by dbindel
Agreed. Or you can try to make your presentation in Flash (which *can* utilize databases in a live situation.)
Excuse me guys but I think you've got it backwards. I don't want PPT to get information from Access but for Access to decide which PPT presentation to run. Then the PPT can just call Access to start all over again.:cool:
What I am really looking for I suppose is the VBA code that could make this happen.EG:
[VBA] to "Execute PPT presentation The answer! from Access with variable 'Answer to Question'."
[VBA] to "Execute Access from PPT at Question point to silfer the correct 'Answer to Question'."

VileFriend
02-01-2003, 05:04 AM
This thread became
Connect Access to PowerPoint and back again
on the Microsoft forum where a Great man calling himself Duff gave me this link!:cheers:
Microsoft Knowledge Base Article - 210075 (http://support.microsoft.com/default.aspx?scid=kb;en-us;210075)
THANK YOU EVERYONE!:joy:
Look out for my soon to be released VCE. Coming to a Website near you, soon!:crazy: