hello there,
i'm looking for an easy way to copy any file from one location to an other one, thereby renaming it:
when clicking an "import" button on a form i would like a file dialog to open, the file i select should be then be copied, appending the current date to the file name; the destination folder of the copied file should be the one the mdb file itself is in (access should retrieve the destination path each time the button is pressed).
finally a text control on the form should show the linked path of the copied file...
i thought this would be an easy one, but it seems it isn't for me! anyone to help? I guess this will use the CopyFile Command but, I have no clue how to use it. many thanks in advance!
i'm looking for an easy way to copy any file from one location to an other one, thereby renaming it:
when clicking an "import" button on a form i would like a file dialog to open, the file i select should be then be copied, appending the current date to the file name; the destination folder of the copied file should be the one the mdb file itself is in (access should retrieve the destination path each time the button is pressed).
finally a text control on the form should show the linked path of the copied file...
i thought this would be an easy one, but it seems it isn't for me! anyone to help? I guess this will use the CopyFile Command but, I have no clue how to use it. many thanks in advance!
