I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.
I know that Access can store a hyperlink to a slide or a Word bookmark, and
I have fooled around with it. But I do not want an app where the client has
to click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no user
interaction.
In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevant
info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant
slides to a new presentation.
Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Access
to simulate a user clicking on the link.
Thanks for any info.
Alan