Common Dialog & Filecopy to save files to new destination

[alanach]

I have a datbase containing a table or query with several records containing hyperlinks to files located on a server.

I would like to be able to click a command button which:

1) Opens the common dialog box to allow the user to select the new file desination
2) Copies each of the hyperlink files on the query to the chosen destination, using the same filename and extension.

Can this be done easily? I've struggled with this and can't seem to find anything using the search function.

Any help is greatly appreciated.

 

[ProgramError]

what have you done so far?


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.