Downloading a file

[Elaine]

My boss wants me to create an Access form that will list
different files containing forms created in Word or Excel
that will be available to our customers. He wants it so
that when they click on the file name it will download.
His idea is to keep all the information in a table using
OLE and/or Hyperlink data types. Fortunately, I'm not
restricted to that and I can do it any way I want. I just
have to make sure it is run from our Access form. I can
use the OLE or Hyperlink which opens the file then they
can "Save As..", but he would rather keep it so it just
downloads automatically. Can anyone give me ideas how to
accomplish this.
Thanks. Elaine

 

[Danny J. Lesandrini]

Elaine:

The file copy can be done with, oddly enough, the FileCopy command.
How you display it is up to you, but this is the code that does the work.

FileCopy sSource, sDestination