
例如将O0001程序段后注释钻孔(ZUANKONG),则编写程序:
O0001(ZUANKONG) M3S2000
G90G99G73X300.Y-300.Z-300.R-100.Q15F100.
。。。
。。。
这样在程序号后面就有ZUANKONG这个注释了!
Sub AppendDescriptionToField(ByVal TableName As String, ByVal FieldName As String, ByVal Description As String)
On Error GoTo ErrP
Dim TDS As TableDefs
Dim TD As TableDef
Dim F As dao.Field
Dim P As Property
Set TDS = CurrentDb.TableDefs
Set TD = TDS(TableName)
Set F = TD.Fields(FieldName)
Set P = F.CreateProperty("Description", dbText, Description)
F.Properties.Append P
ExitSub:
Set P = Nothing
Set F = Nothing
Set TD = Nothing
Set TDS = Nothing
Exit Sub
ErrP:
If Err.Number = 3367 Then
F.Properties("Description") = Description
Else
MsgBox Err.Number & " " & Err.Description
End If
GoTo ExitSub
End Sub
复制上面的代码到一个模块中,在其他在方就可以调用了
使用方法
AppendDescriptionToField "表名","字段名","该字段的说明文本"
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)