'取得表的主键
Public Function GetID(ls_Table) As String
On Error GoTo Errhandle
Dim ls_ID As String, rs As New ADODB.Recordset
ls_ID = Format$(Now, "YYYYMMDD")
If rs.State = adStateOpen Then rs.Close
rs.Open "select max(ID) from " & ls_Table & " where ID like '" & ls_ID & "%'", cn, adOpenForwardOnly, adLockReadOnly
If IsNull(rs.Fields(0).Value) Then
ls_ID = ls_ID & "0001"
Else
ls_ID = rs.Fields(0).Value + 1
End If
GetID = ls_ID
rs.Close
Set rs = Nothing
Exit Function
Errhandle:
If rs.State = adStateOpen Then rs.Close
Set rs = Nothing
MsgBox Err.Description
End Function