No disrepect for Neopa (he's my teacher :) )
However, before posting your code please wait until you have done the following:
1) Make sure the following two lines are at the top of the module that contains your code. Doesn't matter if it's a form, class, or standard module. Insert these two lines as very first two lines if missing:
- Option Compare Database
-
Option Explicit
2) In the vba editor, debug, compile. Fix any errors that appear. Repeat this step until no errors occur.
3) Double check that you have list/read/write/modify rights to the source directory and the destination directory.
Once you have completed 1 and 2 and verified 3 try running your code. If you are still having issues
then please post your code (formatted using the <CODE/> button please) along with the
exact number, title, and text of the error.