在2010 Data Macro中运行VBA代码 [英] Run vba code from within 2010 Data Macro

问题描述

我有一个创建文本文件的功能，需要从数据宏运行它.这样偶数就可以在桌子上使用它了. 我该怎么做呢?

I have a function that creates a text file and need to run it from the data macro. so then the evens can use it on the table. How do I go about doing this?

推荐答案

根据我们的聊天记录，您没有.数据宏甚至在MS Access外部运行，如果它们在MS Access中使用代码，则不会发生这种情况.它们与数据库引擎绑定在一起，而数据库引擎对Access前端一无所知.

You don't, as per our chat. Data macros even run outside of MS Access, if they used code within MS Access, this could not happen. They are tied to the database engine, which knows nothing about Access front-end.

您可以从数据宏AFAIK运行查询，，并且可以创建查询以写入文件 *，但不能运行VBA.

You can run queries from a data macro AFAIK, and it is possible to create a query to write to a file*, but you cannot run VBA.

*我对此进行了进一步研究，发现:数据宏中不允许包含链接表，操作查询和数据库引用的查询."

* I looked into this a little more and I find: "Queries that contain linked tables, action queries, and database references are not allowed in data macros."

这篇关于在2010 Data Macro中运行VBA代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！