Need Help (prevent Overwriting Existing File, Access 2010

[Alphix]

Need Help in modifying code to prevent from overwriting existing file.

The code copy's file correctly but does not prevent the user from overwriting existing code.

I need help with this.

Example Upload Button.zip

[ssanfu]

You just need to add code to check if the file exists in the destination directory. Then decide if you want to overwrite the existing file.

See:
FileExists() and FolderExists() functions
http://allenbrowne.com/func-11.html

[Alphix]

Hi Steve,
I am still pretty new with Access. I am not sure how to add this within the IF Then statement in the code.

After Copy File, If file exist in destination folder then prompt user with message, file exist, rename file.

I am not sure how to implement in code without breaking it.

[ssanfu]

How about this??

[Alphix]

Wow, thank you alot...That is a beast of a code. I will study it to see how it works, also I am trying
to modify it to send the copied file to a designated destination folder.

Thank you again Steve.

[Alphix]

I have tried modifying it several times and still not able to paste it in another folder other than CurrentProject Path.

Can you please help me again?

Thank you.

[ssanfu]

I added select the destination folder code. You select the destination, then select the file to copy.

I also modified some if the code in "Command3_Click()"......

[Alphix]

Thank you Steve, this is what I needed.
Take care.

[ssanfu]

You're welcome...