Not a Member Yet,
Click here to Register

ID: 307
Viewed: 3601
Added: Aug 19, 2002
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo

User Rated at: 0 Stars
Rate This:

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

Highlight All
' Author: Clint LaFever []
' 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,, adOpenStatic
If rs.EOF = False Then
If IsNull(rs!MAXID) Then
GetNextID = 1
If rs!MAXID <> -1 Then
GetNextID = rs!MAXID + 1
Else GetNextID = 1
End If
End If
Else GetNextID = 1
End If
Exit Function
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.

Replying to a Comment...

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.

© 2002 - 2024 All Rights Reserved. Conditions
Do NOT follow this link or you will be banned from the site!