Copy files to a separate folder then create hyperlink record

[Guest]

I have a database of Contracts, Leases etc..

I would like to be able to click a button on a form and add a hyperlink to
the file to the DocumentLink field of Documentation table.

The Documentation table has a Unique Identifer called DocumentID. Each
contract record also has fields ContractName and ContractID.

These documents may be .pdf .doc .xls etc...
Click the hyperlink, the file opens.

I can get this far, however...

The database would prompt the user for the file location (could be anywhere
on the Network) make a copy of the file and place it in the folder:
z:/contracts/database/documents

I want to make a copy so that things don't get deleted or moved.

I also want to change the file name to be a concatination of:
DocumentID&ContractName&Year&Month&Date

eg: 001MainOfficeLease20070212

I then only want to display this new file name instead of the full file path
as the hyperlink.

Any suggestions?

 

[Guest]

You'll probably also want to check out
http://www.mvps.org/access/api/api0001.htm to get a file dialog so that your
users can select the file(s) to be copied.

Then simply use the FileCopy and Format(Date(),"yyyymmdd")) to copy and
rename your files.

Finally, you simply use that same value to populate your hyperlink field

Daniel