请问怎么知道一个字段是不是自动编号?
Dim rs1 As Recordset, I As Integer
Set rs1 = CurrentDb.OpenRecordset("SELECT * FROM b105p")
MsgBox rs1.Fields.Count ' 列
For I = 0 To rs1.Fields.Count - 1
MsgBox rs1.Fields(I).Type & rs1.Fields(I).Name & rs1.Fields(I).Attributes
'名称MsgBox
If rs1.Fields(I).Attributes = 49 Then
MsgBox "yes"
End If
Next I
Set rs1 = Nothing
又怎么得到自动编号的增量呢?
估计无法得到,只能修改
请问怎么知道一个字段是不是自动编号?
Dim rs1 As Recordset, I As Integer
Set rs1 = CurrentDb.OpenRecordset("SELECT * FROM b105p")
MsgBox rs1.Fields.Count ' 列
For I = 0 To rs1.Fields.Count - 1
MsgBox rs1.Fields(I).Type & rs1.Fields(I).Name & rs1.Fields(I).Attributes
'名称MsgBox
If rs1.Fields(I).Attributes = 49 Then
MsgBox "yes"
End If
Next I
Set rs1 = Nothing
又怎么得到自动编号的增量呢?
估计无法得到,只能修改