asked on How loop through records and create folders for each record on a server drive
I have a database that contains several records related to properties. I want to somehow run a function that will create a folder on a server drive for me for each of this properties just by clicking a button on a temporary form.
The schema for the folders on the server will be like:
Master Folder Name (to be named "Properties"
>>>>>City, State (from the property record)
>>>>>>>>>>Property Name (from the Property record)
In other words as an example like this screen shot:
![Server folder example]()
How can this be done?
The schema for the folders on the server will be like:
Master Folder Name (to be named "Properties"
>>>>>City, State (from the property record)
>>>>>>>>>>Property Name (from the Property record)
In other words as an example like this screen shot:
How can this be done?
Microsoft Access
Last Comment
SteveL13
ASKER
Database sample attached.
Make-Folders.accdb
Make-Folders.accdb
what is the path to the server?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Absolutely perfect!!! I did change one line to add the property ID and put the city and state in the folder name...
strFolder = "C:\Properties\" & rs!City & " " & rs!State & "\" & rs!ID & " - " & rs!PropertyName & "\"
strFolder = "C:\Properties\" & rs!City & " " & rs!State & "\" & rs!ID & " - " & rs!PropertyName & "\"
ASKER
Absolutely amazing. Thank you!
upload a sample db with the table.