Hey Leon,
This can be done on my system (XP Home with Access 2003 and PowerPoint
2003), but causes 2 ugly 'hyperlinks are the root of all evil: they will
cause gingivitis, ED, poor credit, and computer viruses' warnings before
opening the MS Access form. I make no claims that this technique will work
in any other configuration, but it is worth a try.
To set this up:
1) In the Access forms dialog, right click on the form you will want to
open.
2) Select 'Create shortcut' to this form and save to the same directory as
the access database.
3) In PowerPoint, right click the shape to trigger the opening of the form
and select Hyperlink.
4) Navigate to the Shortcut to ... file you just created. Clicking or
double clicking on the file will not insert it or the path into the
hyperlink field. That is pretty weird, but hey, maybe there is a reason I
don't know about.
5) In the hyperlink to field, manually type the full path and filename (i.e.
"Shortcut to MyForm in MyAccessDatabase") and add the extension ".maf" to
the end.
6) Run the presentation and click on the hyperlinked object.
7) Click the 'appease the MS PowerPoint lawyers hyperlink warning' and the
other 'appease the MS lawyers some more' OK button on the 'some files blah
blah blah' stuff. I know, I know. Why do you want these warnings to be
shown to the audience? You don't, the lawyers just seemed to want your
audience to be their witnesses.
8) Presto, bingo, roger and out.
--
Bill Dilworth
Microsoft PPT MVP Team
Users helping fellow users.
===============
Please spend a few minutes checking vestprog2@
out
www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.
Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
