如何禁止/屏蔽docmd.runsql执行查询时的提示?<查询>

如何禁止/屏蔽docmd.runsql执行查询时的提示?<查询>
如何禁止/屏蔽docmd.runsql执行查询时的提示?

在执行docmd.runsql前面先用 docmd.setwarnings false 屏蔽掉提示,查询执行完成后再打开提示功能。

docmd.setwarnings false
docmd.runsql "insert into tbale1 from table2"
docmd.setwarnings true

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus