Verify file exists before moving it

My DB will move files from folder to folder depending on selections made by
user.  For maintain a professional look I want to verify that the file exists
before I try to move it.  What code can I use?

Take a look at:http://www.devhut.net/index.php?

Take a look at:

http://www.devhut.net/index.php?lang=en&pid=0000000027#FileExist
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

If Len(Dir(Folder_Path_And_File_Name)) > 0 Then' your file existsElse' it does

If Len(Dir(Folder_Path_And_File_Name)) > 0 Then
' your file exists
Else
' it does not
End If

--JP

by
exists

Thanks for the help."Pastor Del" wrote:

Thanks for the help.