User would like to display a text file by clicking on the file name on a
form.(Set this up as a hyper link - it opens the text file in Notepad) They
may open several files at the same time. When they are finished on the form
with the list of files, they would like to close the form and have all the
text files closed also. Have been able to display without problem, but cannot
automatically close everything when the form is closed.

This gets a little deep, but here's a place to start:

http://mvps.org/access/api/api0025.htm

This API will close the application that's referenced. Although,
referencing the application is going to take yet another API (see the link in
the top of the link I posted). I've never used either of these two (the
stuff on Dev's site is extremely reliable, I just don't have any experiance
with this one in particular).

I'm not quite sure how you would handle multiple instances of it though.
Look around on mvps.org... its a great resource for this type of stuff.

It's not exactly an answer, but its a direction at least. You're dealing
with the operating system functions at this point, not access, so be wary.

Good luck!
--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain


"abs" wrote:

> User would like to display a text file by clicking on the file name on a
> form.(Set this up as a hyper link - it opens the text file in Notepad) They
> may open several files at the same time. When they are finished on the form
> with the list of files, they would like to close the form and have all the
> text files closed also. Have been able to display without problem, but cannot
> automatically close everything when the form is closed.