Breaking News

Tuesday, June 26, 2012

Ex1: VBA - Set the Seed of an AutoNumber using ADOX


Function SetSeed(strTable As String, strAutoNum As String, lngID As Long) As Boolean
'Purpose: Set the Seed of an AutoNumber using ADOX.
Dim cat As New ADOX.Catalog

Set cat.ActiveConnection = CurrentProject.Connection
cat.Tables(strTable).Columns(strAutoNum).Properties("Seed") = lngID
Set cat = Nothing
SetSeed = True
End Function

No comments:

Post a Comment

Designed By Published.. Blogger Templates