Question regarding MkDir

[RLConger]

Hey Gang, Question here...

I don't have any problems creating and naming a folder based on the
name of one field...


MkDir "C:\TestFolder\" & Me![ClientName]


But what If I wanted to make the folder name "[ClientName]
[Contract#]?


I figured it would be a matter of adding & Me![Contract#] after the
original code, but that doesnt seem to work for me.


Any thoughts on this would be appreciated. I wish that I could
convince the folks I am doing this for that a Client Name OR
Contract#
system would work fine, but they want both.


T.I.A.


Ryan

 

[Dirk Goldgar]

Hey Gang, Question here...

I don't have any problems creating and naming a folder based on the
name of one field...


MkDir "C:\TestFolder\" & Me![ClientName]


But what If I wanted to make the folder name "[ClientName]
[Contract#]?


I figured it would be a matter of adding & Me![Contract#] after the
original code, but that doesnt seem to work for me.


Any thoughts on this would be appreciated. I wish that I could
convince the folks I am doing this for that a Client Name OR
Contract#
system would work fine, but they want both.

You mean you tried this:

MkDir "C:\TestFolder\" & Me![ClientName] & Me![Contract#]

.... and it didn't work? What error message did you get?

It's possible that the problem is due to the specific contract number, or
the format of your contract numbers in general. There are some characters
that are not valid in file and folder names. Could you post back with a
contract number that doesn't work?