vba 自动刷新 Access 2010 中的 Sharepoint 链接表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23429699/
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
Auto refresh Sharepoint-linked Tables in Access 2010?
提问by vuyy1182
I have two tables linked with sharepoint lists. And I have a form in access db, each time when the form loads the table which is linked to sharepoint list should refresh automatically.
我有两个与共享点列表链接的表。我在访问数据库中有一个表单，每次表单加载链接到共享点列表的表时都应该自动刷新。
Is there ant way to do this in vba code?
I'm using
在 vba 代码中有没有蚂蚁的方法来做到这一点？
我正在使用
Application.DoCmd.TransferSharePointList acLinkSharePointList
采纳答案by MP24
Use CurrentDb.TableDefs("TableName").RefreshLink(replace TableNamewith your actual table name).
使用CurrentDb.TableDefs("TableName").RefreshLink（替换TableName为您的实际表名）。
