Storing data via Powerpoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been asked by a colleague if I could possibly set-up a survey using Powerpoint. I can insert ActiveX components in my presentation but how do I actually capture the data using powerpoint - is it possible

I've considered trying to connect to an Access database but I'm not sure how that would be possible. There is an add-on called Datapoint which will allow for this but I do not have the correct service pack to install the trial version. Please, let me know if you have an answer to my problem - either using Powerpoint or alternative tools.
 
Hi Jeppo,
I'm the developper of the DataPoint you were talking about.
What do you mean by: "not have the correct service pack to install ...".
If you don't have the correct service pack installed, it does NOT mean that
you cannot try out the functionality of datapoint. If you discard the minor
problems of the original xp version, you can still evaluate datapoint.
For example, if you run ppt xp without sp1, ending a running presentation is
causing datapoint to stop because the object model is incorrectly indicating
that ppt is stopped instead that the running presentation is stopped.
But even without SP1 you are still able to evaluate datapoint (or any other
tool).

Best regards
Kurt Dupont.

Jeppo said:
I've been asked by a colleague if I could possibly set-up a survey using
Click to expand...
Powerpoint. I can insert ActiveX components in my presentation but how do I
actually capture the data using powerpoint - is it possible?
I've considered trying to connect to an Access database but I'm not sure
Click to expand...
how that would be possible. There is an add-on called Datapoint which will
allow for this but I do not have the correct service pack to install the
trial version. Please, let me know if you have an answer to my problem -
either using Powerpoint or alternative tools.
 
It is actually quite easy to capture data using PowerPoint (using VBA code).
I have several CBT samples that capture data to an Access database. I would
be more than happy to provide some starting points if you decide you want to
do it on your own. I even have a sample CBT on my web site that you can
download and try out. The code is protected, but I would be happy to get
you started in the right direction if you care to try.

Web site link: http://www.pttinc.com/power_point.htm#PowerPoint

--
Bill Foley, Microsoft MVP (PowerPoint)
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."

Jeppo said:
I've been asked by a colleague if I could possibly set-up a survey using
Click to expand...
Powerpoint. I can insert ActiveX components in my presentation but how do I
actually capture the data using powerpoint - is it possible?
I've considered trying to connect to an Access database but I'm not sure
Click to expand...
how that would be possible. There is an add-on called Datapoint which will
allow for this but I do not have the correct service pack to install the
trial version. Please, let me know if you have an answer to my problem -
either using Powerpoint or alternative tools.
 
Hi Kurt,
Thanks for your feedback. After speaking to my system admin. it turned out that the installation problems of the trial version were due to having the wrong Windows installer version (used vers. 1.0), so I upgradede the installer version to 2.0 and the installation went perfectly.
Cheers, Jeppo
 
It would be great if you could supply some VBA code, which will put me in the right direction. Naturally, I would prefer to be able to connect to an Access database (inserting data from PowerPoint to the DB) by writting code; however, my coding skilld are limited so any pointers would be hugely appreciated
Cheers, Mik

----- Bill Foley wrote: ----

It is actually quite easy to capture data using PowerPoint (using VBA code)
I have several CBT samples that capture data to an Access database. I woul
be more than happy to provide some starting points if you decide you want t
do it on your own. I even have a sample CBT on my web site that you ca
download and try out. The code is protected, but I would be happy to ge
you started in the right direction if you care to try

Web site link: http://www.pttinc.com/power_point.htm#PowerPoin

--
Bill Foley, Microsoft MVP (PowerPoint
www.pttinc.co
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq
"Success, something you measure when you are through succeeding.

Jeppo said:
I've been asked by a colleague if I could possibly set-up a survey usin
Click to expand...
Powerpoint. I can insert ActiveX components in my presentation but how do
actually capture the data using powerpoint - is it possiblehow that would be possible. There is an add-on called Datapoint which wil
allow for this but I do not have the correct service pack to install th
trial version. Please, let me know if you have an answer to my problem
either using Powerpoint or alternative tools
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

The Office Online web site actually contains a short tutorial on how to do
this using ActiveX controls and VBA (sample code included), in one of the
Power User columns:

http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010429541033&C
TT=98

If you (or anyone else reading this message) think that it's important that
PowerPoint provide this kind of functionality (without having to resort to
VBA or add-ins), don't forget to send your feedback (in YOUR OWN WORDS,
please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Back
Top