Получение значения счётчика таблицы (ADOX)По материалам: https://www.everythingaccess.com/tutorials.asp?ID=ADOX-programming-examples#ShowAllTables Function GetSeedADOX(strTable As String, Optional ByRef strCol As String) As Long 'Purpose: Read the Seed of the AutoNumber of a table. 'Arguments: strTable the table to examine. ' strCol = the name of the field. If omited, the code finds it. 'Return: The seed value. Dim cat As New ADOX.Catalog 'Root object of ADOX. Dim tbl As ADOX.Table 'Each Table in Tables. Dim col As ADOX.Column 'Each Column in the Table. 'Point the catalog to the current project's connection. Set cat.ActiveConnection = CurrentProject.Connection Set tbl = cat.Tables(strTable) 'Loop through the columns to find the AutoNumber. For Each col In tbl.Columns If col.Properties("Autoincrement") Then strCol = col.Name GetSeedADOX = col.Properties("Seed") Exit For 'There can be only one AutoNum. End If Next 'Clean up Set col = Nothing Set tbl = Nothing Set cat = Nothing End Function |
|||
L.E. 27.06.2022 |