Help with storing directory name into a table

[jker]

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

[June7]

Is this code behind a form bound to that table? What event is code in? Which line triggers the compile error?

[Welshgasman]

No need to store the CustID, you can append that any time you need the path.

[jker]

here are the screen shots of what is happening:

[Micron]

My guess is that CUST_DIR may be the name of the field that the control is bound to but that is not the name of the control. The message is fairly straight forward - code has no idea what CUST_DIR is as a data member.

[Welshgasman]

My thoughts exactly.

[jker]

thank you|||| that was the problem incorrect control name

[ArviLaanemets]

An advice - don't never use same name for control and for name of field it is linked to. I myself prefer name controls with prefixes indicating control type. E.g.
Table field name TableField. The control linked to this field: txtTableField when text box, cbbTableField when combo box, etc.

The similar convention I use for naming subforms. E.g. I have forms fMyForm1 and fMyform2. When I insert fMyForm2 as subform into fMyForm1, then I name the subform control in fMyForm1 as sfMyForm2 (NB! The default name Access uses will be same as form inserted as subform has!). The form fMyForm2 will be a source of subform sfMyForm2.

With this, both you yourself, and your Access app, always know exactly, what was referred to in script!