I would like to create Customer folders on the users C drive based on what record the user is viewing.

Thus a send event of:

"cmd.exe /c MD C:Customers" & CustomerName

I receive an error message at then end of the Customers line stating I need a closing quotation mark.

The calc engine will accept this string if the last isnt there.

Could someone help guide me with the correct string?

The backslash is reserved as an escape character. In your formula, the combination " escapes the closing quotation mark and turns it into a literal character. Try:

"cmd.exe /c MD C:Customers" & CustomerName

Here the first backslash escapes the second one, so you get a literal backslash character, followed by an unescaped quotation mark.

See also: Help > Creating a database > Working with formulas and functions > Identifying text constants and special characters in formulas

ARG! THANK YOU.

I need to write this down....thats the second time I've got stumped on that!

Thanks again for you help...

You can make any post a favorite. However, when it is your own, you can find them by going to the Menu >> ACTIVITY >> My Topics.

HTH

Lee