ID: 307
Viewed: 3610
Added: Aug 19, 2002
Version:
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo
Thank you for your vote. Please wait...
It appears you already voted for this snippet
It appears your vote value was empty
Code to get the next available value for a numberic field such as a Primary Key field for a given table/field. Uses ADO.
Highlight all by clicking in box
<!---Declaration--->
none
Highlight All
<!---Code--->
'------------------------------------------------------------
' Author: Clint LaFever [lafeverc@usa.net]
' Purpose: Used to obtain the next available ID in a given table/field
' Parameters: tNAME=Table; fNAME=Field
' Example: x=GetNextID"tblCUSTOMERS","CUST_ID"
'------------------------------------------------------------
Public Function GetNextID(tNAME As String, fNAME As String) As Long
On Error GoTo ErrorGetNextID
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset rs.Open "Select Max(" & fNAME & ") As MaxID from " & tNAME, db.cn, adOpenStatic
If rs.EOF = False Then
If IsNull(rs!MAXID) Then
GetNextID = 1
Else
If rs!MAXID <> -1 Then
GetNextID = rs!MAXID + 1
Else GetNextID = 1
End If
End If
Else GetNextID = 1
End If
Exit Function
ErrorGetNextID:
MsgBox Err & ":Error in GetNextID(). Error Message:" & Err.Description, vbCritical, "Warning"
GetNextID = 0
Exit Function
End Function
;
No Comments to show
Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.
Adding your comment. Please wait...
Thanks for adding your comment!. After further review it will be added.
There was a problem adding your comment. Please try again.
Please complete all the fields in the form before sending.