copy file from "The path chosen by the user" to Specified folder by programmer

[asipoolika]

Hi Guys

Is there a way of copy and pasting a file such as a Word document, pdf, image, or Database, from "The path chosen by the user" to "Specified folder by programmer" on your hard drive using Microsoft Access.

Thanks for any help that you may offer

[Seth Schrock]

Use the FileCopy() function.

FileCopy(Source:="", Destination:="")

Just put the proper file paths in between the double quotes.

[asipoolika]

i am asking for a way to select a file by user.. and then automatic paste file to Specified folder by programmer.. Please put a sample code to help me .. thanks

[Seth Schrock]

Are you talking Windows user or a user in your database? Are the folders for each programmer in some table? As of right now, you haven't provided enough information to give sample code.