I know, I'm late but here my working Access VBA function code. Thanks to everybody for the help!
Public Function CopyDeleteFolder()
Call CopyAllFilesInFolder("C:\Source", "C:\Destination")
Call DeleteAllFilesInFolder("C:\Source")
End Function
Public Function...