Copy folder (1 Viewer)

Super Suarez

Registered User.
Local time
Yesterday, 19:01
Joined
Jul 10, 2013
Messages
36
Hi

I'm looking for copy folder functionality and I can't find anything.

In access 2007 when I push a button on a form, I want to copy a network folder to another location and rename it.

Anyone any ideas?

Thanks
 

apr pillai

AWF VIP
Local time
Today, 07:31
Joined
Jan 20, 2005
Messages
735
Open Notepad, Copy and Paste the following lines:
Code:
@Echo off
Echo :---------------------------
Echo : Copying Folder/Sunfolders
Echo :---------------------------
Echo :
Echo :Please wait... 
Echo : 
XCopy "Z:\FolderName\*.*" "C:\TargetFolder\" /E

Modify the Xcopy command line to specify the correct Source & Target Folder locations.

Save the File with the Name: FolderCopy.BAT

Create a Command Button on the Form, from where you want to launch the Copying action.

Display the Property Sheet of the Command Button. Select the On Click Event property and click on the build button (...) to open the VBA Event Procedure.

Copy and paste the following line between the procedure starting and closing lines:

Code:
Call Shell("C:\FolderName\FolderCopy.Bat")

Please correct the FolderName part.

NB: You should have appropriate Network Authority to do this without running into problems.
 

Users who are viewing this thread

Top Bottom