Make Folder button Error with name folder based off of a field in form

[rmb89]

Hey everyone, I am new to Access and I have managed to somehow get all of my buttons to work except one, my button that makes folders. I can get it to make folder where I want it, but I can not get it to name the folder based off of a certain field on my form. I also need it to copy a folder template each time it goes to make a new folder, but was trying to get this part to work first. Any advice would be great. I feel like I am missing something very simple in the code and I have searched for a few days and watched multiple videos with no success.



here is the code I am currently using:

Private Sub Command452_Click()
Const FOLDER_EXISTS = 75
    Dim strFolderPath As String
    strFolderPath = "C:\Access Pipeline\Projects"
    
    On Error Resume Next
    MkDir "C:\Access Pipeline\Projects"
    Err.Clear
    MkDir "C:\Access Pipeline\Projects\" & "Project_Name"
    Err.Clear
    MkDir strFolderPath
    Select Case Err.Number
        Case 0
        ' no error
        Case FOLDER_EXISTS
        ' folder exists so open it
        Application.FollowHyperlink strFolder
        Case Else
        ' unknown error so inform user
        MsgBox Err.Description, vbExclamation, "Error"
     End Select
End Sub

[pbaldy]

If you mean this line:

MkDir "C:\Access Pipeline\Projects" & "Project_Name"

you don't want quotes around the value. More like:

MkDir "C:\Access Pipeline\Projects" & Me.Project_Name

presuming Project_Name is the name of the textbox with the value.

[rmb89]

When I did that it said, "Path not found."

[pbaldy]

I somehow deleted the backslash. Try

MkDir "C:\Access Pipeline\Projects" & Me.Project_Name

[pbaldy]

Okay, I didn't delete it, the forum software keeps dropping it. Make sure you add one after Projects.

[rmb89]

Thank you so much! That did it!!

[pbaldy]

Happy to help and welcome to the site by the way!