"Save As" option to an external link through Access form

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a switchboard menu within access and I want one of
menu options to point to an external file location and
provide the user with the option of saving this external
file to a network location. How can I create an Event
Procedure behind the button to do this?

Thanks
 
I have a switchboard menu within
access and I want one of menu options
to point to an external file location and
provide the user with the option of saving
this external file to a network location.
Click to expand...
How can I create an Event
Procedure behind the button to do this?
Click to expand...

The CopyFile statement copies a file to a new location. There is code,
donated by Ken Getz, that uses the Windows Common Dialog API to let a user
choose a File to Open, Save, or Save As -- it's at
http://www.mvps.org/access/api/api0001.htm (and it's not difficult to use -- worked
for me on the first try; it even has sample code for calling the procedure.

Larry Linson
Microsoft Access MVP
 
Back
Top