Saving file copies

[Naz]

Hi


I have a form for training courses that allows the person creating the
course to select the course documents, say the course outline.

At the moment i have them browse to the location of the file and pick the
file, this then gets embedded into the form as an OLE object. I've just
modified the Northwind database method MS used to show employee pictures.
I can't use hyperlinks because of filling issues, and i want the most
up-to-date one.

But of course this is not the best way to do it.....is there any way that
when people pick the file, i can get some code to read the file path and make
a copy in a specified folder. Storing just the file path into a normal text
box, so i can use it later on.

All help is appreciated.

 

[Alex Dybenko]

Hi,
yes, you can select file using this code:
http://www.mvps.org/access/api/api0001.htm

then copy it using FileCopy statement

and then show pictires in Image control, setting its picture property, or in
windows default viewer using:
http://www.mvps.org/access/api/api0018.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com