在Access中保存模块

本文介绍了在Access中保存模块的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好 是否可以按照保存方式将模块保存在Access中？ Excel？ Excel使用Personal.xls用于在每个工作表上使用宏。 MS Access中是否有个人空间在哪里存储模块 方式？所以你可以在每个数据库上使用它们。 Thx LC

Hi Is it possible to save Modules in Access the way they are saved in Excel? Excel uses Personal.xls for using macros on every Worksheet. Is there a Personal space in MS Access where to store Modules the same way? So you can use them on every DB. Thx LC

推荐答案

ca******@yahoo 写道： ca******@yahoo wrote: 您好是否可以按照Excel中保存的方式将模块保存在Access中？ Excel使用Personal.xls在每个工作表上使用宏。 MS Access中是否有个人空间以相同的方式存储模块？所以你可以在每个数据库上使用它们。 Thx LC Hi Is it possible to save Modules in Access the way they are saved in Excel? Excel uses Personal.xls for using macros on every Worksheet. Is there a Personal space in MS Access where to store Modules the same way? So you can use them on every DB. Thx LC

我从未听说过它。我通常做File / GetExternalData / Import。 我想你可以有一个空白的数据库，当你创建一个新的 时，你可以复制它。 您还可以引用包含宏的数据库。 创建一个新数据库。打开一个代码模块，选择References， 浏览到包含宏的MDB并设置对它的引用。 现在从另一个MDB调用一个宏。 您可以访问 groups.google 高级搜索并输入 *访问团体和 从另一个数据库运行宏 搜索的单词和你我会得到很多点击。

I''ve never heard of it. I usually do File/GetExternalData/Import. I suppose you could have a blank database and when you create a new one you could copy it over. You could also make a reference to that database that holds the macros. Create a new database. Open up a code module, select References, browse to the MDB that contains the macros and set a reference to it. Now call a macro from the other MDB. You can go to groups.google advanced search and enter *Access* for groups and run macro from another database for the words to search and you''ll get lots of hits.

< duncecap = ON> 这是MDA文件的用途吗？然后你可以在 你的参考文献列表中引用它并只使用它库中的所有代码？ 我*做*检查帮助文件，但是他们没有帮助！ < duncecap = OFF> <duncecap=ON> Is that what an MDA file is for? Then you can just reference it in your References list and just use all the code in its libraries? I *did* check the help files, but they were of no help! <duncecap=OFF>

ca ****** @ yahoo 写道： 嗨是否可以保存模块访问它们在Excel中保存的方式？ Excel使用Personal.xls在每个工作表上使用宏。 MS Access中是否有个人空间以同样的方式存储模块？所以你可以在每个数据库上使用它们。 Hi Is it possible to save Modules in Access the way they are saved in Excel? Excel uses Personal.xls for using macros on every Worksheet. Is there a Personal space in MS Access where to store Modules the same way? So you can use them on every DB.

是的。 创建MDA（或MDB，MDA是只需将MDB重命名），将所有 代码放入其中，然后在主数据库中设置对它的引用。 - [OO = 00 = OO]

Yes. Create an MDA (or an MDB, an MDA is just an MDB renamed), put all your code in there, then in your main database, set a reference to it. -- [OO=00=OO]