I have a MS Access 2003 membership database (operating system is Windows XP).
In a form I want to be able to create a command button which sets up a sub folder in a specific drive to store documents related to that person.
The file path for where the sub folder is to be created is: C:\ My Documents\CDG\Members Files\
The naming protocol for the subfolder would be [First Name]-[Last Name]-[ID] i.e. Dave-Smith-123
The end result in this example would therefore be a folder file path of : C:\ My Documents\CDG\Members Files\ Dave-Smith-123
If the subfolder already exists then I need a message box to come up and say Sub Folder Already Exists & doesnt try & create a new one.
Can anyone help?