Question regarding MkDir

  • Thread starter Thread starter RLConger
  • Start date Start date
R

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
 
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.
Click to expand...


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?
 
Back
Top