transfer files from one folder to another and save the fielpath in database?

[akapag22]

HI Friends,

I am trying to create a form with command button which when clicked i would like to transfer photo files from folder x to folder y and save the new path in the database as a new record from each photo.

The fields in the database PhotoTable are recordid (autonumber), filepath, Photoname. How can i get this done in the button click as VBA code. Thank You

[ssanfu]

There are many methods to move a file.
You can copy and paste, then delete (kill statement) the file.
You can use filecopy, then delete (kill statement) the file.

You can use the File System Object. <<== what I did

Rather than try and explain how to use the file system object, I created a demo dB. This WILL move files!! Be warned!!
To test this dB, use junk files - files that you don't mind losing, until you are satisfied everything is proceding correctly.

'************************************************* *
' NOTE: requires a reference to Microsoft Office xx.0 Object Library
'--------------------------------------------------
'To use this code, you must reference
'The Microsoft Office 14.0 (or current version)
'Object Library by clicking menu Tools>References
'Check the box for:
'Microsoft Office 14.0 Object Library in Access 2010
'Microsoft Office 15.0 Object Library in Access 2013
'Click OK
'--------------------------------------------------
'************************************************* *


Wait! There's more!
In addition to moving files, the code also inserts a record into the table. Move a few files then look at the table to see if it is what you want.