在Access中保存模块 [英] Saving Modules in 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.com 写道：
ca******@yahoo.com 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调用一个宏。
您可以访问 http://groups.google.com 高级搜索并输入
*访问团体和
从另一个数据库运行宏
搜索的单词和你我会得到很多点击。
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 http://groups.google.com 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.com 写道：
嗨
是否可以保存模块访问它们在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]
这篇关于在Access中保存模块的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
