Verify file exists before moving it

[Pastor Del]

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?

 

[Daniel Pineault]

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.

 

[JP]

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

--JP

 

[Pastor Del]

Thanks for the help.