linking data that's not a table

[Molly]

Hi,

I'm looking for a way to link a powerpoint file to a
record in an Access database. Each record will have a
link. I need the link to open Powerpoint and the selected
file. I don't have VB. Thanks so much!!!

Molly

 

[John Nurick]

Hi Molly,

The simplest way is just to create a hyperlink field in the table. You
can then drag either files (not just PowerPoint ones) or individual
slides onto the field (in a form or even directly on the table) and
Access will create a link to it. If to a slide, clicking on the link
will open Powerpoint and go directly to the particular slide.

(On my machine, dragging slides to Access appears to delete them from
the PPT document, which seems exactly the wrong thing to do. Either hold
down the control key while you're dragging, or else take care not to
save the presentation when you close it).