If Folder Doesnt Exist - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

If Folder Doesnt Exist

John Davy

5 years ago

Hi Rick,
I watched you video on Access Backup several times and then
made a replica. I also made a Setup Form with the path to DestFolder and alsos the path to the ServerFile. Then I created TempVars for each on Load of the MainMenuF. I create the DestFolder if it does not exist. My question is:
My DestFolder is off the D: drive ie'> D:\MyDestFoler. Do you have any videos to show how to deal with creating the folder is it is 2 levels deep. ie. D:\MyDestFolder\John?

Thanks
John Davy

	Alex Hedley @Reply 5 years ago
You could convert this CreateSubfolders.vbs to VBA.

	Alex Hedley @Reply 5 years ago
Or try something like `If Dir(YourPath, vbDirectory) = "" Then Shell ("cmd /c mkdir """ & YourPath & """") End If` Source: StackOverflow

	Richard Rost @Reply 5 years ago
I did that in ABCD5, I think, but I just manually added the multiple levels. I'm sure you could easily write a recursive sub to do that. Just loop down the full path and stop at each "\" and add that folder.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View