Runtime Error 13

[ddrew]

I'm getting a runtime error 13 on this line of code. Its a piece of code to make a directory, but I cant see anything wrong!

    strBackUpDogNameFolder = "c:\GPandDetectionDogTrainingLogBackUpsandReports\" & Forms![frm_Profile]![Discipline] \ " & Forms![frm_Profile]![DogName]"

 

[RuralGuy]

Why do you have spaces around the 2nd "/"? " / "

 

[ddrew]

Why do you have spaces around the 2nd "/"? " / "

Do you mean this bit:

 \ " & Forms![frm_Profile]![DogName]"

It put them in automaticaly

 

[CJ_London]

You are mssing an ampersand and quotation mark

... & Forms![frm_Profile]![Discipline] & "\" & Forms![frm_Profile]![DogName]"

 

[RuralGuy]

Can you remove them? I would also use a dot "." rather than a bang "!" in your Forms reference.

 

[RuralGuy]

Good catch CJ!

 

[CJ_London]

Also notice you have a surplus quotation mark at the end and you also need to ensure the dogname has a filetype - .jpg or whatever. Or add it on after e.g.

...& Forms![frm_Profile]![DogName] & ".jpg"

 

[ddrew]

Thanks mate

 

[ddrew]

Also notice you have a surplus quotation mark at the end and you also need to ensure the dogname has a filetype - .jpg or whatever. Or add it on after e.g.

...& Forms![frm_Profile]![DogName] & ".jpg"

DoigName is a Subfolder, works once I had put in the & and " and removed the last "

Many thanks