P
Paul Valente
Hello to all
I know that PP can display data from other sources like Access in it's
slides, but can the PP send data to an Access table?
I have a number of presentations that are used for safety training that are
dispensed by cd-rom throughout our organisation
for personnel to run periodically. At the end of the presentation there are
a number of True or False questions
that the user answers by selecting the appropriate response with the mouse.
The selections are all controlled by VBA to tally their
response against an array of correct answers, it then determines the score
out of 100 and prints a certificate at the end with their name,
the date tested and the valid to date included. Their names are entered
from a custom user form built into the presentation.
I would like to have these instances recorded into our Safety Management
database to allow us to keep track of this training .
At the moment all data is sent by the presentation to a delimited text file
on the server using the Open and Print statements,
after which the file is read and appended to a table using Access. I've
tried to declare and open a recordset and send the data through to Access
but it won't work as PP doesn't use the Jet Engine to handle data. I want to
automate the data gathering as much as possible as there are lot of
personnel to train.
My question is there another way to accomplish this using VBA or is there an
add-in available that will allow this data transfer?
Thanks for listening to my problem.
Regards
Paul
I know that PP can display data from other sources like Access in it's
slides, but can the PP send data to an Access table?
I have a number of presentations that are used for safety training that are
dispensed by cd-rom throughout our organisation
for personnel to run periodically. At the end of the presentation there are
a number of True or False questions
that the user answers by selecting the appropriate response with the mouse.
The selections are all controlled by VBA to tally their
response against an array of correct answers, it then determines the score
out of 100 and prints a certificate at the end with their name,
the date tested and the valid to date included. Their names are entered
from a custom user form built into the presentation.
I would like to have these instances recorded into our Safety Management
database to allow us to keep track of this training .
At the moment all data is sent by the presentation to a delimited text file
on the server using the Open and Print statements,
after which the file is read and appended to a table using Access. I've
tried to declare and open a recordset and send the data through to Access
but it won't work as PP doesn't use the Jet Engine to handle data. I want to
automate the data gathering as much as possible as there are lot of
personnel to train.
My question is there another way to accomplish this using VBA or is there an
add-in available that will allow this data transfer?
Thanks for listening to my problem.
Regards
Paul