Verify file exists before moving it

Asked By Pastor Del
20-Nov-09 06:52 PM
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?

Daniel Pineault replied to Pastor Del
20-Nov-09 07:01 PM
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

JP replied to Pastor Del
23-Nov-09 11:20 AM
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:

Pastor Del replied to Pastor Del
23-Nov-09 04:18 PM
Thanks for the help.
Post Question To EggHeadCafe