办公室更新后，VB代码不再起作用 [英] VB code doesn't work anymore after office update

问题描述

您好


我最近更新了从Office 97到Office 2007的访问数据库。但不知何故，这些事件现在已被破坏。通常我可以进入一个领域我驾驶了多少公里的汽车，在点击保存按钮后，它会告诉我在另一个领域我花了多少钱。代码如下：

Hello

I''ve updated recently an access database from Office 97 to office 2007. But somehow the events are broken now. Usually I could enter into a field how many kilometers I''ve driven with my car and after hitting the "save"-button, it would show me in another field how many money I''ve spent for it. The code is this:

展开 | 选择 | Wrap | 行号

推荐答案

通常将默认安全设置更改为禁用所有宏/ vba


看看 export-access-form-ppt Post 36

尽管这是针对电源点的，但同样适用于所有Office2007 / 2010。找到更改后台功能区的选项，添加开发人员选项卡，然后按照其余说明操作。


如果这不能解决您的问题，那么您将拥有要完全卸载并重新安装整个办公程序。

Often the default security setting is changed to disable all macros/vba

Take a look at export-access-form-ppt Post 36
Even though this is for power point, the same will apply for all Office2007/2010. Find the option to alter the ribbon on the back stage, add the developer tab, and the follow the remaining instructions.

If this doesn''t fix your issue, then you will have to do a FULL uninstall and re-install of the entire office program.

谢谢，就是这样。我不得不更改宏的安全设置，现在它可以正常工作：）

Thanks, it was really this. I had to change security settings for macros and now it works perfectly fine :)

将项目从不受信任的位置移动到可信位置的可行替代方法，只需添加它们当前位于受信任位置列表中的位置。显然，只有在他们处于可信赖的地方时才这样做。加载电子邮件附件的临时文件夹不会是一个值得信赖的位置。

我似乎记得应该有某些东西（某处）允许你信任当前访问权限项目" ;.我找不到它，但是如果你遇到它，那就应该检查一下。


自从正确审查后 - 见后面的评论 - 我记得这是我经常需要设置为True的东西，但对于那些知道需要它的人来说应该只设置为True。开发人员通常（甚至不是所有人），或者被他们完全信任的开发人员告知的人。在实践中，这意味着很少有人需要这个设置为True，而那些做过的人可能会在没有我告诉他们的情况下知道。


小心这个选项。这可能很危险。

A viable alternative to moving your projects from a non-trusted location to a trusted one, is simply to add the location they are currently in to the list of trusted locations. Obviously, only do this if where they are in a trustable place. The temp folder where email attachments are loaded up into would not be such a trustable location.

I seem to recall there should be something (somewhere) that allows you to "Trust access to current project". I couldn''t find it, but if you come across it then it should be checked.

Since reviewing this properly - See later comments - I''ve remembered that it is something I often need to set to True, but something which should only be set to True for those who know they need it. Developers generally (and not even all of those), or those who have been told to do so by their developer whom they trust fully. In practice this means very few people ever need this set to True, and those who do will probably know that without me telling them.

Be careful with this option. It can be dangerous.

这篇关于办公室更新后，VB代码不再起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！