Opening a non-Access file from within Access

[JMCONNOR]

I have an Access 97 database that stores the contents of specified directories in an Access table. The database contains a form on which I can search for a specific file to see where it is on the drive.

I would like to know how to open the file (say, a ".doc" file) from this form. I know how to set the process in motion by setting an event, but I'm stumped at what the code would be to actually open and view the file.

I've been looking at the "SHELL" command but have so far been unsuccessful.

 

[PHV]

I'm not sure for ac97 but you may try the FollowHyperlink method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JMCONNOR]

That's it. Does exactly what I want. Thanks.