如何编辑和复制非VBA宏? [英] How to edit and copy non-VBA-macros?

问题描述

嗯，我知道Access中的VBA宏和非VBA宏之间是有区别的.

Well, I know, there is a difference between VBA-macros and non-VBA-macros in Access.

VBA宏的创建和编辑与Word/Excel并没有太大区别:您有一个文本字段，可在其中编写代码:

Creating and editing of VBA-macros is not very different from Word/Excel: you have a text field, where you can write your code:

但是如何编辑非VBA宏呢?对我来说，这就像使用鼠标单击进行编程"(对我来说，对于Access中的新手来说，看起来很奇怪):

But what about editing of non-VBA-macros? For me, it looks like "programming using a mouse-clicking" (for me, as for the new guy in Access, it looks very weird):

问题:

• 这是使用鼠标"在Access中编辑非VBA宏的常用且正确的方法吗?或者，也许还有另一种方式，如第一张图片所示?

• Is it a common and correct way to edit non-VBA-macros in Access "using a mouse"? Or, probably, there is another way, like shown on the 1st image?

如果我有

If I have an embedded (as opposed to standalone) non-VBA-macro, how I can copy it from one database to another (or, to Stack Overflow)?

推荐答案

非VBA宏可能不应该手动编辑.

Non-VBA macros should probably not be manually edited.

您可以通过以下方法复制AXL:打开宏，使用Ctrl + A，Ctrl + C，然后将其粘贴到文本文件中.这对于共享宏非常有用，因为其他人可以粘贴它，如下所示:要将宏从Stack Overflow粘贴到Access中.

You can copy the AXL by opening the macro, using Ctrl + A, Ctrl + C, and then pasting it to a text file. This is mainly useful for sharing a macro, because others can paste it, as outlined here: To paste a macro from Stack Overflow into Access.

您可以复制和粘贴普通，嵌入式和数据宏的AXL.请注意，数据宏使用的功能集与普通宏不同，并且每个事件的可用性也不同.普通宏和嵌入式宏兼容.

You can copy and paste the AXL of normal, embedded and data macros. Note that data macros use a different set of functions than normal macros, and the availability differs per event. Normal and embedded macros are compatible.

您当然可以编辑AXL.但是据我所知，无法从Access中对其进行编辑，而且XML验证之外也没有验证.

You can, of course, edit the AXL. But as far as I know, there's no way to edit it from Access, and there's no validation outside of XML validation.

这篇关于如何编辑和复制非VBA宏?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！