I have a table named CUSTOMER and it has a text column to store the customer directory path,
I put in code to create the directory in the on the users C: drive, and that works correctly. The problem i have is that i get a compile error when i try to store the directory name into the table column (CUST_DIR)
'*************************************************
'** make a DOS directory for new customer
'*************************************************
Dim strpath As String
strpath = "C:\globalbeauty\images\cust-" & CUST_ID
If Dir(strpath, vbDirectory) > vbNullString Then 'test for directory existing
Exit Sub
End If
MkDir strpath
Me.CUST_DIR = strpath