vba 如何在 Ms Access 中插入后获取自动编号？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2459259/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How do I get the auto number after an INSERT in Ms Access?
提问by Justin Tanner
I have the following query in VBA:
我在 VBA 中有以下查询：
DoCmd.RunSQL "INSERT INTO table (value) VALUES ('example')"
( with an auto incremented primary key called id)
（具有称为自动递增的主键id）
How can I get the auto incremented id generated by this insert?
如何获得此插入生成的自动递增 ID？
回答by MJ Hufford
I believe you're looking for:
我相信你正在寻找：
@@Identity
It's similar to SCOPE_IDENTITY in T-SQL. Check out this article for more info:
它类似于 T-SQL 中的 SCOPE_IDENTITY。查看这篇文章了解更多信息：
http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record
http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently- added-record
